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 category Articles

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

Found 192 Articles: showing 1 to 25
< 1 2 3 4 5 6 7 8 >
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