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 between 2008-01-01 and 2008-01-31

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

Found 3 Pages:
Title Summary Date
All Podcasts Fri 25th Jan 2008
Multicultural Conference For more information contact Ruth Kimmins or Holly Patterson Mon 7th Jan 2008
Partners In Mission Partners in Mission Resource Kits have now arrived in corps.… Mon 7th Jan 2008

Found 30 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Mission Or Maintenance? IS the corps which I lead, or where I soldier, focused on mi… Thu 31st Jan 2008
MissionFest Toronto MissionFest Toronto 2008 - March 6 to 8 - One weekend   Tue 29th Jan 2008
Why I Love Being A Corps Offic… One of the great strengths of our movement is the ability of… Tue 29th Jan 2008
Dress for Success They say the clothes make the man-or woman! Why do we worry … Mon 28th Jan 2008
Thrift Store Workers Return Va… Orillia - Kudos to Salvation Army Thrift Store staff in Oril… Fri 25th Jan 2008
Divorce: Are We Still Taking S… WHEN I entered the school for officers’ training in 1… Thu 24th Jan 2008
City Shares Money From Parking… Penticton, B.C. - The City of Penticton donated $2,299 to Th… Wed 23rd Jan 2008
Brigitte Kloosterman Tue 22nd Jan 2008
Eric and Rachael Olson Tue 22nd Jan 2008
Life For Old Blue Boxes Toronto - We're not to use our old blue boxes when recycling… Tue 22nd Jan 2008
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