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 26 to 50
< 1 2 3 4 >
Title Summary Date
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
Fall Festival and Parade Weeke… On the weekend of November 14-15, 2009, Salvationists in Tor… November 27, 2009
Tribute - William Burditt William (Bill) Burditt, one of the founding members of … October 28, 2009
Visit to Cobourg On October 3-4, 2009, the CSB was privileged to participate … October 5, 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
Commissioning 2009 Once again the CSB was privileged to support … June 21, 2009
Visit to Simcoe On the weekend of June 6-7, the Canadian Staff Band visited … June 9, 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
40th Anniversary Festival Just over 40 years ago, on January 18, 1969, members of the … June 1, 2009
CSB Hosts Notre Dame Concert B… The Canadian Staff Band joined forces with the University of… May 19, 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
Visit to Collingwood On the weekend of May 2-3, 2009, the Canadian Staff Band was… May 8, 2009
New CD Recorded in Guelph Under the technical expertise of recording engineer Ted… April 8, 2009
Visit to Barrie On the weekend of February 28-March 1, the CSB was privilege… March 2, 2009
Christmas in Toronto 2008 Once again the Canadian Staff Band has completed another bus… December 14, 2008
Benefits in Brass On Saturday, November 15, the Canadian Staff Band was privil… November 29, 2008
Windows of the World CDs Now A… Want a great way to support world missions? And enjoy the … November 1, 2008
Visit to Ontario's Bruce Penin… On the weekend of October 4-5, the Canadian Staff Band launc… October 23, 2008
CSB Commences 40th Anniversary… Following an uneventful summer, the Canadian Staff Band is k… October 15, 2008