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 1208 Articles: showing 726 to 750
< 1 2 … 28 29 30 31 32 … 48 49 >
Title Summary Date
The Salvation Army contributes… The former community policing office located at The Salvatio… Thu 1st Mar 2007
Bestselling author to visit To… Philip Yancey, one of the most significant Christian writers… Wed 28th Feb 2007
New York Staff Band On Sunday March 4, 2007 the New York Staff Band (Bandmaster … Wed 28th Feb 2007
Recycle your suits Altered possibilities is a ministry by Canadian women, for C… Wed 28th Feb 2007
Chaplain blazes path of hope At the beep of a pager, he could be called to a fire scene t… Tue 27th Feb 2007
Salvation Army to open its fir… Victoria, B.c. - In three weeks the Beacon of Hope House is … Tue 27th Feb 2007
Banking on Your Support We asked corps around the territory what they are doing to r… Mon 26th Feb 2007
Don’t expect to see ATM… Offerings of plastic could be the next big thing for churchg… Mon 26th Feb 2007
Episode 226: The Salvation Arm… 'Jesus of Hollywood' is a new boo… Mon 26th Feb 2007
New youth commitments Penticton, BC, has recently experienced another exciting wee… Fri 23rd Feb 2007
Toronto Star editor-in-chief h… Toronto Star editor-in-chief Fred Kuntz was honoured for com… Fri 23rd Feb 2007
Ain't broke, don't fix it IN professional sports, there are only two kinds of managers… Thu 22nd Feb 2007
Family skate night The Deer Run Community Centre in Calgary was the setting for… Thu 22nd Feb 2007
Cadet Lieutenant training In September 2006, the Chief Secretary, on behalf of The Ter… Wed 21st Feb 2007
Salvation Army broadcast Tom Quick is a third generation Salvationist who worships at… Wed 21st Feb 2007
Women's ministries mission tri… From Feb. 16 - March 4, 2007, the following members of the t… Wed 21st Feb 2007
A season for reflection Lent is a forty-day period before Easter. It begins on Ash W… Tue 20th Feb 2007
Alberta family day Alberta Family Day is celebrated on the third Monday of Febr… Tue 20th Feb 2007
Feed the soul with a purge I’ve discovered the secret to weight loss. Give it aw… Tue 20th Feb 2007
Myanmar - A world apart   It is better that you do not use the cameras if there are po… Mon 19th Feb 2007
A new officer in Québec On February 8th, cadet Désiré Mounanga was ordained as… Fri 16th Feb 2007
CIDA Update International development work is based on partnerships that… Fri 16th Feb 2007
Episode 225: The Salvation Arm… 'Jesus of Hollywood' is a new boo… Fri 16th Feb 2007
Social justice festival The third annual White Rock/South Surrey, BC, social justice… Fri 16th Feb 2007
Canadian Idol is back Canadian Idol is coming back for a fifth season. Auditions a… Thu 15th Feb 2007