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-02-01 and 2010-02-28

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

Found 18 Articles:
Title Summary Date
Saving Life and Losing It Use the links below to open or save the word documents. Use … Feb 25, 2010
Great Clip Art Resources Check out Ron Wheeler's website, where you will find all kin… Feb 24, 2010
What's In The Bible "From the man who made vegetables talk, a ground breaki… Feb 23, 2010
Youth Worker Training Event ABOUT BAREFOOT MINISTRIES Barefoot exists to provide yout… Feb 18, 2010
Advertise Website Resources To advertise Canadian Army web resources for your leaders, c… Feb 17, 2010
Seek God For The City 2010 - D… Welcome to participants of the Seek God For The City 2010 pr… Feb 17, 2010
Seek God Prayer Guide Begins T… If your corps/church are participating in the prayer guide S… Feb 17, 2010
Ministry to Children and Youth… In the past three years there have been three major studies/… Feb 16, 2010
New Quick Link on the SA Dashb… You can now get to this website using a quick link, recently… Feb 16, 2010
Salvation As Healing Use the links below to open or save the word documents. Use … Feb 16, 2010
Luke's Journey - Discussion Also add comments to the article "Luke, Haiti and the O… Feb 10, 2010
Useful Logos to Keep Handy INSTRUCTIONS: To save a copy to your computer, right click o… Feb 10, 2010
Valentine's Purchasing If you are thinking about buying Fair Trade chocolate for yo… Feb 8, 2010
Ontario Great Lakes Senior's R… Our annual Rally was once again held at the big Greek, Helle… Feb 5, 2010
Luke and Lent The global church is about to enter the season of Lent. Begi… Feb 4, 2010
Salvation as Forgiveness Use the links below to open or save the word documents. Use … Feb 4, 2010
Teaching on the Plain Use the links below to open or save the word documents. Use … Feb 2, 2010
Social Justice Resources The Vineyard Anti-Slavery Team has launched a new area of th… Feb 1, 2010