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 Doctrine, Literature, SA-Identity

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

Found 22 Articles:
Title Summary Date
I Am Not a Metaphor Some months back my wife, Alison, and I became officers in o… Fri 3rd Oct 2008
Salvation Army Identity In November 2005, more than 150 Salvationists from across Ca… Fri 22nd Aug 2008
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 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
The Five Dysfunctions of a Tea… The model outlined in the book, The Five Dysfunctions of a T… Mon 8th Jan 2007
Renowned writer to publish boo… To mark World Aids Day 2006 (Friday 1 December), The Salvati… Thu 30th Nov 2006
Giving Hope Today What is The Salvation Army? Many people associate us with th… Fri 29th Sep 2006
Targeting the Army Brand The public appreciates what we do in a disaster, but sometim… Fri 30th Jun 2006
Are We the Church of the Poor? The body of Christ is more than the sum of its parts. All Ch… Tue 27th Jun 2006
The How-to Handbook for Effect… Contact: International Christian Ministries 19978-72 Ave, La… Thu 22nd Jun 2006
DVD-Doctrine Series (audio MP3… WE BELIEVE ' is a DVD set containing the eleven Salvation Ar… Wed 21st Jun 2006
Shopping for faith What has the church ever done for me? A critique of "consume… Mon 19th Jun 2006
Identity Crisis Music, uniform and terminology shape our sense of who we are… Mon 12th Jun 2006
Sacramental Living William Booth's decision to stop practising the sacraments h… Fri 2nd Jun 2006
Much Loved Christian Author Hi… Beverly Lewis's The Englisher Debuts at #25 on the USA Today… Mon 15th May 2006
Introducing Women Alive magazi… Women Alive magazine informs, entertains and inspires women … Wed 10th May 2006