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 between 2008-08-01 and 2008-08-31

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

Found one Page:
Title Summary Date
Around The Territory - Last 15… (Click here to see more entries...) (Click here to see more… Wed 20th Aug 2008

Found 22 Articles:
Title Summary Date
Considering Officership Salvation Army officership is something that almost every Sa… Fri 29th Aug 2008
Interacting with Current Cultu… In November 2005, more than 150 Salvationists from across Ca… Tue 26th Aug 2008
Mobilize 2008 Prepares for Eme… More than 200 delegates from across Canada met in Calgary to… Fri 22nd Aug 2008
Salvation Army Identity In November 2005, more than 150 Salvationists from across Ca… Fri 22nd Aug 2008
Olympic Fever Hits Belleville Right across the country, Canadians are following their Olym… Thu 21st Aug 2008
Salvation Warm Salvationist greetings from London! The theme of thi… Wed 20th Aug 2008
Newfoundland and Labrador Prov… Despite the cold, wet weather, the spirits and expectations … Tue 19th Aug 2008
Wake the Sleeping Giant Youth and children’s ministry in Quebec is like a slee… Mon 18th Aug 2008
It Starts With One I was commissioned as a Salvation Army officer on Sunday, Ju… Fri 15th Aug 2008
Salvation Army Officers Appoin… International Headquarters announces that The Salvation Army… Fri 15th Aug 2008
No Action Without Reflection "Salvationists pride themselves on being ‘doers o… Thu 14th Aug 2008
Salvation Army Delegates Gain … The Salvation Army was represented by 45 delegates from 20 t… Thu 14th Aug 2008
Serving a Hurting World   The hubbub of kids making arts and crafts, shooting … Wed 13th Aug 2008
Stand By Me Generation Y, also known as the Millennials, are the young p… Mon 11th Aug 2008
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