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 76 to 100
< 1 2 3 4 5 6 >
Title Summary Date
Celebrating 125 years of Bandi… The Meadowlands (formerly Hamilton Temple) and London Citade… July 28, 2008
A Question of Content – Major Len Ballantine Reprinted from the Jan-Feb-Mar… July 17, 2008
Children of a Lesser God: A Pa… – Len Ballantine Adapted from the original article pr… June 20, 2008
How’s Your Stage Presen… - Kim Garreffa Whether singing, speaking, or playing an ins… May 29, 2008
The Songster Leader's Almanac … compiled by Jane Lam and Bob Young It takes only one bad voi… May 15, 2008
“Church On Fire” B… Manny Pereira, Andrea Russell, Bob Hesselink, Peter Howells,… May 8, 2008
Christmas Recordings Needed! You are invited to submit an audio recording for considerati… April 14, 2008
A Slice of Canadian History A REMARKABLE VISIT TO CANADA The first visit of a British Sa… April 10, 2008
Maritime Maestro Peter van der Horden Lieutenant Commander (R) Canadian Forc… March 18, 2008
North American Composer's Foru… Larger Image- written by Manny Pereira, Georgetown Ontario G… March 12, 2008
Salvation's Blast by Stan Ewing The Hannaford Street Silver Band (HSSB) presen… March 3, 2008
Wanted: Eb Horn Majors Shane and Pauline Gruer-Caulfield are Canadian office… January 9, 2008
Salvation Army Broadcast The next  two-hour Salvation Army broadcast is on Monda… December 27, 2007
Instruments For Sale BBb Bass Besson Imperial (Compensating valves but no 4th val… December 10, 2007
Salvation Army Broadcast The next Salvation Army broadcast is sponsored by the Cambri… November 23, 2007
Expressions - submitted by Stan Ewing I had the opportunity again this y… November 19, 2007
Mountain Citadel Band CD Featuring: 1. Fanfare and Flourishes (Martin Cordner) 2.… November 5, 2007
Worship in the 21st Century - Col. Gwenyth Redhead (R) This article is adapted from a s… October 29, 2007
Music & Gospel Arts Camp - Bos… On Thursday, 12th July 2007, I (YP B/M Jerome Astwood of WEC… October 22, 2007
Ah...The Good Old Days! Larger Image - by Fred Creighton In the ‘old days  October 16, 2007
Piano Stylings for Worship Len Ballantine Reprinted from the Apr-May-Jun 2005 issue of … October 10, 2007
Salvation Army Broadcast - Oct… The next Salvation Army broadcast will be on Monday, October… October 10, 2007
Territorial Camp Report - Part… Read Part I, Part II Thursday evening was a time of wor… October 2, 2007
Territorial Camp Report - Part… Read Territorial Camp Report - Part I Another Tuesday highl… September 21, 2007
Salvation Army Broadcast - Sep… The next S.A. broadcast will be on Monday September 24 from … September 15, 2007