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 Event, Programs, Resources

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

Found one Page:
Title Summary Date
Healing & Wholeness - Careforc… What is it? Through a system of small groups, participants … Feb 16, 2007

Found 23 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
Search for Christmas Program I… You can find lots of great Christmas program ideas on www.Mi… Nov 22, 2010
Corps Ministries Department Ne… Now you can find out all the latest news and reminders from … Nov 11, 2010
Fall Program and Event Supplie… SEPTEMBER Visit www.salvationist.ca/trafficking for rela… Aug 9, 2010
Thanksgiving Program Ideas Readings: God's Harvest - Print Version (Responsive Reading… Aug 2, 2010
Stock Up on Useful Pamphlets The Corps Ministries Department has a number of useful pamph… Jul 30, 2010
Raised Up In July of 2010, Salvationist youth from around the world wi… Jun 30, 2010
Program Ideas Father's Day Find Father's Day program ideas on www.MinistryHelps.ca.&nbs… May 26, 2010
Spring Program Ideas If you are looking for some ideas for spring programs, here … Apr 6, 2010
Ready To Serve Recruitment Cam…  If you know talented young people who can act and sing… Mar 31, 2010
Discount Books for Ministry to… In follow up to our latest e-TIPS, we are thrilled to let yo… Mar 17, 2010
Youth Worker Training Event ABOUT BAREFOOT MINISTRIES Barefoot exists to provide yout… Feb 18, 2010
Acquire the Fire - Hamilton Our focus and heart this year is all about Encountering the … Oct 8, 2009
Think Different Conference Think Different involves speakers and presenters representi… Oct 6, 2009
Raised Up In July of 2010, Salvationist youth from around the world wi… Oct 1, 2009
People For Sale in Canada? Best Western Lamplighter Inn & Conference Centre 591 We… Apr 15, 2009
Red Cap Goes Down-Under On February 26-27, 2009 Red Cap Trainer Pat McInnes and Vale… Mar 12, 2009
Lenten Reflections This set of Lenten Reflections are designed as a Call to Wor… Mar 6, 2009
Unfolding Grace Unfolding Grace - Promotion Week Material 2009 Women's … Feb 9, 2009
Divisional Youth Justice Leagu… The Ontario Central East Division are helping youth to focus… Feb 6, 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

Found one Event:
Title Summary Date
Addictions and Mental Health C… April 23-24, 2009 Apr 23, 2009