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 26 to 50
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Positions de principe (francai… Avortement Peine capitale Euthanasie, suicide assist&eacut… Tue 28th Oct 2008
Privacy Policy This website's policy is to respect and protect the privacy … Tue 28th Oct 2008
Correctional and Justice Servi… The Salvation Army offers material, emotional and spiritual … Thu 23rd Oct 2008
Partners in Mission Welcome to the 2009 Partners in Mission Resource Page. He… Fri 17th Oct 2008
Heartbeat Podcast Episodes Heartbeat is the official news podcast of The Salvation Army… Mon 15th Sep 2008
Darlene's Test The last weekend  Darlene's Test of April brought t… Thu 11th Sep 2008
Margaret's Test Typing my text into the box While in His Hands, for one m… Thu 11th Sep 2008
Christmas with Salvation Army Tue 2nd Sep 2008
Edmonton Temple Band Anniversa… Tue 2nd Sep 2008
Justice/Ethics For more information about social justice and ethics, please… Tue 2nd Sep 2008
Around The Territory - Last 15… (Click here to see more entries...) (Click here to see more… Wed 20th Aug 2008
Booth College Advertisement For more information visit www.boothcollege.ca. Email conta… Thu 31st Jul 2008
Urban Forum 2009 For more information visit www.theurbanforum.com Thu 31st Jul 2008
Sign Up Mon 21st Jul 2008
Careforce Devotional Here are some resources that can be used: July 2008 Wed 16th Jul 2008
Home Missions 2007 Ontario Great Lakes Division Raised: $61,639 100% of the H… Thu 3rd Jul 2008
Home Missions 2008 Projects by Division Free downloadable resources for Home M… Thu 3rd Jul 2008
Sign In If you have forgotten your password, click here. Sat 7th Jun 2008
Sitemap Fri 6th Jun 2008
Archives Here you can search our archives of pages and posts since ou… Thu 5th Jun 2008
Search Results Thu 5th Jun 2008
Telling The Army Story Use your mouse over the image below and click on the images … Thu 5th Jun 2008
Tags Tags Mon 2nd Jun 2008
Service Opportunities Overseas The following are the latest service opportunities list prov… Thu 29th May 2008
All Ontario Junior Music Camp … Wed 28th May 2008