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 151 to 175
< 1 2 3 4 5 6 7 8 9 >
Title Summary Date
New Canadian Staff Band Record… The Canadian Staff band have released a new CD called Festiv… Jun 1, 2009
Careforce Lifekeys New Resourc… Careforce Lifekeys have produced several new resources, incl… May 13, 2009
Crash Course This five-part small group or individual Bible study is inte… May 7, 2009
Marriage Enrichment Summer is a great time to run couples care in your community… Apr 29, 2009
Women's Ministries Logos If you are looking for logos for Women's Ministries to suit … Apr 27, 2009
New Mentoring Resource Mentorship: A Guide for Developing Healthy Mentoring Relatio… Apr 22, 2009
Partners In Mission Weekly Cha… This resource idea will help your church families become inv… Apr 16, 2009
People For Sale in Canada? Best Western Lamplighter Inn & Conference Centre 591 We… Apr 15, 2009
Children's Ministry I grew up in the country near Wingham, Ontario. As a kid I … Apr 14, 2009
Give Me A Passion Give Me A Passion!  (2009 CCM Sunday Resource Kit.) … Apr 14, 2009
Stress Relief I’ve often been fascinated with the popularity of movi… Apr 6, 2009
Decision Sunday Resources April is a Decision month in the Salvation Army, during whic… Apr 3, 2009
A Sparkle of Hope The British Columbia Women's Ministries are raising funds fo… Mar 30, 2009
Spiritual Formation is Really … When was the last time you heard a really great, inspiring t… Mar 30, 2009
Spanish Ministry Resources Are you looking for Spanish Ministry tools?  Here are a… Mar 26, 2009
Penelope Green Loves The Ocean Penelope Green Loves The Ocean is the story of a young girl … Mar 25, 2009
Multi-Age Small Group Resource Do you remember being a kid and feeling impatient to grow up… Mar 23, 2009
What's New In Fair Trade Did you know that about 3 million tonnes of cocoa is produce… Mar 23, 2009
Practical Help for a World In … Did you know that The Salvation Army has offered a child spo… Mar 18, 2009
Red Cap Goes Down-Under On February 26-27, 2009 Red Cap Trainer Pat McInnes and Vale… Mar 12, 2009
Ideas for Setting Up Prayer Ro… Often prayer rooms are centered around a theme, and it can h… Mar 10, 2009
Lenten Reflections This set of Lenten Reflections are designed as a Call to Wor… Mar 6, 2009
Praying for the World Have you ever been browsing in a gadget type store and thoug… Mar 6, 2009
Small Group Lenten Resources If your small group is interested in focusing on Lent betwee… Mar 5, 2009
Mexico Women Visit Canada Partners in Mission took on a whole new meaning when the Can… Mar 3, 2009