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 203 Articles: showing 51 to 75
< 1 2 3 4 5 6 7 8 9 >
Title Summary Date
Keep In Touch First Steps is an umbrella for ministries to infants and pre… Jul 28, 2010
Youth Group Discussion Starter The Ideas Factory: 100 Adaptable Discussion Starters for Tee… Jul 26, 2010
Careforce Lifekeys - Healing a… What is it? Through a system of small groups, participants … Jul 14, 2010
July e-Tips Join us in prayer for specific summer Children and Youth out… Jul 14, 2010
World Youth Convention Begins … July 15th will mark the commencement of the World Youth Conv… Jul 12, 2010
What is Baby Song? "Baby Song" began as a Salvation Army initiative i… Jul 5, 2010
Raised Up In July of 2010, Salvationist youth from around the world wi… Jun 30, 2010
Home Missions Divisional Repor… ALBERTA & NORTHERN TERRITORIES 2009 Home Missions fun… Jun 25, 2010
Teens & Culture Two books to help you bridge the issues with your teens and … Jun 23, 2010
Congress and Commissioning Pho… To see more pictures and a brief report from the congress we… Jun 21, 2010
May-June e-WORSHIP The May-June issue of e-worship is up and running. All … Jun 16, 2010
Summer Park Ministry This summer if your corps or ministry unit are going outdoor… Jun 14, 2010
AmazinGrace Sports Camp God invites each of us to join his Amazing Race! This Bible … Jun 9, 2010
Community Care News - May 2010 Notes and news for the summer, from the Territorial Adult Mi… Jun 2, 2010
June e-Tips This month we encourage you to think about planning ahead fo… Jun 2, 2010
Adherents Handbook To be an adherent member means a number of things that can a… May 31, 2010
Senior's Month In many provinces June is associated with seniors. Many com… May 28, 2010
Vacation Bible School If you are planning a VBS during the Summer check out the ki… May 27, 2010
Program Ideas Father's Day Find Father's Day program ideas on www.MinistryHelps.ca.&nbs… May 26, 2010
Community Care Sunday - June This year's theme, Love Will Build A Bridge provides a great… May 25, 2010
May is First Steps/Cradel Roll… Why First Steps? The first four years of a child’s li… May 20, 2010
May e-Tips All about prayer for our young people, our leaders of young … May 4, 2010
Therefore, Chose Life Sponsored by Queen’s School of Religion Date: October… Apr 21, 2010
Refugee Camp In The Heart of t… Pack up your youth group, bible study group, women's or seni… Apr 16, 2010
Turn Off The Screens Week Children across the country will be challenged at school to … Apr 13, 2010