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

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

Found 170 Pages: showing 1 to 25
< 1 2 3 4 5 6 7 >
Title Summary Date
The Salvation Army Immigrant a… General Information The Salvation Army is an international … Feb 14, 2011
24-7:52 Challenge Calendar Feb 4, 2011
Guide de Ressources Ressources en francais À l'intention des officiers… Jan 21, 2011
Ressources-en-Francais Promotional Slides in French Guides de Ressources Defi… Jan 21, 2011
Canada and Bermuda 24-7:52 Cha… Jan 19, 2011
Thanks Thankyou for committing to join in our year of prayer! Jan 19, 2011
Prayer 24-7 As recently encouraged by General Shaw Clifton, our territor… Dec 9, 2010
Time2BHoly458 Time To Be Holy:458 was an event consisting of two weeks of … Nov 23, 2010
Church Planting Tweets Mar 1, 2010
Corps Office - Resources Jan 27, 2010
Luke's Journey to Easter... an… (Use the menu above to view resources as a chart or a list.)… Jan 19, 2010
Luke's Journey - Listing Click on the title to read documents or join in discussion t… Jan 18, 2010
Lent 2010 Each Gospel in the New Testament has its own angle of vision… Jan 14, 2010
(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

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

Found 203 Articles: showing 1 to 25
< 1 2 3 4 5 6 7 8 9 >
Title Summary Date
40 Days of Lent Starts March 7… Lent begins on March 7th.   Here is a list of some grea… Apr 1, 2011
Great Easter Program Ideas Find lots of great ideas to get ready for Easter on www.Mini… Apr 1, 2011
Chance Cove - Newfoundland You can certainly pray that in this little community that yo… Mar 1, 2011
Partners In Mission Resources   - Liberia The annual Partners in Mission emphasis … Feb 28, 2011
First Children/Youth Prayer We… Friday February 25th marks the beginning of the first weeken… Feb 25, 2011
Easter Slide Backgrounds Here are some Slide backgrounds that are free to use. Use t… Feb 23, 2011
Territorial Project Women's Ministries groups in The Salvation Army Canada and B… Feb 16, 2011
Boom Chicka Boom 2 Disc CD Set Boom Chicka Boom is an Amazing and Embracing CD for children… Feb 7, 2011
Slides for Sunday To save the following slide backgrounds for use in powerpoin… Feb 7, 2011
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
Global Call to 24-7 Prayer Res… In response to the General's Call to Global Prayer 24-7, the… Jan 21, 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
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
Territorial Social Services Co… WHEN:  March 26 - 29, 2011 WHERE: Delta Meadowvale Hot… Dec 20, 2010
Territorial Youth Institute Take Time to Be Holy, Take Time to Serve WHEN:  Augu… Dec 17, 2010
Community Care Bring Christmas… The members of the Community Care in Penticton, BC spread lo… Dec 15, 2010
The Urban Forum 2011 Date:  January 26 - 29th, 2011 Website: www.TheUrbanFo… Dec 13, 2010
The General's Call to Global P… In light of the General's Call to Prayer 24-7 the Territoria… Dec 9, 2010
Prayer Ministry Join the Corps Ministries Department Prayer Ministry! T… Dec 1, 2010
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

Found 16 Events:
Title Summary Date
Territorial Youth Institute Take Time to Be Holy, Take Time to Serve WHEN:  Augu… Aug 27, 2011
Territorial Social Services Co… WHEN:  March 26 - 29, 2011 WHERE: Delta Meadowvale Hot… Mar 26, 2011
The Urban Forum 2011 DATE:  January 26 - 29th, 2011 COST:  $125 Booki… Jan 26, 2011
Booth Bound www.boothbound.com DATE:  OCTOBER 21 - 24, 2010 LO… Oct 21, 2010
Rural Ministries Conference Email contact: lee-anne_hoeft@can.salvationarmy.org Sep 28, 2010
Prayer for Victims of Sexual T… See resources in English, French and Spanish posted at www.S… Sep 26, 2010
Call to Prayer for Peace Sep 19, 2010
National Music and Gospel Arts… Dates:  August 28 - September 4, 2010 Location: Jackso… Aug 28, 2010
World Youth Convention A Salvation Army international youth event taking place in S… Jul 15, 2010
Atlantic Congress - 2010 Location: St. John's, Newfoundland Date:  June 18 - 20… Jun 18, 2010
Easter Concert - North York Te… Featuring Canada's premiere vocal ensemble, The Elmer Iseler… Apr 3, 2010
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

Found 11 Gallery Images:
Title Summary Date
Dignity Project Mar 8, 2011
Dignity Project Mar 8, 2011
Prayer Ministry and Requests Feb 3, 2011
Global Call to 24-7 Prayer Jan 24, 2011
Happenings Jan 24, 2011
saPray247.ca Jan 21, 2011
Send The Fire Jan 21, 2011
Advert: Global Call to 24-7 Pr… Jan 11, 2011
Advert: Imagine she is your ch… Jan 11, 2011
Advert: Join the Pioneer Clubs Jan 11, 2011
Advert: New Canadian Staff Ban… Jan 11, 2011