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 926 to 950
< 1 2 … 36 37 38 39 40 … 48 49 >
Title Summary Date
Celebration of new growth and … Georgetown, Ont. - Congratulations to new community care mem… Thu 2nd Nov 2006
On a mission for Africa When Julia Wight first saw a girl arrive at Zimbabwe’… Thu 2nd Nov 2006
Salvationist brings SA music t… Tom Quick is a third generation Salvationist who worships at… Wed 1st Nov 2006
Technology upgrades benefit em… Halifax, N.S. - Michael Turner, president of Turner Drake & … Wed 1st Nov 2006
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