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 26 to 50
< 1 2 3 4 5 6 >
Title Summary Date
Concert at Mississauga Temple The Mississauga Temple Band (bandmaster Derrick Fishwick) pr… April 1, 2010
Norridge Band & Songsters at N… FREE concert at The Salvation Army North York Temple on Satu… March 29, 2010
Good Friday service at Yorkmin… 8 p.m. Friday April 2nd, 2010, at The Salvation Army Yorkmin… March 25, 2010
Listen to The Salvation Army o… The next Salvation Army broadcast will be Monday March 29th … March 25, 2010
National Music and Gospel Arts… Dates:  August 28 - September 4, 2010 Location: Jackso… March 17, 2010
Easter Concert Featuring Canada's premiere vocal ensemble, The Elmer Iseler… March 15, 2010
Singer Donates CD income to SA… For the next two weeks, all sale proceeeds from country sing… March 2, 2010
Catch Those Clams! Modern Technology has been unable to devise the horn player&… February 10, 2010
saguitarsongs: A valuable reso… saguitarsongs is a website that offers downloads for mo… February 3, 2010
Sounding Brass: The Discipline… “I appeal to you, brothers, in the name of our Lord Je… February 3, 2010
Don't Forget your Home Practic… “Don’t forget your home practice!”  H… January 11, 2010
The Songster's Love Chapter A paraphrase of 1 Corinthians 13... If I could sing with … December 15, 2009
Don't be an instrument abuser! As you are reading this article, hundreds of brass instrumen… December 4, 2009
Singer returns from Uganda Country singer Cathy Harris and her missions team recently r… November 16, 2009
Seeking Lost Manuscripts Above: Bernard Verkaaik Jr, with Emil Soderstrom, circa 1950… November 9, 2009
View videos of National Camp o… Video highlights of this year's National Music & Gospel … October 29, 2009
Singer Organizes Missions Trip While attending Bible school some nine years ago I felt a ca… September 21, 2009
Christmas CDs for sale at amaz… (Click here to enlarge CD cover photo) For only $1.25 eac… September 9, 2009
Ministry Opportunity The Salvation Army Kitchener Community Church (Ontario, Cana… August 4, 2009
The Reason We Sing Ever wonder why we spend so much time singing in our church … July 27, 2009
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
Young Brass Player Competition PRIZES 1st   $1000.00    &nbs… June 10, 2009
The Great Canadian Christmas S… In the Fall of 2009 David C. Cook will be releasing the 5th … June 1, 2009