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 Christmas, Outreach

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

Found one Page:
Title Summary Date
Baby Song Baby Song is an exciting Salvation Army outreach program for… Apr 26, 2006

Found 23 Articles:
Title Summary Date
Promote Gifts of Hope Gifts of Hope is a great way to teach your teens about a bet… Dec 1, 2010
Search for Christmas Program I… You can find lots of great Christmas program ideas on www.Mi… Nov 22, 2010
Christmas Praise & Worship col… Here are some worship choruses that you may already use, tha… Nov 15, 2010
Get your team ready! This annual fundraising event is taking place all across Can… Nov 1, 2010
Glad Tidings This year's promotional CD is now available for Order. Fe… Oct 22, 2010
Seniors' Ministry Services to Seniors exists to provide a caring, supportive v… Oct 6, 2010
Christmas Supplies Inventory Here are some things you might want to order early, to get r… Sep 22, 2010
What is Baby Song? "Baby Song" began as a Salvation Army initiative i… Jul 5, 2010
May is First Steps/Cradel Roll… Why First Steps? The first four years of a child’s li… May 20, 2010
Great gift idea If you live in or near Toronto and you are interested in sup… Dec 7, 2009
Wishing you a blessed Christma… Read our Christmas greeting to you... Dec 4, 2009
Children's Outreach Program This program outline has everything you will need to run you… Dec 3, 2009
Christmas CDs for sale at amaz… (Click here to enlarge CD cover photo) For only $1.25 eac… Nov 15, 2009
Christmas Supplies A wide variety of Christmas kettle supplies are  availa… Nov 15, 2009
Grants for Olympic Torch Relay… The Salvation Army Olympics Outreach Program for 2010 is off… Jul 8, 2009
Ministry Opportunity for Any G… The Hospitality Team is seeking donations to prepare Welcome… Jun 8, 2009
Senior's Resource Packets - Wi… Don't miss these great new programs for your Senior's Minist… Feb 24, 2009
Community Care Paws to Help Pet visitation therapy is a great way to reach out to senior… Feb 5, 2009
Ministry Outside Our Walls Every year the Corps Ministries department from THQ make a s… Jan 14, 2009
Red Deer Reach Out to Seniors As new relationships are built with others in the community,… Jan 6, 2009
Halifax Citadel Pack Sunshine Halifax Citadel Community Care workers packed 1,133 Sunshine… Dec 10, 2008
Wiarton Community Care Reach O… Wiarton Community Care Ministries reach out to the community… Dec 9, 2008
Christmas All December! Looking for a great way to teach children about Christmas du… Nov 26, 2008