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 201 to 225
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Writer's guidelines The Editorial Department welcomes your submissions. The foll… Wed 10th May 2006
Retired Officers On-line Forum… This is a PRIVATE site for Retired Officers of The Salvation… Mon 8th May 2006
Welcome to the Territorial Ret… Mon 8th May 2006
Subscription Order Form To subscribe to Salvationist magazine, Faith & Friends o… Fri 5th May 2006
Employment Opportunities To post a job on this section of the website, please send an… Thu 4th May 2006
Single Spouse Officership Has the time come for the Army to enable married couples to … Thu 4th May 2006
37th Anniversary Fri 28th Apr 2006
Be Thou My Vision Fri 28th Apr 2006
Privacy Policy This website's policy is to respect and protect the privacy … Fri 28th Apr 2006
To God be the Glory Fri 28th Apr 2006
Magazines For more information about our magazines, please visit the f… Thu 27th Apr 2006
PrayerZone and Prayer Resource… For more information or to receive your copy by e-mail, cont… Thu 27th Apr 2006
Promotional Material Please find below material you can use in your church/corps … Thu 27th Apr 2006
Annual Change 2007 The following is information regarding the annual officer ap… Wed 26th Apr 2006
Family Tracing Services OUR TASK The Family Tracing Services of The Salvation Army … Wed 26th Apr 2006
Gazette and Calendar Updated January 29, 2009   GAZETTE INTERNAT… Wed 26th Apr 2006
Contact Us Thank you for visiting Salvationist.ca. If you have any ques… Tue 25th Apr 2006
Correctional and Justice Servi… Statistics may indicate that crime is decreasing, but its ef… Tue 25th Apr 2006
Emergency and Disaster Service… Disasters can occur at any time and in any place. They often… Tue 25th Apr 2006
Family Services Statistics Canada confirms that there are more than one mill… Tue 25th Apr 2006
Our churches The Salvation Army's 352 community churches are the nerve ce… Tue 25th Apr 2006
Child Sponsorship What is sponsorship? A sponsor is a person who provides fina… Mon 24th Apr 2006
Homelessness Despite the fact that we live in a country rich in resources… Mon 24th Apr 2006
Human Resources Mon 24th Apr 2006
Ministry Resources The Corps Ministries department at Territorial Headquarters,… Mon 24th Apr 2006