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-10-01 and 2006-10-31

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

Found 2 Pages:
Title Summary Date
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

Found 53 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
Freak winter storm hits southw… Friday, October 13, 2006, the town of Port Colborne, Ont. de… Tue 31st Oct 2006
Intercultural ministry team se… Agincourt, Toronto - The statement of the intercultural mini… Tue 31st Oct 2006
Episode 209: The Salvation Arm… Feature: Ron Zima joined The Salv… Mon 30th Oct 2006
Library wipes out fines for fo… Hanover, Ont. - Between Oct. 28 and Nov. 10 the Hanover Publ… Mon 30th Oct 2006
New Canadian website brings Bi… Thanks to a new interactive website called BibleKids.ca, chi… Mon 30th Oct 2006
Public reaches out to fire vic… Neighbours in the small town of Campbellford, Ont. and the s… Mon 30th Oct 2006
First annual Thanksgiving dinn… Dawson Creek, B.C. - The Salvation Army Family Services had … Fri 27th Oct 2006
Ministry in Motion North York Temple in Toronto reaches out to the community th… Fri 27th Oct 2006
Vision framework for ministry … Dr. Glen Smith, executive director of Christian Direction in… Fri 27th Oct 2006
Celebrating 60 years of caring The young Salvation Army officer lay in the dentist chair. I… Thu 26th Oct 2006
Local company's ongoing commit… October 6, 2006 - It was 6:00 a.m. when they were in place a… Thu 26th Oct 2006
Wanted: Volunteers to work wit… Kingston, Ont. - The program "Circles of Support and Account… Wed 25th Oct 2006
Inauguration ceremony marks ne… Langley BC - The triumphant music of Beethoven’s â₅ Tue 24th Oct 2006
Medal Winner! Congratulations to Zachary Brown of Agincourt corps, Toronto… Tue 24th Oct 2006
New law is highly supported by… A new provincial law allowing police to seize johns' cars ta… Tue 24th Oct 2006
Riding the Freeway Pernell Goodyear, pastor at the Freeway church and café i… Mon 23rd Oct 2006
In All Things Give Thanks to G… On January 3, 2005, I thought my world had come to and end. … Fri 20th Oct 2006
Episode 208: The Salvation Arm… Feature: Organ donation and trans… Thu 19th Oct 2006
Judgment in The Salvation Army… STRASBOURG, FRANCE -- On Thursday, October 6, The European C… Thu 19th Oct 2006
New thrift store provides valu… Kitchener, Ont.- Tomorrow, Friday, Oct. 20, The Salvation Ar… Thu 19th Oct 2006
Homelessness Awareness Week Nelson, B.C. - The City of Nelson has proclaimed October 16 … Wed 18th Oct 2006
The Salvation Army participate… Saskatoon - This winter 100 families will have warmer homes … Wed 18th Oct 2006
Backstreet Boy returns to his … With the spring 2006 release of his first-ever Christian sol… Tue 17th Oct 2006
Community care in Whitehorse Members of the Whitehorse Corps recently travelled the Demps… Tue 17th Oct 2006
A Place of Miracles Wiarton experiences a rebirth of Salvation Army ministry. Wi… Mon 16th Oct 2006