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/web77/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/web77/web/index.php line 4
Search Results
Skip to Content
 

Search


 
Find the Army near you

Territorial Photos


Ministry Resources Poll

If you were starting a new children's ministry program, which timeframe would you use?
Choices

Syndication

14 14 1199  RSS | What is this?

Search Results for tags Lent, Partners-in-Mission

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

Found 22 Articles:
Title Summary Date
40 Days of Lent Starts March 7… Lent begins on March 7th.   Here is a list of some grea… Apr 1, 2011
Partners In Mission Resources   - Liberia The annual Partners in Mission emphasis … Feb 28, 2011
Partners In Mission Challenge Historically in The Salvation Army, Lent has been used as an… Mar 29, 2010
Mission of Salvation Use the links below to open or save the word documents. Use … Mar 9, 2010
Good Samaritan and Good Studen… Use the links below to open or save the word documents. Use … Mar 2, 2010
Cornwall, Ontario - Seek God Here in the eastern Ontario City of Cornwall, we have distri… Mar 1, 2010
Saving Life and Losing It Use the links below to open or save the word documents. Use … Feb 25, 2010
Seek God For The City 2010 - D… Welcome to participants of the Seek God For The City 2010 pr… Feb 17, 2010
Seek God Prayer Guide Begins T… If your corps/church are participating in the prayer guide S… Feb 17, 2010
Salvation As Healing Use the links below to open or save the word documents. Use … Feb 16, 2010
Luke's Journey - Discussion Also add comments to the article "Luke, Haiti and the O… Feb 10, 2010
Luke and Lent The global church is about to enter the season of Lent. Begi… Feb 4, 2010
Salvation as Forgiveness Use the links below to open or save the word documents. Use … Feb 4, 2010
Teaching on the Plain Use the links below to open or save the word documents. Use … Feb 2, 2010
Emerging Tensions Use the links below to open or save the word documents. Use … Jan 26, 2010
The Saviour's Community Use the links below to open or save the word documents. Use … Jan 25, 2010
Luke's Journey to Easter (Text… Use the links in the following chart to open and download wo… Jan 14, 2010
The Saviour's Keynote Address Use the links below to open or save the word documents. Use … Jan 14, 2010
Lenten Reflections This set of Lenten Reflections are designed as a Call to Wor… Mar 6, 2009
Small Group Lenten Resources If your small group is interested in focusing on Lent betwee… Mar 5, 2009
Mexico Women Visit Canada Partners in Mission took on a whole new meaning when the Can… Mar 3, 2009
Journey to the Cross Don't miss this great resource, written by two acclaimed Sal… Feb 12, 2009