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 2010-03-01 and 2010-03-31

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

Found one Page:
Title Summary Date
Church Planting Tweets Mar 1, 2010

Found 14 Articles:
Title Summary Date
Ready To Serve Recruitment Cam…  If you know talented young people who can act and sing… Mar 31, 2010
Corps Ministries Department - … This winter four staff from the THQ Corps MInistries departm… Mar 29, 2010
Partners In Mission Challenge Historically in The Salvation Army, Lent has been used as an… Mar 29, 2010
Worshipping The Saviour - WEEK… Use the links below to open or save the word documents. Use … Mar 26, 2010
Preaching Resources Here are some helpful websites for those who are writing ser… Mar 24, 2010
Summertime Ministry Curriculum… BEFORE YOU PLAN TO HEAD TO THE BEACH THIS SUMMER -- PLAN FOR… Mar 23, 2010
The Risen Saviour - EASTER SUN… Use the links below to open or save the word documents. Use … Mar 22, 2010
Discount Books for Ministry to… In follow up to our latest e-TIPS, we are thrilled to let yo… Mar 17, 2010
The Saviour is Crucified - GOO… Use the links below to open or save the word documents. Use … Mar 17, 2010
The Saviour Enters the City - … Use the links below to open or save the word documents. Use … Mar 16, 2010
Family Devotional Materials One of our greatest responsibilities and challenges is to he… Mar 10, 2010
Mission of Salvation Use the links below to open or save the word documents. Use … Mar 9, 2010
Good Samaritan and Good Studen… Use the links below to open or save the word documents. Use … Mar 2, 2010
Cornwall, Ontario - Seek God Here in the eastern Ontario City of Cornwall, we have distri… Mar 1, 2010