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 101 to 125
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
Passionate Spirituality I was at a workshop recently where we were asked to discuss … Mon 6th Oct 2008
Gifts of Hope We know you put a lot of thought into the gifts that you giv… Fri 3rd Oct 2008
I Am Not a Metaphor Some months back my wife, Alison, and I became officers in o… Fri 3rd Oct 2008
Florence Booth’s Missio… From its earliest days, The Salvation Army has advocated on … Thu 2nd Oct 2008
Ambassadors of Holiness It’s no secret that Salvationists have high standards … Wed 1st Oct 2008
Mary's Song Much of this blog should be credited to Brian Walsh and the … Wed 1st Oct 2008
A New Heaven and a New Earth Oprah Winfrey recently co-hosted a 10-week spirituality clas… Tue 30th Sep 2008
Help in the Heart of Quebec Ci… Luc arrived at the Hôtellerie without a penny in his p… Mon 29th Sep 2008
Meet My Car Franky! “Culture resides in our minds, in the stories we tell … Mon 29th Sep 2008
Out of Our Comfort Zone A few months ago I went to a farmers’ workshop in a ru… Fri 26th Sep 2008
Defining Neighbour Look at those autumn leaves. What a beautiful time of the ye… Thu 25th Sep 2008
Dudley Coles' Leap of Faith It took Dudley Coles 10 years to plan and write Leap of Fait… Wed 24th Sep 2008
Release the Captives “Over the last 10 years, the numbers of women and chil… Wed 24th Sep 2008
The Church and the Golden Arch… With the exception of Antarctica, you can have a Big Mac on … Wed 24th Sep 2008
Here I Am I’d like to use this blog space as a way to give peopl… Tue 23rd Sep 2008
God is in Control On the night before his execution, Peter slept like a baby. … Mon 22nd Sep 2008
Prayer Warriors Begin Their Jo… Salvationists in Winnipeg were buzzing with energy and excit… Fri 19th Sep 2008
Unity in Mission As the new corps officers of High Point Community Church, my… Fri 19th Sep 2008
Salvation Army Night with the … For a number of years, Blue Jays President and CEO Paul Godf… Thu 18th 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
I Have a Question I have a question that doesn’t require an answer. It&r… Tue 16th Sep 2008
There's No Life Like It I didn’t grow up dreaming about being a Salvation Army… Tue 16th Sep 2008
Fighting Human Trafficking on … The Newfoundland and Labrador Human Trafficking Committ… Mon 15th Sep 2008