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 176 to 200
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Around the World Internationally In 2004, Human Sexual Trafficking became a… Tue 11th Jul 2006
Resources There are many resources available for people to learn more … Tue 11th Jul 2006
Planned Giving Fri 7th Jul 2006
Territorial School of Music an… Fri 7th Jul 2006
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
Agincourt Community Church Wed 31st May 2006
Celebration ONETWOFIVE Come to Winnipeg June 15-17, 2007, and celebrate 125 years o… Wed 31st May 2006
DC Scholarships Wed 31st May 2006
Eastwood Corps Wed 31st May 2006
Testify CD Wed 31st May 2006
Candidates - Welcome Candidates Pages: Welcome | CFOT Information | (DFL) Design … Fri 26th May 2006
Residential Health Services The Salvation Army's health services reflect the caring phil… Wed 24th May 2006
The Salvation Army's Response Since its earliest days, The Salvation Army has been committ… Wed 24th May 2006
Canadian Staff Band New website coming soon. Tue 23rd May 2006
Guidelines for Tributes The War Cry is happy to print brief tributes, at no cost, as… Mon 15th May 2006
Letter to all Officers/Salvati… May 11, 2006 All Officers/Salvationists Canada & Bermuda… Fri 12th May 2006
How You Can Help You can help end Human Sexual Trafficking. Here's how: Pray… Wed 10th May 2006
If You Suspect If you suspect that someone you know has been trafficked, or… Wed 10th May 2006