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

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

Found 7 Pages:
Title Summary Date
Kids With Courage - Careforce … Kids with Courage is a seven session program that aims to st… Jan 29, 2009
e-TIPS SEE ALSO: Archive | Download e-Tips   tips for … Oct 4, 2007
Child Evangelism Tools     Sep 28, 2007
Individual and Family Stewards… See: Various | Corps Ministries Stewardship Resources | … Apr 17, 2007
Decision Pamphlets Description: Colorful cartoon booklets in four age categorie… Apr 27, 2006
Baby Song Baby Song is an exciting Salvation Army outreach program for… Apr 26, 2006
Junior Action - Junior Soldier… Recent News: The Junior Soldier Prep Course has been redesig… Apr 26, 2006

Found 38 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
First Children/Youth Prayer We… Friday February 25th marks the beginning of the first weeken… Feb 25, 2011
Commitment Sunday 2011 As you plan for the Territorial Candidates and Commitment Su… Jan 24, 2011
Prayer Resources for Children … The Children and Youth Department at THQ have developed a ne… Jan 21, 2011
Decision Materials This great resource tool that will help you lead children an… Jan 10, 2011
Junior Soldier Renewal The Junior Soldier Renewal and Junior Action Commitment Sund… Jan 10, 2011
February Youth Discipleship Ma… UPCOMING UNITS ARE NOW READY FOR SHIPPING.  ORDER NOW… Dec 20, 2010
Corps Ministries Department Ne… Now you can find out all the latest news and reminders from … Nov 11, 2010
Camp News from Around The Terr… Find out what's been happening at Army camps around the terr… Sep 6, 2010
The Salvation Army Enlists Cro… COPY OF NEWS ARTICLE FROM CROSSROADS "Crossroads Chr… Aug 24, 2010
Stock Up on Useful Pamphlets The Corps Ministries Department has a number of useful pamph… Jul 30, 2010
Keep In Touch First Steps is an umbrella for ministries to infants and pre… Jul 28, 2010
July e-Tips Join us in prayer for specific summer Children and Youth out… Jul 14, 2010
What is Baby Song? "Baby Song" began as a Salvation Army initiative i… Jul 5, 2010
AmazinGrace Sports Camp God invites each of us to join his Amazing Race! This Bible … Jun 9, 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
May is First Steps/Cradel Roll… Why First Steps? The first four years of a child’s li… May 20, 2010
May e-Tips All about prayer for our young people, our leaders of young … May 4, 2010
Turn Off The Screens Week Children across the country will be challenged at school to … Apr 13, 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
Ministry to Children and Youth… In the past three years there have been three major studies/… Feb 16, 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
Children's Outreach Program This program outline has everything you will need to run you… Dec 3, 2009

Found one Event:
Title Summary Date
Canadian Youth Workers Convent… WHEN:  December 3 - 6, 2009 WHERE:  Sheraton Vanc… Dec 3, 2009