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/web76/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/web76/web/index.php line 4
Search Results
Skip to Content
Click to print

Search Results

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

Found 229 Pages: showing 151 to 175
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Other News from the Finance De… New MSA Policy In July 2008 the Territorial Finance Council… Mon 6th Nov 2006
Cabinet The Salvation Army's leadership team in Canada and Bermuda p… Wed 1st Nov 2006
Consolidated Financial Stateme… Consolidated Financial Statements - MU Prep Guide - Part I, … Thu 5th Oct 2006
Role And Values Statements Role And Values Statements:  In the delivery of service… Wed 4th Oct 2006
Question 1 What is your biggest challenge as a conductor? Thu 28th Sep 2006
Finance Department Key Contact… Introduction:  The Territorial Finance Department is a … Wed 20th Sep 2006
Territorial Finance Department Welcome!... to the Territorial Headquarters (THQ) Finance De… Wed 20th Sep 2006
(DFL) Design for Life Candidates Pages: Welcome | CFOT Information | (DFL) Design … Wed 13th Sep 2006
Articles Candidates Pages: Welcome | CFOT Information | (DFL) Design … Wed 13th Sep 2006
Candidates "… The harvest is plentiful but the… Wed 13th Sep 2006
Christmas with The Salvation A… Wed 13th Sep 2006
Melbourne Staff Band Concert Wed 13th Sep 2006
Training College Information Candidates Pages: Welcome | CFOT Information | (DFL) Design … Wed 13th Sep 2006
St. John's Temple Mission Afri… Tue 12th Sep 2006
Christmas CD PDF Order Form - Corps/Church WORD Order Form - Corps/Church… Fri 8th Sep 2006
Christmas CD Details Contributors for this year's CD: Brass Bands: St. John's Te… Fri 8th Sep 2006
24/7 Prayer and other links 24-7 Prayer: www.24-7prayer.com "Non-stop prayer acros… Thu 24th Aug 2006
Ethics Centre: About Us Who Are We? Staff James E. Read, Executive Director Direct l… Wed 23rd Aug 2006
Ethics Centre: Main Every day we make hundreds, even thousands of decisions. The… Wed 23rd Aug 2006
Social Issues Committee The Salvation Army, Canada & Bermuda Territory, has reco… Wed 23rd Aug 2006
Extra, Extra, Good News SEE ALSO: Discipleship Programs | Camping Ministry | Sunday … Tue 22nd Aug 2006
Living the Vision Together, the Territorial Leadership is exploring where we a… Wed 16th Aug 2006
Writer's Checklist 12 Keys to Great Magazine Writing 1) Will the story's openi… Fri 21st Jul 2006
Salvationist AD Thu 20th Jul 2006
Anti-Trafficking Network Conta… The Canada & Bermuda Territory established a working gro… Tue 11th Jul 2006