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/web76/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/web76/web/index.php line 4
Search Results
Skip to Content
Click to print

Search Results between 2008-04-01 and 2008-04-30

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

Found 16 Articles:
Title Summary Date
Responding to God’s Cal… The decision I made to become a soldier of The Salvation Arm… Wed 30th Apr 2008
Catch the Vision Dr. Jeremy Mills, Chair, Symposium2008At Symposium 2008, del… Tue 29th Apr 2008
Gateway Linens Opens Doors for… Dion Oxford and Jay Hockaday help prepare the new laundry fa… Mon 28th Apr 2008
New Mattresses for Yellowknife… Cpt Dale Sobool, northern territories ministry co-ordinator,… Sat 26th Apr 2008
Annual Change 2008 See a pdf version here: Annual Change 2008 ANNUAL CHANGE 200… Fri 25th Apr 2008
Job Opportunity - Editor of Sa… If you have writing and web management skills, submit your r… Fri 25th Apr 2008
Pray for Zimbabwe The Chief of the Staff, Commissioner Robin Dunster is urging… Fri 25th Apr 2008
Miraculous Makeovers - VisionT… Miraculous makeovers: VisionTV's Divine Restoration returns … Thu 24th Apr 2008
Privilege or Pledge? In an age of customer loyalty cards and rewards programs, ha… Thu 24th Apr 2008
New Candidates Accepted for Pr… Nine new candidates have been accepted to enter CFOT in Winn… Mon 21st Apr 2008
We Need Heroes Rescuing the Army’s military metaphor from a quaint h… Mon 21st Apr 2008
Outside the City Gates Tackling the HIV/AIDS pandemic in Africa means walking with … Thu 10th Apr 2008
Excerpts From My Journal Here I am, 30,000 feet in the air with God’s creation… Thu 3rd Apr 2008
General's Pastoral Letters Num…       April 2008 - From the Office of th… Thu 3rd Apr 2008
Kenora and Dryden Thrift Store… As of April 1, 2008 the Kenora and Dryden Thrift Stores are … Wed 2nd Apr 2008
Discipleship Forum II: Nurturi… Discipleship Forum is about a gathering of minds, hearts and… Tue 1st Apr 2008