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

Search Results for category CSB News

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

Found 46 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
2011 Season Update The CSB had its first rehearsal of 2011 on January 5th and i… January 6, 2011
CSB Family Continues to Grow Congratulations to CSB percussionist Leigh Rowney and his wi… January 5, 2011
Older CSB Albums Now Available… For your listening pleasure, the Canadian Staff Band is happ… December 17, 2010
Personnel Update - December 20… The CSB is pleased to announce the addition of two new membe… December 1, 2010
A New Season Begins As the Canadian Staff Band commences its 42nd anniversary se… September 13, 2010
Personnel Update - September 2… As the Canadian Staff Band commences another busy season, we… September 13, 2010
Tribute - Stanley Dean The CSB is saddened to announce the loss of one of its origi… June 15, 2010
CSB Alumni President Appointed During the reception following the recent anniversary f… June 3, 2010
Here We Grow Again Congratulations to the following staff band members and… June 2, 2010
ISB 120th Anniversary - June 3… As followers of The Salvation Army’s International Sta… May 21, 2010
Personnel Update - April 2010 The Canadian Staff Band is pleased to welcome Sherie Keogh i… April 21, 2010
CD Update The CSB has now recorded the tracks for our upcoming CD,&nbs… April 12, 2010
New CD in the works The CSB will once again be going under the mics April 7, 9-1… March 16, 2010
Personnel Update - February 20… The Canadian Staff Band is pleased to welcome Jeremy Smith i… February 25, 2010
Personnel Update - December 20… Following our recent Christmas activities, CSB members took … December 14, 2009
Tribute - Marvin Kitney The Canadian Staff Band is saddened to announce the loss of … December 8, 2009
Tribute - William Burditt William (Bill) Burditt, one of the founding members of … October 28, 2009
A New Season Begins The Canadian Staff Band has kicked off its 41st season … September 15, 2009
Blasts from the Past Long-time followers of the CSB will appreciate a brand new c… August 18, 2009
Personnel Update At the end of another busy season, the CSB is bidding farewe… June 22, 2009
International Visitors Attend … On Wednesday, June 3, the CSB was privileged to have two vis… June 5, 2009
CSB Alumni Gather for Annivers… On Saturday, May 31, former members of the Canadian Staff Ba… June 4, 2009
95th Memorial Service for Empr… On Sunday, May 31, 2009, a large crowd of Salvation Army off… June 2, 2009
New Additions to CSB Family Congratations to the following staff bandsmen and their… May 11, 2009
Canadian Composer Visits CSB R… On Wednesday, May 6, composer William Gordon dropped in as a… May 8, 2009