SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  COALESCE(MIN(DATE(`history_created_date`)),'0000-00-00') `min`,
  COALESCE(MAX(DATE(`history_created_date`)),'0000-00-00') `max`
FROM
  `pages`
WHERE
  `history_created_date`>'1000-00-00' AND
  `systemID` IN()

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8

Call stack trace:
[12] Record::get_record_for_sql() via /var/www/2380/classes/class.system.php line 769
[11] System::get_global_date_range() via /var/www/2380/classes/class.search.php line 101
[10] Search::_draw_controls() via /var/www/2380/classes/class.search.php line 297
[09] Search::_draw_results() via /var/www/2380/classes/class.search.php line 90
[08] Search::draw() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web75/web/index.php line 4

SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  COALESCE(MIN(DATE(IF(`type`='event',`effective_date_start`,`date`))),'0000-00-00') `min`,
  COALESCE(MAX(DATE(IF(`type`='event',`effective_date_start`,`date`))),'0000-00-00') `max`
FROM
  `postings`
WHERE
  IF(`type`='event',`effective_date_start`,`date`)>'1000-00-00' AND
  `systemID` IN()

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8

Call stack trace:
[12] Record::get_record_for_sql() via /var/www/2380/classes/class.system.php line 779
[11] System::get_global_date_range() via /var/www/2380/classes/class.search.php line 101
[10] Search::_draw_controls() via /var/www/2380/classes/class.search.php line 297
[09] Search::_draw_results() via /var/www/2380/classes/class.search.php line 90
[08] Search::draw() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web75/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results for category Ethics Centre Feature

Text:
Categories:
Tags:
Date Range:
- to -
Items:
Sites:

Found 42 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Respect There is something I would like to share with you, - it…
Txt Cmmndmnts The 10 Commandments, in TXT Spk: #3: No OMGs BY Cliff KuangF…
A Great Friend has Moved On Booth College and the Salvation Army Ethics Centre said good…
God's Chisel Here is a beautiful video shared with me by a friend on Face…
The New Urbanism There’s a movement afoot called ‘The New Urbanis…
To the Struggle Against World …   The artist, Zurab Tsereteli, w…
By My God I Leap Over Walls By my God I leap over walls (Psalm 18:29) A theological re…
A Grandmother's Tribe Set between a tiny village and the largest slum in Africa, c…
Poverty and Corruption Poverty and Corruption By Colleen Marshall Originally publ…
Ethics and Pandemics   In the flurry of activity and worry around the new &…
Commuter Challenge 2009 Join us for the 10th anniversary of Commuter Challenge in Ma…
Street Folk of Old? We were reminded of a delightful old song this week.  T…
Earth Keeping We missed Earth Hour here in the EC - did you know about Ear…
Words, Words, Everywhere Words I find language fascinating and flummoxing (now there’…
Gossip Lessons There was an interesting article in the New York Times last …
Easter Greetings from Howard H… “When you pass through the waters, I will be with you;…
The Church: Where the Poor Fee… St. Lawrence was a Deacon of Rome who was martyred in 258 C.…
Alzheimer's Art Quilt Initiati… The Alzheimer's Art Quilt Initiative (AAQI) is an Internet-d…
Blogging About Poverty It’s possible that even though one may not know much a…
Happy Birthday, Dear Darwin!   Born 200 years ago, Darwin has been among bo…
Tippers and a 'Tippee' and...W… A  provocative post from an articulate and in…
Christmas in February! THE ZIMBABWE BULLETIN       &…
Human trafficking set to incre… One year from now, people from around the world will gather …
Sayings and Prayers The ancients had a saying: “As above, so below”.…
Can Obama ever deliver a speec… Can President Barack Husein Obama ever deliver a speech! I …