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 category THEME News

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

Found 85 Articles: showing 1 to 25
< 1 2 3 4 >
Title Summary Date
Babysong CDs now available "Boom Chicka Boom" is a 2 CD set that gives you a … February 3, 2011
New Book Release "Ever Heard the Sound?" is all about the life… October 18, 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
Instruments Wanted A fourth year music student at McMaster University (Ontario)… July 7, 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
Singer Donates CD income to SA… For the next two weeks, all sale proceeeds from country sing… March 2, 2010
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
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
Canadian Soloist Impresses Dut… On Saturday May 16th the Dutch annual Music Congress was hel… May 19, 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
Maritimer releases first CD   Stephen Huntley was born July 10, 1961 in the be… December 23, 2008
World Missions raises funds th… click here for larger photo An international project more… November 17, 2008
There's a new website in town The Salvation Army Music and Gospel Arts Department has offi… October 28, 2008