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 51 to 75
< 1 2 3 4 5 6 >
Title Summary Date
Canadian Soloist Impresses Dut… On Saturday May 16th the Dutch annual Music Congress was hel… May 19, 2009
Deconstructing Copyright May 6, 2009
WECC Gospel Arts Weekend Click here for a larger version of the picture. The weeke… April 15, 2009
Christmas Recordings Wanted! We are now accepting submissions for the 2009 Territorial Ch… March 25, 2009
Bass Trombone for sale  Shires bass trombone - independent, inline thayer va… March 10, 2009
Looking for a Band? Find web-links to all your favourite Salvation Army Bands fr… February 27, 2009
Singing for Watoto www.thepacket.ca Cathy Harris wears her faith on her … February 3, 2009
The Songster Leader's Almanac … It takes only one bad voice, or one very good one, to ruin a… February 2, 2009
Marching on Two Legs Written by Lt. Col. David Hammond (R) Reprinted from THEM… January 21, 2009
Confessions of a Corps Bandsma… - written by Steven Barrett (Corner Brook Temple Newfoundlan… January 13, 2009
The Salvation Army's 'Secular'… (This article was originally published in the Jan-Feb-Mar 20… December 29, 2008
Maritimer releases first CD   Stephen Huntley was born July 10, 1961 in the be… December 23, 2008
New Christmas Song Ideas For Y… There are a lot of congregational-friendly Christmas songs o… December 2, 2008
World Missions raises funds th… click here for larger photo An international project more… November 17, 2008
When the Staff Band rode Bicyc… Click here for a larger picture In the 1890s, The Canadia… November 11, 2008
There's a new website in town The Salvation Army Music and Gospel Arts Department has offi… October 28, 2008
A Christmas Tapestry CD now av… Our Territorial Christmas CD is now available to purchase!&n… October 20, 2008
The Power of Music: Part Two - written by David Robinson-Cooke (Reprinted from the Apr… October 1, 2008
The Power of Music part one - by David Robinson-Cooke Reprinted from THEME Jan-Feb-Ma… September 18, 2008
Buy a CD, support a good cause     Michael Bannerman is a Canadian Gospel Mus… September 12, 2008
Order your Christmas CDs now! (Click here for larger image) Now that summer is over it'… September 4, 2008
It's All in the Warm-Up - written by Harold Burgmayer   (This article … August 21, 2008
Tuning a Band... Part Two Tuning a Band – part two – written by Douglas Bu… August 14, 2008
The Music of The Salvation Arm… The Music of The Salvation Army - written by Staff-Capt… August 11, 2008
Transitions: Forming worship … So you’ve come up with a list of potential songs for S… July 31, 2008