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 Candidates, Officership, Spiritual-Formation

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

Found 26 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Making a Difference Last summer I attended a beautiful wedding on a warm July af… Wed 21st Jan 2009
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
Passionate Life in Service We have all heard the expression, “I never really appr… Wed 22nd 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
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
Dudley Coles' Leap of Faith It took Dudley Coles 10 years to plan and write Leap of Fait… Wed 24th Sep 2008
Who Will Lead Us? Fear is a real emotion. Last week I watched my youngest daug… Thu 18th Sep 2008
There's No Life Like It I didn’t grow up dreaming about being a Salvation Army… Tue 16th Sep 2008
Hand Cutting Should I cut off my hand or leave it alone? This is the ques… Mon 15th Sep 2008
Considering Officership Salvation Army officership is something that almost every Sa… Fri 29th Aug 2008
When God Says Go He continually reminds me that officership was his idea W… Mon 28th Jul 2008
God’s Fellow Workers Co… “For the past two years, God has been shaping your hea… Tue 24th Jun 2008
A Willing Heart Ministry should be a joy, not a burden I don’t know a… Mon 9th Jun 2008