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 between 2008-01-01 and 2008-12-31

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

Found 33 Pages: showing 1 to 25
< 1 2 >
Title Summary Date
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
Leigh Rowney   Part Perc… October 23, 2008
Major Ken Smith   Part: Eb … October 23, 2008
Major Kevin Metcalf   Position: … October 23, 2008
Major Ted Kimmins   Position: … October 23, 2008
Nicole Downer   Part: Flu… October 23, 2008
Noel Samuels   Part: Eb … October 23, 2008
Rick Allington   Part: Sol… October 23, 2008
Ron Pearson   Part: 2nd… October 23, 2008
Scott Gross   Part: Bb … October 23, 2008
Serena Doars   Part: Sol… October 23, 2008
Stephen Mansfield   Part: 1st… October 23, 2008
Stephen Pavey   Part: Eup… October 23, 2008
Steve Brown   Part: Sol… October 23, 2008

Found 17 Articles:
Title Summary Date
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
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