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 Missions, Prayer

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

Found 5 Pages:
Title Summary Date
Olympic Ministry Resources DownloadsContact UsPromotional Resources LINKS What … Apr 29, 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
Spiritual Formation Welcome to the new Spiritual Formation area of our website.&… Jan 30, 2009

Found 20 Articles:
Title Summary Date
First Children/Youth Prayer We… Friday February 25th marks the beginning of the first weeken… Feb 25, 2011
Territorial Project Women's Ministries groups in The Salvation Army Canada and B… Feb 16, 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
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
Fast For Change Canadian Foodgrains Bank and its members are encouraging Can… Aug 23, 2010
Support the Pakistan Relief Ef… Read the latest news from www.SalvationArmy.ca on the Army's… Aug 23, 2010
Cornwall, Ontario - Seek God Here in the eastern Ontario City of Cornwall, we have distri… Mar 1, 2010
Seek God Prayer Guide Begins T… If your corps/church are participating in the prayer guide S… Feb 17, 2010
Olympic Mission Opportunities Here is a great opportunity for Salvation Army youth to get … Oct 20, 2009
Crash Course This five-part small group or individual Bible study is inte… May 7, 2009
Partners In Mission Weekly Cha… This resource idea will help your church families become inv… Apr 16, 2009
Practical Help for a World In … Did you know that The Salvation Army has offered a child spo… Mar 18, 2009
Ideas for Setting Up Prayer Ro… Often prayer rooms are centered around a theme, and it can h… Mar 10, 2009
Praying for the World Have you ever been browsing in a gadget type store and thoug… Mar 6, 2009
Mexico Women Visit Canada Partners in Mission took on a whole new meaning when the Can… Mar 3, 2009
Effective Prayer and Bible Rea… Not Just A Children's Song... Prayer: A great and interes… Jan 22, 2009
Get Engaged in Stamping Out Wo… www.freerice.com The UN World Food Program (WFP) has create… Jan 14, 2009