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 Ministry, Resources

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

Found 24 Articles:
Title Summary Date
Valentine's Program Ideas Looking for last minute Valentine's ministry ideas? You c… Jan 31, 2011
Commitment Sunday 2011 As you plan for the Territorial Candidates and Commitment Su… Jan 24, 2011
Community Care Ministries 2010 Here is a great encouragement for members of Community Care … Jan 12, 2011
Corps Ministries Department Ne… Now you can find out all the latest news and reminders from … Nov 11, 2010
Stock Up on Useful Pamphlets The Corps Ministries Department has a number of useful pamph… Jul 30, 2010
July e-Tips Join us in prayer for specific summer Children and Youth out… Jul 14, 2010
June e-Tips This month we encourage you to think about planning ahead fo… Jun 2, 2010
Vacation Bible School If you are planning a VBS during the Summer check out the ki… May 27, 2010
Community Care Sunday - June This year's theme, Love Will Build A Bridge provides a great… May 25, 2010
May e-Tips All about prayer for our young people, our leaders of young … May 4, 2010
Corps Ministries Department - … This winter four staff from the THQ Corps MInistries departm… Mar 29, 2010
Summertime Ministry Curriculum… BEFORE YOU PLAN TO HEAD TO THE BEACH THIS SUMMER -- PLAN FOR… Mar 23, 2010
Discount Books for Ministry to… In follow up to our latest e-TIPS, we are thrilled to let yo… Mar 17, 2010
Call and Commitment Sunday If you're struggling with sermon starters/ideas for the Call… Jan 26, 2010
January e-Tips This month's e-TIPS contains great ideas for your spring pla… Jan 5, 2010
December e-Tips If you want to receive monthly e-Tips (Tips for youth worker… Dec 7, 2009
Spiritual Formation is Really … When was the last time you heard a really great, inspiring t… Mar 30, 2009
Spanish Ministry Resources Are you looking for Spanish Ministry tools?  Here are a… Mar 26, 2009
Multi-Age Small Group Resource Do you remember being a kid and feeling impatient to grow up… Mar 23, 2009
Lenten Reflections This set of Lenten Reflections are designed as a Call to Wor… Mar 6, 2009
Whatever Happened to Corps Cad… Contrary to popular belief, The Salvation Army Canada and Be… Feb 27, 2009
Unfolding Grace Unfolding Grace - Promotion Week Material 2009 Women's … Feb 9, 2009
Coffee On Us! The Corps Ministries department is offering free Tim Horton'… Nov 28, 2008
Senior's Resource Kit - Fall 2… The most recent edition of the Senior's Resource Kit has gon… Nov 19, 2008