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 for tags Connection, Literature

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

Found 52 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
No Action Without Reflection "Salvationists pride themselves on being ‘doers o… Thu 14th Aug 2008
Happily Ever After: Without th… With wisdom gleaned from their careers as single, globe-trot… Thu 1st Nov 2007
The General's Pastoral Letters It is the General's wish that as many soldiers as possible, … Tue 21st Aug 2007
Amy Grant to Release Memoir The memoir of Christian music artist Amy Grant will release … Mon 6th Aug 2007
Retired Officers Introduce New… USA - Joe and Doris Noland are retired Salvation Army office… Mon 30th Jul 2007
Refugee Sandwich If you have ever worked with refugees, and been confused by … Tue 15th May 2007
Episode 234: The Salvation Arm… Earth Day (April 22) is the topic… Fri 20th Apr 2007
Episode 233: The Salvation Arm… The week of April 15 is National … Fri 13th Apr 2007
Episode 232: The Salvation Arm… Why Easter Matters - General Bram… Thu 5th Apr 2007
Episode 231: The Salvation Arm… To mark Refugee Rights Day on Apr… Fri 30th Mar 2007
Episode 229: The Salvation Arm… Brian Burditt is Director of Worl… Fri 16th Mar 2007
Episode 228: The Salvation Arm… The Army's New York Staff Band wa… Fri 9th Mar 2007
Episode 226: The Salvation Arm… 'Jesus of Hollywood' is a new boo… Mon 26th Feb 2007
Episode 225: The Salvation Arm… 'Jesus of Hollywood' is a new boo… Fri 16th Feb 2007
Episode 224: The Salvation Arm… Lois Flemming is The Salvation Ar… Fri 9th Feb 2007
Episode 223: The Salvation Arm… A team of Salvationist women from… Fri 2nd Feb 2007
Episode 222: The Salvation Arm… Major Joanne Biggs (Ret.), Chapla… Fri 26th Jan 2007
Episode 221: The Salvation Arm… Commissioner William Francis is t… Sat 20th Jan 2007
Episode 219: The Salvation Arm… Feature: Commissioner Robert Wats… Mon 8th Jan 2007
The Five Dysfunctions of a Tea… The model outlined in the book, The Five Dysfunctions of a T… Mon 8th Jan 2007
Episode 216: The Salvation Arm… Feature: Retired Vancouver busine… Fri 22nd Dec 2006
Episode 215: The Salvation Arm… Feature: Jim Kurz is a branch man… Mon 11th Dec 2006
Episode 214: The Salvation Arm… Feature: Dr. Peter Legge is the P… Tue 5th Dec 2006
Renowned writer to publish boo… To mark World Aids Day 2006 (Friday 1 December), The Salvati… Thu 30th Nov 2006
Episode 213: The Salvation Arm… Feature: December 1st is World AI… Sun 26th Nov 2006