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 for tag Worship

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

Found 25 Articles:
Title Summary Date
The Marks of Professionalism A friend of mine who is a high school band director sent me … February 8, 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
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
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
Good Friday service at Yorkmin… 8 p.m. Friday April 2nd, 2010, at The Salvation Army Yorkmin… March 25, 2010
saguitarsongs: A valuable reso… saguitarsongs is a website that offers downloads for mo… February 3, 2010
On Keys, Choruses and Congrega… Occasionally, in working with worship teams, the subject of … July 13, 2009
Should Christians listen to se… This depends on several factors:    a) The matu… July 3, 2009
Praise is a Choice How many times have you joyfully sung the chorus “We b… June 11, 2009
The Great Canadian Christmas S… In the Fall of 2009 David C. Cook will be releasing the 5th … June 1, 2009
Deconstructing Copyright May 6, 2009
WECC Gospel Arts Weekend Click here for a larger version of the picture. The weeke… April 15, 2009
Singing for Watoto www.thepacket.ca Cathy Harris wears her faith on her … February 3, 2009
Marching on Two Legs Written by Lt. Col. David Hammond (R) Reprinted from THEM… January 21, 2009
The Salvation Army's 'Secular'… (This article was originally published in the Jan-Feb-Mar 20… December 29, 2008
New Christmas Song Ideas For Y… There are a lot of congregational-friendly Christmas songs o… December 2, 2008
There's a new website in town The Salvation Army Music and Gospel Arts Department has offi… October 28, 2008
Buy a CD, support a good cause     Michael Bannerman is a Canadian Gospel Mus… September 12, 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