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 1 to 25
< 1 2 3 4 5 6 >
Title Summary Date
SA Radio The next Salvation Army Broadcast will be Monday, March… March 7, 2011
Mississauga Temple Band presen… "Music Extravaganza!" features cornet soloist… March 1, 2011
The Marks of Professionalism A friend of mine who is a high school band director sent me … February 8, 2011
Babysong CDs now available "Boom Chicka Boom" is a 2 CD set that gives you a … February 3, 2011
S.A. Meadowlands Corps present… The Salvation Army Meadowlands Band is Holding it's 41st. Yo… January 12, 2011
Christmas Resources Song ideas January 11, 2011
Worship Team Resources Anchors and Sails January 11, 2011
Looking for Accompaniment CDs? Are you in a situation where there are no musicians availabl… January 10, 2011
Spirit of the Season Inspirational Christmas music, dessert and coffee, held at T… November 16, 2010
Christmas Coffee House Come join the Mountain Citadel Band and musical soloists in … November 8, 2010
New Book Release "Ever Heard the Sound?" is all about the life… October 18, 2010
Bermuda Fall Festival The Salvation Army West End Community Church is hosting a Fa… October 13, 2010
Christmas Concert Spectacular A spectacular evening of Christmas music with a cast of over… October 1, 2010
The 2010 Territorial Christmas… Click here to see a larger version of the cover. At onl… September 22, 2010
It was a hot time at National … (To view a larger version, click picture) Even record hot… September 17, 2010
Breath Control: The Embouchur… Most of the people reading this will already have developed … August 9, 2010
Breath Control: Part Two For part one, click here. Part Two: With the Instrument … July 7, 2010
Instruments Wanted A fourth year music student at McMaster University (Ontario)… July 7, 2010
Breath Control for Brass Playe… Part One – Without the Instrument   When one th… June 16, 2010
The Next SA Radio Broadcast The next Salvation Army radio broadcast will be Mo… May 27, 2010
Why Can't I Play in Tune Who would believe that by making a Bronx cheer into a metal … May 27, 2010
Enjoy a spring concert in Hami… Featuring The Vernon Festival Praise and Worship Team, The M… May 3, 2010
Looking for Christmas recordin… We are now accepting submissions for the 2010 Territorial Ch… May 3, 2010
Cameron Rawlins releases his f… Cameron Rawlins debuts on the music scene with a self-titled… April 14, 2010
Regarding Anchors and Sails I was reading an article a few years ago with a title that h… April 12, 2010