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 751 to 775
< 1 2 … 29 30 31 32 33 … 48 49 >
Title Summary Date
New Game Plan for Sports Minis… As Jack O’Halloran explains, organized sports is a cr… Thu 15th Feb 2007
Mom's and Tot's getaway Toronto, Ont. - Bloor Central corps sent seven moms and thei… Wed 14th Feb 2007
Mirroring God's Love in Zimbab… Through a lifetime of ministry Major (Dr.) Dawn Howse has le… Tue 13th Feb 2007
The Fire is Burning! First there was smoke, now there’s FIRE! The fire is … Tue 13th Feb 2007
Volunteers deliver Christmas j… Burlington, Ont. - Community Care workers at the Burlington … Tue 13th Feb 2007
Action in Ottawa The following pictures display highlights in 2006 from the O… Mon 12th Feb 2007
Church’s role lies with… Commissioner Christine MacMillan said the Salvation Army has… Mon 12th Feb 2007
A Sacred Trust Across Canada, more than 2,100 seniors requiring long-term c… Fri 9th Feb 2007
Episode 224: The Salvation Arm… Lois Flemming is The Salvation Ar… Fri 9th Feb 2007
Vancouver 614 Spreads Its Wing… A weekly prayer meeting at Vancouver 614 was the setting for… Fri 9th Feb 2007
"While Women Weep" c… As we approach the end of the fiscal year the World Services… Thu 8th Feb 2007
Hope when all seems lost A year and a half ago, life for Christina looked bleak. Alon… Thu 8th Feb 2007
Salvation Army starts financia… London, Ont. - A charitable arm of a financial giant, Citigr… Thu 8th Feb 2007
Missing daughter of SA officer… Makarena, daughter of Cpts Mauricio and Erika Urzua in Ecuad… Wed 7th Feb 2007
Operation Jack Frost Volunteer Darren Wiseman hits the streets of Saint John, N.B… Wed 7th Feb 2007
Caption competition: winner Thanks to all who sent in captions for the above picture. Co… Tue 6th Feb 2007
Tales of life on the road In his role as director of world missions, Brian Burditt oft… Tue 6th Feb 2007
Back to Basics Surviving on a budget of $2 a day helped my family appreciat… Mon 5th Feb 2007
First Nations focus at Mission… March 1 to 3 - Kenny Blacksmith, a Canadian First Nations Ch… Mon 5th Feb 2007
Salvation Army aids Florida to… About 50 National Guard troops, residents and volunteers hel… Mon 5th Feb 2007
Episode 223: The Salvation Arm… A team of Salvationist women from… Fri 2nd Feb 2007
French national website launch… I am pleased to announce that we have launched the French Na… Thu 1st Feb 2007
General Announces Internationa… EFFECTIVE 1 JULY 2007-COMMISSIONER CHRISTINE MACMILLAN, terr… Thu 1st Feb 2007
General to connect electronica… MARCH 2007 will see the General initiating a huge step forwa… Thu 1st Feb 2007
New Territorial Leaders EFFECTIVE 1 JULY 2007-Commissioners William and Marilyn Fran… Thu 1st Feb 2007