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/web91/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/web91/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results for category

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

Found 15 Articles:
Title Summary Date
SA Radio The next Salvation Army Broadcast will be Monday, March… March 7, 2011
Mississauga Temple Band presen… "Music Extravaganza!" features cornet soloist… March 1, 2011
S.A. Meadowlands Corps present… The Salvation Army Meadowlands Band is Holding it's 41st. Yo… January 12, 2011
Spirit of the Season Inspirational Christmas music, dessert and coffee, held at T… November 16, 2010
Christmas Coffee House Come join the Mountain Citadel Band and musical soloists in … November 8, 2010
Bermuda Fall Festival The Salvation Army West End Community Church is hosting a Fa… October 13, 2010
Christmas Concert Spectacular A spectacular evening of Christmas music with a cast of over… October 1, 2010
The Next SA Radio Broadcast The next Salvation Army radio broadcast will be Mo… May 27, 2010
Enjoy a spring concert in Hami… Featuring The Vernon Festival Praise and Worship Team, The M… May 3, 2010
Concert at Mississauga Temple The Mississauga Temple Band (bandmaster Derrick Fishwick) pr… April 1, 2010
Norridge Band & Songsters at N… FREE concert at The Salvation Army North York Temple on Satu… March 29, 2010
Good Friday service at Yorkmin… 8 p.m. Friday April 2nd, 2010, at The Salvation Army Yorkmin… March 25, 2010
Listen to The Salvation Army o… The next Salvation Army broadcast will be Monday March 29th … March 25, 2010
National Music and Gospel Arts… Dates:  August 28 - September 4, 2010 Location: Jackso… March 17, 2010
Easter Concert Featuring Canada's premiere vocal ensemble, The Elmer Iseler… March 15, 2010