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 101 to 125
< 1 2 3 4 5 6 7 8 9 >
Title Summary Date
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
Call and Commitment Sunday If you're struggling with sermon starters/ideas for the Call… Jan 26, 2010
Emerging Tensions Use the links below to open or save the word documents. Use … Jan 26, 2010
Luke, Haiti and the Olympic To… During these months leading up to Easter in 2010, Canadians … Jan 26, 2010
The Saviour's Community Use the links below to open or save the word documents. Use … Jan 25, 2010
Mentoring Youth It's never too late to get your youth on a Bible reading and… Jan 15, 2010
Haiti Relief - News For news about Haiti relief, updates, pictures, and donation… Jan 14, 2010
Luke's Journey to Easter (Text… Use the links in the following chart to open and download wo… Jan 14, 2010
The Saviour's Keynote Address Use the links below to open or save the word documents. Use … Jan 14, 2010
January e-Tips This month's e-TIPS contains great ideas for your spring pla… Jan 5, 2010
Discipleship Curriculum If you ordered your materials for the February - June unit o… Dec 28, 2009
Have you got youth with rhythm… Here's a great way to bring Timbrels into the 3rd millenium.… Dec 9, 2009
December e-Tips If you want to receive monthly e-Tips (Tips for youth worker… Dec 7, 2009
Great gift idea If you live in or near Toronto and you are interested in sup… Dec 7, 2009
Wishing you a blessed Christma… Read our Christmas greeting to you... Dec 4, 2009
Children's Outreach Program This program outline has everything you will need to run you… Dec 3, 2009
Social Justice Monthly Focus Here's a tool to help you celebrate Christmas, and raise awa… Dec 3, 2009