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/web76/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/web76/web/index.php line 4
Search Results
Skip to Content
Click to print

Search Results

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

Found 1208 Articles: showing 276 to 300
< 1 2 … 10 11 12 13 14 … 48 49 >
Title Summary Date
Spiritual Disciplines Every one of us has a story. As we share those stories with … Tue 22nd Jan 2008
Cobourg Thanks Community Cobourg, ON - The Salvation Army Community and Family Servic… Mon 21st Jan 2008
Hungry for God Why more and more Christians are fasting for revival Before … Mon 21st Jan 2008
Social Issues Events 2008 marks the 40th anniversary of the Social Issues Committ… Mon 21st Jan 2008
God Sent Me A Balloon My name is Scotty and I live near Newton, Illinois. I am a C… Fri 18th Jan 2008
What About Rich People? OVER the past decade, in many parts of the world, there has … Thu 17th Jan 2008
Women’s Health And The … Toronto - The topic is current and relevant. The 12th annual… Wed 16th Jan 2008
Equally Yoked Dating Should a Christian date a non-Christian? This question is co… Tue 15th Jan 2008
Confession: Is It Really Good … Spiritual disclosure can bring a new awareness of God  Mon 14th Jan 2008
Salvation Army Shelter Receive… Yellowknife - The Salvation Army shelter received 20 brand n… Mon 14th Jan 2008
Whatever Happened To Family Me… Here's how to reclaim that time together "Mom, have you seen… Fri 11th Jan 2008
Launch Of The National Disaste… Since the attack on the World Trade Centre in New York City … Thu 10th Jan 2008
Mark Your Calendars! What do the opening of Hair on Broadway, Celine Dion's birth… Tue 8th Jan 2008
SARoots.ca In recent years hundreds of Salvationists from across the te… Tue 8th Jan 2008
Covenant, Rainbow and the Call The power of the Holy Spirit is moving the hearts of Godâ… Mon 7th Jan 2008
OMNI Television Helps Raise Aw… Toronto - The Ontario Central-East Public Relations and Deve… Mon 7th Jan 2008
Ignite Is About Significant Mi… Ignite is a 10-month mission and discipleship training progr… Fri 4th Jan 2008
Waiting On The Lord A commonly-asked question from Christian singles goes someth… Fri 4th Jan 2008
Record Setting Christmas Achie… The biggest Christmas stocking was made this year in Toronto… Thu 3rd Jan 2008
International Appointments And… EFFECTIVE 1 MAY 2008 COMMISSIONER LINDA BOND, an officer of … Wed 2nd Jan 2008
Assumptions Jesus said we’re to treat all people equally, but tha… Mon 31st Dec 2007
The Golden Compass December 17, 2007 - I watched The Golden Compass the other n… Thu 27th Dec 2007
Christmas Memories General Shaw Clifton reflects on Christmases past and the jo… Tue 25th Dec 2007
Peel Regional Police And The S… The Crime Prevention Academy of 2008, a breakthrough concept… Tue 25th Dec 2007
Bethlehem How the “House of Bread” became the birthplace o… Mon 24th Dec 2007