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 between 2006-06-01 and 2006-06-30

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

Found 8 Pages:
Title Summary Date
Salvation Army Doctrines on DV… WE BELIEVE is a DVD set containing the eleven Salvation Army… Mon 19th Jun 2006
Archives and Museum Archives The archives are the official repository for The S… Thu 8th Jun 2006
Useful Links The links below are provided to help you find more informati… Thu 8th Jun 2006
Employee Assistance Program YOUR EMPLOYEE ASSISTANCE PROGRAM is professional, confidenti… Tue 6th Jun 2006
Release the Captives-Prayer We… The following are resources that can be used to pray for the… Mon 5th Jun 2006
Weekend of Prayer for Human Se… September 26-28, 2008 is The Salvation Army’s 3rd Annu… Mon 5th Jun 2006
Faith and Friends Fri 2nd Jun 2006
More information The following are additional communication tools in regard t… Fri 2nd Jun 2006

Found 47 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Episode 192: The Salvation Arm… The Salvation Army Connection: Ep… Fri 30th Jun 2006
Targeting the Army Brand The public appreciates what we do in a disaster, but sometim… Fri 30th Jun 2006
Booth College, President's E-M… JUNE 2006 www.boothcollege.ca Canada and Bermuda Territory E… Thu 29th Jun 2006
New Candidates Accepted Three new candidates have been accepted to the 2006-2008 ses… Thu 29th Jun 2006
The Second Chance - Christian … On July 18th, 2006, Sony Pictures Home Entertainment (sonypi… Thu 29th Jun 2006
Canada and Bermuda's mission t… Monday, June 19 On Monday morning the team spent time in dif… Wed 28th Jun 2006
Manitoba and NW Ontario Divisi… Extreme Makeover - Inside Edition Ecclesiastes 3:1 (KJV) tel… Wed 28th Jun 2006
Shaved heads in Prince George,… Prince George Community Church, B.C. set a goal to raise $4,… Wed 28th Jun 2006
Are We the Church of the Poor? The body of Christ is more than the sum of its parts. All Ch… Tue 27th Jun 2006
New officers prepare for minis… This month the Canada and Bermuda Territory welcomes 13 new … Fri 23rd Jun 2006
St. John's CFOT - A Lasting Le… 116 years of officer training comes to an end in Newfoundlan… Fri 23rd Jun 2006
Episode 191: The Salvation Arm… The Salvation Army Connection: Ep… Thu 22nd Jun 2006
New Centre brings hope to Nana… Officially underway is a new housing establishment aimed at … Thu 22nd Jun 2006
The How-to Handbook for Effect… Contact: International Christian Ministries 19978-72 Ave, La… Thu 22nd Jun 2006
Collingwood community church h… Collingwood community church YPSM Gail Synnott honours new t… Wed 21st Jun 2006
DVD-Doctrine Series (audio MP3… WE BELIEVE ' is a DVD set containing the eleven Salvation Ar… Wed 21st Jun 2006
Update No. 2 from Canada and B… Tuesday, June 13, 2006 Tuesday evening brought soccer traini… Tue 20th Jun 2006
Women Connected 2006 On May 26-28, 2006, the London, Ont., Convention Centre buzz… Tue 20th Jun 2006
Episode 190: The Salvation Arm… The Salvation Army Connection: Ep… Mon 19th Jun 2006
Shopping for faith What has the church ever done for me? A critique of "consume… Mon 19th Jun 2006
The Salvation Army, Regina, br… On June 8, 2006, The Salvation Army in Regina launched 'It's… Mon 19th Jun 2006
Edmonton West rotary club help… The Rotary Club of Edmonton West donated a 15-passenger vehi… Sun 18th Jun 2006
Bandmaster Returns to Lead CSB Brian Burditt, who led the Canadian Staff Band from 1985 to … Fri 16th Jun 2006
New appointment for territoria… Effective May 1, 2006, R. Paul Goodyear, territorial financi… Fri 16th Jun 2006
World Cup defender tells of hi… What do Brazil, Germany, Italy, Argentina, Uruguay, France a… Thu 15th Jun 2006