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 between 2009-01-01 and 2009-12-31

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

Found 36 Pages: showing 1 to 25
< 1 2 >
Title Summary Date
(Untitled) General John Gowans once penned these words contained in son… Nov 12, 2009
Rural Ministries Events Email contact: lee-anne_hoeft@can.salvationarmy.org THE… Nov 12, 2009
Prayer Requests If you would like to submit a prayer request to be added to … Sep 22, 2009
Photo Gallery To visit flickr.com and view more of a photo gallery, click … Jul 16, 2009
Archives Here you can search our archives of pages and posts since ou… Jun 8, 2009
Poll Jun 8, 2009
My Pattern For Living Junior Action Unit 7 - Fall 2009 MY PATTERN FOR LIVING wi… Jun 4, 2009
Youth Discipleship Program This program has been designed to: • fit every local … May 22, 2009
Multi-Cultural Ministry Introd… The Greater Toronto Area is a region of many nations. For t… May 11, 2009
Multi-Culturalism and The Salv… How does The SA fit into all this? We are going to find i… May 11, 2009
Olympic Ministry Resources DownloadsContact UsPromotional Resources LINKS What … Apr 29, 2009
Women's Ministries Logos Downl… Small Logo - 288 w x 288 h Great for Website or… Apr 21, 2009
Ministry Questions The following ministry questions have been responded to. … Apr 7, 2009
Church Revitalization Welcome to the Congregational Revitalization page! Revitaliz… Mar 30, 2009
Ideas for Group Ministry Below are the recent postings under "Small Group".… Mar 20, 2009
Missions and Your World Below are the recent postings under "Missions and Your … Mar 20, 2009
A Thought For You Below are the recent postings under "A Thought for You&… Feb 27, 2009
Women's Events Feb 27, 2009
Church Planting Assessments Assessment for Church Planting Several forms of church plan… Feb 2, 2009
Church Planting Resources Choose from the following categories of resources on this pa… Feb 2, 2009
Spiritual Formation Welcome to the new Spiritual Formation area of our website.&… Jan 30, 2009
Chemically Speaking - Careforc… Chemically Speaking is a single session video suitable for p… Jan 29, 2009
Door of Hope - Careforce Lifek… An encouraging and supportive program for women survivors of… Jan 29, 2009
Healthy Lifestyle - Careforce … Healthy Lifestyle is for women of any age who are seeking to… Jan 29, 2009
Kids With Courage - Careforce … Kids with Courage is a seven session program that aims to st… Jan 29, 2009

Found one Product:
Name Title Summary Date
VBS 001 VBS 001 12+2 Jun 1, 2009

Found 75 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
Discipleship Curriculum If you ordered your materials for the February - June unit o… Dec 28, 2009
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
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
Social Justice Monthly Focus Here's a tool to help you celebrate Christmas, and raise awa… Dec 3, 2009
Anti-Trafficking News Updates The Salvation Army United States National Headquarters have … Nov 18, 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
Help the Gateway expand Dion Oxford, director of The Gateway, just submitted an idea… Nov 12, 2009
November 2009 e-Tips Check out this month's e-Tips: May I Have Some Assistance Pl… Nov 4, 2009
Pioneer Clubs Pioneer Clubs is a unique ministry designed for today’… Oct 28, 2009
Olympic Mission Opportunities Here is a great opportunity for Salvation Army youth to get … Oct 20, 2009
Send The Fire - Relaunches The Salvation Army in Canada & Bermuda Territory’s… Oct 20, 2009
The Youth Have Spoken Read the results of two years' worth of research conducted b… Oct 15, 2009
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
Resources for Preachers Sermons & Illustrations  … Sep 30, 2009
Women's Ministry Sunday A special Sunday to draw attention to ministry by and for wo… Sep 24, 2009
Let First Steps Enhance Your C… If you thought that First Steps was a new program meant to r… Sep 8, 2009
Pray for the Torch Relay Evang… The Olympic Torch will be traveling from Victoria, British C… Sep 2, 2009
Prayer for Victims of Sex Traf… MORE PRECIOUS THAN SILVER September 25 - 27, 2009 - Weekend… Jul 21, 2009
Grants for Olympic Torch Relay… The Salvation Army Olympics Outreach Program for 2010 is off… Jul 8, 2009

Found 5 Events:
Title Summary Date
Canadian Youth Workers Convent… WHEN:  December 3 - 6, 2009 WHERE:  Sheraton Vanc… Dec 3, 2009
Screen Printing Workshop and F… WHERE:  77 River Street, Toronto COST:  $5.00 (wi… Oct 3, 2009
More Precious Than Silver Weekend of Prayer for Victims of Sex Trafficking For more i… Sep 25, 2009
Commissioning 2009 - Witnesses… Friday June 19th (Toronto Centre for the Arts) Officer Coun… Jun 21, 2009
Addictions and Mental Health C… April 23-24, 2009 Apr 23, 2009