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

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

Found 88 Articles: showing 1 to 25
< 1 2 3 4 >
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
2010 Christmas in Toronto December has been a busy month for the CSB as we were once a… December 15, 2010
2010 Fall Festival and Parade … On the weekend of November 20-21, 2010, Salvationists in Tor… December 1, 2010
Personnel Update - December 20… The CSB is pleased to announce the addition of two new membe… December 1, 2010
Visit to Mountain Citadel To kick of its 2010-11 season, the Canadian Staff Band was p… October 25, 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
Great American Brass Band Fest… The weekend of June 11-13, the CSB was privileged to partici… June 21, 2010
Tribute - Stanley Dean The CSB is saddened to announce the loss of one of its origi… June 15, 2010
41st Anniversary Festival An air of excitement and anticipation swept through the … June 3, 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
Visit to Midland The CSB was privileged to support the Midland Corps, Ontario… May 3, 2010
Personnel Update - April 2010 The Canadian Staff Band is pleased to welcome Sherie Keogh i… April 21, 2010
'A Day in the Life' Staff Bandsman Craig Lewis has posted a photo journal - &quo… April 13, 2010
CD Update The CSB has now recorded the tracks for our upcoming CD,&nbs… April 12, 2010
HSSB Festival of Brass Following a busy three days of recording, the CSB was the fe… 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
Visit to Hamilton Meadowlands The CSB was pleased to visit the Meadowlands Corps in Hamilt… March 16, 2010
Personnel Update - February 20… The Canadian Staff Band is pleased to welcome Jeremy Smith i… February 25, 2010
Visit to Guelph For our first engagement of 2010, the Canadian Staff Band wa… February 19, 2010
Christmas in Toronto 2009 December was a busy month for the CSB as we were on duty for… December 14, 2009