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 Bible-Study, Ministry, Youth

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

Found 6 Pages:
Title Summary Date
Youth Discipleship Program This program has been designed to: • fit every local … May 22, 2009
Chemically Speaking - Careforc… Chemically Speaking is a single session video suitable for p… Jan 29, 2009
Search for Intimacy - Careforc… Sex is part of life.  Managed rightly it is a profound … Jan 29, 2009
Youth Search For Life - Carefo… 'What do I have to do to be loved, accepted and valued aroun… Jan 29, 2009
e-TIPS SEE ALSO: Archive | Download e-Tips   tips for … Oct 4, 2007
Individual and Family Stewards… See: Various | Corps Ministries Stewardship Resources | … Apr 17, 2007

Found 41 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Valentine's Program Ideas Looking for last minute Valentine's ministry ideas? You c… Jan 31, 2011
Prayer Resources for Children … The Children and Youth Department at THQ have developed a ne… Jan 21, 2011
Community Care Ministries 2010 Here is a great encouragement for members of Community Care … Jan 12, 2011
February Youth Discipleship Ma… UPCOMING UNITS ARE NOW READY FOR SHIPPING.  ORDER NOW… Dec 20, 2010
Territorial Youth Institute Take Time to Be Holy, Take Time to Serve WHEN:  Augu… Dec 17, 2010
Discipleship for Youth The next set of discipleship materials are available for ord… Nov 15, 2010
Student Connection Planner 201…  The Youth Discipleship program encourages the use of t… Sep 15, 2010
Youth Group Discussion Starter The Ideas Factory: 100 Adaptable Discussion Starters for Tee… Jul 26, 2010
July e-Tips Join us in prayer for specific summer Children and Youth out… Jul 14, 2010
World Youth Convention Begins … July 15th will mark the commencement of the World Youth Conv… Jul 12, 2010
Raised Up In July of 2010, Salvationist youth from around the world wi… Jun 30, 2010
Teens & Culture Two books to help you bridge the issues with your teens and … Jun 23, 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
Ministry to Children and Youth… In the past three years there have been three major studies/… Feb 16, 2010
Call and Commitment Sunday If you're struggling with sermon starters/ideas for the Call… Jan 26, 2010
Mentoring Youth It's never too late to get your youth on a Bible reading and… Jan 15, 2010
January e-Tips This month's e-TIPS contains great ideas for your spring pla… Jan 5, 2010
Have you got youth with rhythm… Here's a great way to bring Timbrels into the 3rd millenium.… Dec 9, 2009
December e-Tips If you want to receive monthly e-Tips (Tips for youth worker… Dec 7, 2009
Wishing you a blessed Christma… Read our Christmas greeting to you... Dec 4, 2009

Found 3 Events:
Title Summary Date
Territorial Youth Institute Take Time to Be Holy, Take Time to Serve WHEN:  Augu… Aug 27, 2011
Booth Bound www.boothbound.com DATE:  OCTOBER 21 - 24, 2010 LO… Oct 21, 2010
Canadian Youth Workers Convent… WHEN:  December 3 - 6, 2009 WHERE:  Sheraton Vanc… Dec 3, 2009