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-Dion-Oxford, Church

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

Found 22 Articles:
Title Summary Date
New Year's Resolution I know it’s trendy these days to make fun of New Year&… Thu 8th Jan 2009
Heaven’s Rehearsal A few weeks ago, an event called “Heaven’s Rehea… Tue 2nd Dec 2008
It’s Christmas Time As we approach Christmas, I’ve been reading the ancien… Fri 28th Nov 2008
The Idol of the Market The market, as we know, is an entity that by its very nature… Wed 29th Oct 2008
Winds of the Spirit Sweep Thro… We instantly noticed him sitting at the back of the congrega… Thu 23rd Oct 2008
Election Day Well, it’s the day after Canada’s 40th election … Wed 15th Oct 2008
Sincerity of Heart Last Sunday I took the bus to church. As I passed through li… Fri 10th Oct 2008
Passionate Spirituality I was at a workshop recently where we were asked to discuss … Mon 6th Oct 2008
Mary's Song Much of this blog should be credited to Brian Walsh and the … Wed 1st Oct 2008
The Church and the Golden Arch… With the exception of Antarctica, you can have a Big Mac on … Wed 24th Sep 2008
The Army's Got Talent It’s evening. I’m at Camp Sunrise in Gibson, B.C… 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
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
Magic Mirror Sacred Cow Mirror, mirror, on the wall … who’s the fairest… Mon 12th Nov 2007
Brantford Salvation Army Dedic… The Salvation Army Wyndfield Community Church is one of the … Wed 7th Nov 2007
Exploring The Simple Way Shane Claiborne urges us to stop being the church we complai… Mon 25th Jun 2007
Smaller Churches Have Big Appe… Do small churches suffer from inferiority complexes? Elzo Te… Tue 8th May 2007
The Church at the end of moder… Modernism is breaking down, and many Christians are now chur… Mon 9th Oct 2006
Northridge Community Church Ce… Northridge Community Church, Newmarket, Ont., held an apprec… Mon 17th Jul 2006
Passing the torch! Gloverton Corps, Nfld. - Mjr Marvin Youden, CO, commissions … Wed 10th May 2006
Who's religious? Adult Canadians attach a higher degree of importance to reli… Wed 3rd May 2006