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

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

Found 229 Pages: showing 51 to 75
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
All Ontario Junior Music Camp … www.ilovecamp.ca Wed 28th May 2008
Home Missions Supports Our Fir… “…he who gathered muc… Wed 14th May 2008
Evangelism and Witness Newfoundland and Labrador Provincial Congress June 27 - 29, … Thu 20th Mar 2008
Emergency Disaster Services Tr… Wed 5th Mar 2008
Booth Campus Visit Days More Booth College Info Email: admissions@boothcollege.ca W… Wed 20th Feb 2008
Imagine She Is Your Child How committed would you be to her safety? The Salvation Army… Wed 20th Feb 2008
Visit the Holy Land 2008 Visit the Holy Land in 2008 October 22 - November 5 15 Days … Wed 20th Feb 2008
testing rss Fri 8th Feb 2008
All Podcasts Fri 25th Jan 2008
Multicultural Conference For more information contact Ruth Kimmins or Holly Patterson Mon 7th Jan 2008
Partners In Mission Partners in Mission Resource Kits have now arrived in corps.… Mon 7th Jan 2008
Deeks Insurance www.deeksinsurance.ca Thu 20th Dec 2007
dropdown test Go To: TopBritish Columbia     Red … Thu 20th Dec 2007
Ignite More about Ignite Thu 20th Dec 2007
National Social Services Confe… For more information contact Joanne Tilley Thu 20th Dec 2007
Symposium 2008 For detailed information visit the Symposium 2008 website. … Thu 20th Dec 2007
The Flame Thu 20th Dec 2007
Checkout Checkout Mon 17th Dec 2007
All Events All Events Mon 3rd Dec 2007
All News All News Thu 29th Nov 2007
RBC Banking and the Salvation … Royal Bank of Canada In July 2007, the Salvation Army in Ca… Wed 28th Nov 2007
Online Christmas Kettle Tue 27th Nov 2007
Scarborough Citadel Reunion Tue 27th Nov 2007
Magazine Outreach Ways Your Church Can Share Faith & Friends Faith & F… Mon 26th Nov 2007
(Untitled) Wed 21st Nov 2007