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 51 to 75
< 1 2 3 4 >
Title Summary Date
Commissioning Weekend 2008 Once again this year the Canadian Staff Band was privileged … June 30, 2008
Spirit of the West On Saturday, May 31, a packed hall at Scarborough Citadel, T… June 1, 2008
New Executive Officer ‘Tis the season of change, and following the welcome o… May 16, 2008
Mexico Journal - Conclusion Easter Sunday, March 23 Morning did indeed come bright and … May 4, 2008
Mexico Journal - Part 4 by Stan Ewing Good Friday, March 21 Since the Good Friday se… April 30, 2008
Mexico Journal - Part 3 by Stan Ewing Tuesday, March 18 On Tuesday the same daily fo… April 23, 2008
Mexico Journal - Part 2 by Stan Ewing Sunday, March 16 This being Sunday meant that … April 18, 2008
Mexico Journal - Part 1 by Stan Ewing For 10 days before and around the Easter weeke… April 15, 2008
CSB Visits Mexico City Salvationists in Mexico City were thrilled with the ministry… April 3, 2008
CSB Personnel Update - April 2… Followers of the Canadian Staff Band will know that earlier … April 2, 2008
CSB Personnel Update - January… It is with sadness that we announce that Staff Bandsman Stua… February 1, 2008
CSB Personnel News - Wedding B… Congratulations to current CSB member Nicole Pollett on her … January 7, 2008
CSB Wraps Up Another Busy Chri… Once again the Canadian Staff Band has completed another bus… December 17, 2007
New Staff Bandmaster Appointed Colonel Glen Shepherd, chief secretary, has announced that D… November 19, 2007
CSB Personnel Update - October… The Canadian Staff Band is pleased to welcome Cameron Rawlin… October 25, 2007
CSB Visits Kitchener To kick off the 2007/08 season, the Canadian Staff Band was … October 22, 2007
Happy 75th - The Salvation Arm… On Tuesday, September 25, 2007, The Salvation Army joined wi… September 27, 2007
CSB Personnel Update - Sept. 2… As the CSB once again looks forward to another busy year of … September 11, 2007
Welcome Welcome to the official website for the Canadian Staff Band.… September 11, 2007
CSB Present to Welcome New Ter… On Thursday, July 12, the Canadian Staff Band joined Salvati… July 16, 2007
CSB Beats the Army Drum in Win… by Staff Bandsman Major Ken Smith In June 2004, the Canadian… June 21, 2007
CSB Personnel Changes - June 2… At the end of another busy season, the CSB is bidding farewe… June 21, 2007
CSB Beginners’ Band Sup… Shown above are grateful recipients from Wiarton Community C… April 10, 2007
CSB Personnel April 2007 Updat… Personnel Update The CSB is once again undergoing some chang… March 26, 2007
CSB Weekend in Toronto and Lon… The Canadian Staff Band was involved in an interesting event… March 14, 2007