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 60 Pages: showing 1 to 25
< 1 2 3 >
Title Summary Date
Emily Ewing   Part: 1st… December 8, 2010
Mathias Divert   Part: 1st… December 8, 2010
Ian Watkinson   Part: 2nd… September 13, 2010
Sherie Keogh   Part: Sol… April 21, 2010
Jeremy Smith Part: 1st Baritone … February 25, 2010
Contact Us You may reach us as follows: Postal Address: The Salva… January 5, 2010
Joshua Bailey    Part: … September 15, 2009
Kevin Wilson   Part Per… August 19, 2009
Repertoire The CSB currently contains the following pieces in its conce… June 10, 2009
Archives Here you can search our archives of pages and posts since ou… June 8, 2009
Poll June 8, 2009
Recordings Available Now: All CDs available through The Salvation A… June 8, 2009
Upcoming June 4, 2009
Andrew Burditt   Part: Sol… October 23, 2008
Bob Gray   Part: 2nd… October 23, 2008
Cameron Fraser   Part: Sol… October 23, 2008
Cameron Rawlins   Part: Eup… October 23, 2008
Craig Lewis   Part: 1st… October 23, 2008
Dave Rayment   Part: Bb … October 23, 2008
Derek Ritson   Part: So… October 23, 2008
Doug Elvin   Part: 1st… October 23, 2008
Jeremy Avery   Part: Eb … October 23, 2008
John Avery   Part: 2nd… October 23, 2008
John Lam   Position: … October 23, 2008
Ken Bailey   Part: 2nd… October 23, 2008

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

Found 5 Events:
Title Summary Date
Retirement of Territorial Lead… Retirement of Commissioners William and Marilyn Francis Met… June 26, 2011
Commissioning Commissioning of New Officers Metro Toronto Convention Cent… June 25, 2011
ISB 120 Tour Tour of The Netherlands and Germany/ISB 120 Weekend Friday,… May 27, 2011
Corps Weekend - Listowel, Onta… Saturday-Sunday, April 30-May 2, 2011 The Salvation Army 6… April 30, 2011
Concert with New York Staff Ba… Friday, March 4, 2011 Dinner and Fellowship with CSB Sat… March 5, 2011