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

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

Found 7 Pages:
Title Summary Date
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

Found 102 Articles: showing 1 to 25
< 1 2 3 4 5 >
Title Summary Date
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
Christmas Praise & Worship col… Here are some worship choruses that you may already use, tha… Nov 15, 2010
Discipleship for Youth The next set of discipleship materials are available for ord… Nov 15, 2010
Corps Ministries Department Ne… Now you can find out all the latest news and reminders from … Nov 11, 2010
Fantastic Salvation Army Guita… The Salvation Army Music and Gospel Arts Department hosts ww… Nov 10, 2010
November e-Tips 2010 This month's e-TIPS will give you some great ideas to get yo… Nov 9, 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
Spanish Song Book Did you know that you can access Spanish lyrics for the Salv… Oct 18, 2010
Seniors' Ministry Services to Seniors exists to provide a caring, supportive v… Oct 6, 2010
Women's Ministry Promotion Wee… Download the program outline and resources at www.MinistryHe… Oct 6, 2010
October e-Tips 2010 This month's e-TIPS is all about how to ask questions in a c… Oct 4, 2010
Christmas Supplies Inventory Here are some things you might want to order early, to get r… Sep 22, 2010
Jude Gotrich - Visit to Ontari… Jude Gotrich will be the special guest for Territorial Headq… Sep 15, 2010
Music Care Conference - Ontari… This conference is a great opportunity for Community Care wo… Sep 15, 2010
Student Connection Planner 201…  The Youth Discipleship program encourages the use of t… Sep 15, 2010
Victims of Sexual Trafficking September 24 - 26, 2010 has been designated as a Weekend of … Sep 8, 2010

Found 8 Events:
Title Summary Date
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