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-06-01 and 2008-06-30

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

Found 6 Pages:
Title Summary Date
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

Found 11 Articles:
Title Summary Date
Dangerous Games The run-up to the Olympics has been clouded by protests over… Mon 30th Jun 2008
Chief Secretary's First Quarte… HEADLINES Evangelism Children & Youth Ministry Carefo… Tue 24th Jun 2008
God’s Fellow Workers Co… “For the past two years, God has been shaping your hea… Tue 24th Jun 2008
Domestic Abuse and the Way Out At Kate Booth House, one woman learns to feel beautiful agai… Mon 23rd Jun 2008
Recapturing the Wonder Newfoundland West Women’s Camp Four hundred women m… Thu 19th Jun 2008
Making Red Deer 'Green' Corps members help clean up Red Deer’s parks An ent… Wed 18th Jun 2008
A Career in Music Music and The Salvation Army have been the central pillars o… Mon 16th Jun 2008
General's Pastoral Letters Num… June 2008 - From the Office of the General to Salvation… Mon 16th Jun 2008
A Willing Heart Ministry should be a joy, not a burden I don’t know a… Mon 9th Jun 2008
Smithers Salvation Army Center… Renovations of the Salvation Army thrift store, community an… Tue 3rd Jun 2008
Let's Talk About Sex As a parent, how do you counsel kids to abstain? Is “s… Mon 2nd Jun 2008