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/web91/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/web91/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 143 Articles: showing 101 to 125
< 1 2 3 4 5 6 >
Title Summary Date
Territorial Camp Report - Part… - by Kim Garreffa With a new staff hierarchy in place, 138 … September 14, 2007
Christmas Promotional CD 2007 Now available through the CATALOGUE $1.25 each Download Chri… September 7, 2007
Who Were the First Female Staf… - by Fred Creighton Possibly, Nellie Griffiths and Florence … September 5, 2007
Praise is a Choice How many times have you joyfully sung the chorus “We b… July 19, 2007
Presenting Scripture - Don't J… If you would like your congregation to not just hear scriptu… June 28, 2007
Music In The Army by Cadet Ashley Bungay As a Church the Salvation Army exists… June 13, 2007
Marked By Love The Guelph Ontario trio, “Marked by Love” has ju… June 4, 2007
Incorporating Scripture in Mus… Download this article for future reference: Incorporating Sc… May 29, 2007
Songs My Father Taught Me Original songs and arrangments of Len Ballantine. "Songs my … May 25, 2007
Tuning A Band - by Douglas Burden, Ottawa -- originally published in Jan-F… May 22, 2007
Reading Band in Peterborough The Reading Central Salvation Army Band visited Peterborough… May 1, 2007
Blended Worship - Making It Wo… Many officers are recognising that to attract outsiders to t… April 30, 2007
The Words of Worship In both Greek & Hebrew, the “worship” word chose… April 18, 2007
New York Staff Band Future All… Canadian participants: Jeremy Smith, Toronto; Riley Thompson… March 27, 2007
Easter Music Suggestions Looking for new song material this Easter? - submitted by K… March 22, 2007
Listen to Salvation Army music… The next Salvation Army broadcast is sponsored by the Guelph… March 19, 2007
Reading Central Band Tour of O… Easter Tour of Canada 30th March to 9th April 2007 Saturday… March 5, 2007
What Is The Main Thing? I like the song that says - I am blessed, I am blessed, Eve… January 29, 2007
Ontario Central Reservist Band… The Ontario Central Reservist Band is a Divisional Band of t… January 23, 2007
Sweetest sound for the sweetes… Spanning our spectacular country from Vancouver Island to Bo… January 9, 2007
Christmas Banding Events Several of Canada's top bands were busy with concerts leadin… January 8, 2007
New Resources For over 125 years Salvation Army bands have been playing in… January 7, 2007
Christmas With The Salvation A… On Saturday, December 2, 2006, the CSB was on hand for the f… December 15, 2006
Tutoring Tutors by Brian Burditt (originally published in THEME, Volume IV, … November 30, 2006
Mountain Citadel Program Exuberance at Mountain Citadel - article by Craig Lewis, pho… November 29, 2006