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 2006-05-01 and 2006-05-31

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

Found 19 Pages:
Title Summary Date
Statistics/Research Analysis SEE ALSO: SallyNet.ca   The Salvation Army has alwa… May 19, 2006
Resources for Divisional Staff Select your downloads: Music Leader's Commission Youth Lea… May 12, 2006
Building Blocks Junior Action Unit 1 - Fall 2010 Description: The Salvatio… May 11, 2006
What's Your Passion?   Senior High/CROSStraining Bible Study - September … May 10, 2006
Integrated Mission The hallmark of The Salvation Army is integrated mission. Sa… May 9, 2006
Incredible Power (A Study in A… Incredible Power (Junior High Bible Study/CROSSzone) - Fall … May 8, 2006
A Life-Altering Experince A LIfe Altering Experience Senior High Bible Study - Winter… May 5, 2006
Basic Training Basic Training consists of five modules of training for chil… May 3, 2006
Camp Staff Training Description: A CD with powerpoint presentations and learner … May 3, 2006
Stewardship Resources Stewardship for Kids: Money Planner for Kids, Larr… May 3, 2006
10 Year Discipleship Program: … The Youth Discipleship Program is a 10 year series of studie… May 1, 2006
Corps - Pastoral Ministries As the Salvation Army moves into the 21st Century, the Great… May 1, 2006
Immigrant and Refugee Services Immigrant and Refugee Services, within the Corps Ministries … May 1, 2006
Involvement with Refugees Basic Needs Food, Clothing, Furniture She… May 1, 2006
Multi-Cultural Ministry Resour…   Ontario Central Immigrant and Refugee Services new… May 1, 2006
Natural Church Development Announcement of New NCD Canada National Partner 2 Decemb… May 1, 2006
Refugee Categories Privately Sponsored Refugees The Private Sponsorship of Re… May 1, 2006
Refugee Ministry Workshops The basics of these workshops could be covered in an hour an… May 1, 2006
Stewardship Resources Our focus is to raise awareness of biblical stewardship - to… May 1, 2006