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 for tags Blog-Stephen-Wiseman, Church, Spiritual-Formation

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

Found 33 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Wholeness As a challenging new year lies ahead, the word that keeps co… Fri 9th Jan 2009
Missing the Good Life Is it OK to be cynical? I've been batting this one around in… Tue 6th Jan 2009
Today is a Gift I watched Kung Fu Panda with my kids last weekend. I love th… Wed 10th Dec 2008
Symphony of Life I recently attended the Winnipeg Symphony Orchestra’s … Tue 11th Nov 2008
Known, Accepted and Loved Every day we live with a great irony: we have an unending de… Tue 4th Nov 2008
The UP Escalator The down escalator is faster than the up escalator. That&rsq… Mon 27th Oct 2008
Winds of the Spirit Sweep Thro… We instantly noticed him sitting at the back of the congrega… Thu 23rd Oct 2008
The Courage to Obey (Part 2) In Ephesians 2:8 we read: “For it is by grace you have… Wed 22nd Oct 2008
Safe Eyes My oldest son, who is 10, casually shared with my wife and I… Mon 20th Oct 2008
In My Father’s House I am a mature woman who is relearning what it means to be pa… Thu 16th Oct 2008
Fear Takes the Bus Our flight from Toronto to Calgary was at 27,000 feet and cl… Mon 13th Oct 2008
Never Give Up Happy Thanksgiving! As we pause this month to be thankful fo… Fri 10th Oct 2008
Sincerity of Heart Last Sunday I took the bus to church. As I passed through li… Fri 10th Oct 2008
The Courage to Obey (Part 1) Every now and then, Scripture gives us a verse or a paragrap… Wed 8th Oct 2008
Passionate Spirituality I was at a workshop recently where we were asked to discuss … Mon 6th Oct 2008
Ambassadors of Holiness It’s no secret that Salvationists have high standards … Wed 1st Oct 2008
Meet My Car Franky! “Culture resides in our minds, in the stories we tell … Mon 29th Sep 2008
The Church and the Golden Arch… With the exception of Antarctica, you can have a Big Mac on … Wed 24th Sep 2008
God is in Control On the night before his execution, Peter slept like a baby. … Mon 22nd Sep 2008
The Army's Got Talent It’s evening. I’m at Camp Sunrise in Gibson, B.C… Thu 18th Sep 2008
Who Will Lead Us? Fear is a real emotion. Last week I watched my youngest daug… Thu 18th Sep 2008
Dion’s Open Book As someone who has spent the past 18 years of my life workin… Wed 17th Sep 2008
Hand Cutting Should I cut off my hand or leave it alone? This is the ques… Mon 15th Sep 2008
Salvation Army Identity In November 2005, more than 150 Salvationists from across Ca… Fri 22nd Aug 2008
What About Rich People? OVER the past decade, in many parts of the world, there has … Thu 17th Jan 2008