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 151 to 175
< 1 2 … 5 6 7 8 9 … 48 49 >
Title Summary Date
A Place of New Beginnings In 2007, the Bermuda Harbour Light celebrated 30 years of mi… Sat 9th Aug 2008
Federal Minister Tours Homeles… Monte Solberg, minister of human resources and social develo… Sat 9th Aug 2008
A Faith that Overspills Describe your own conversion experience. What made it unique… Fri 8th Aug 2008
An Explosion of Kindness Smoke isn’t usually part of the Sunday morning service… Thu 7th Aug 2008
Montreal’s Evangelistic… With its magic festival, block party and continental breakfa… Thu 7th Aug 2008
Shooting for Success Sports ministry is an exciting new outreach opportunity for … Wed 6th Aug 2008
Sports Ministry in North Vanco… More than 20 children meet each week at the John Braithwaite… Wed 6th Aug 2008
Harvest of Hope Congress 2008 Salvation Army congress will be a time of inspirational wors… Tue 5th Aug 2008
Sowing Seeds of Faith I dig my hand into the seed bag and gently scatter its conte… Mon 28th Jul 2008
When God Says Go He continually reminds me that officership was his idea W… Mon 28th Jul 2008
By Faith - We Take Risks From its earliest days right up until the present, The Salva… Wed 23rd Jul 2008
Peaceable Evangelism In the first of a two-part interview, Rick Tobias, CEO of Yo… Mon 21st Jul 2008
Summer Evangelism With Faith &… How are churches using the free summer edition of Faith &… Mon 21st Jul 2008
The Salvation Army Helps - Tor… The Salvation Army Helps Those Affected by the East York Hig… Mon 21st Jul 2008
Dr. Paul Thistle - Honorary De… Dr. Paul Thistle receives honorary Doctorate, Photo © D… Thu 17th Jul 2008
The Red Serge and the Red Shie… The Red Serge of the Royal Canadian Mounted Police is r… Thu 17th Jul 2008
Mom, I’m Pregnant When my daughter told me the news I didn’t know how to… Mon 14th Jul 2008
VisionTV Looks at Christianity… With the Beijing Olympic Games set to begin on August 8, wor… Mon 14th Jul 2008
Charlottetown Celebrates 122nd… Highlights of the festivities included the enrolment of Stef… Tue 8th Jul 2008
God's Cheerleader As Christians, we are called to root for the winning team … Mon 7th Jul 2008
Captain Dr. Paul Thistle Recei… Photo copyright 2008 Doug MacLellan On Wednesday, June 11… Fri 4th Jul 2008
Healing for Native Peoples On June 17, 2008, Commissioner William Francis wrote to Prim… Fri 4th Jul 2008
VisionTV's Extreme Clergy ***NEW EPISODE*** Airing Friday, July 18, 10:30 p.m. ET / 7… Wed 2nd Jul 2008
Dangerous Games The run-up to the Olympics has been clouded by protests over… Mon 30th Jun 2008
Chief Secretary's First Quarte… HEADLINES Evangelism Children & Youth Ministry Carefo… Tue 24th Jun 2008