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 Community-and-Family-Services, Symposium

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

Found one Page:
Title Summary Date
Symposium 2008 Symposium 2008 provides Salvationists an opportunity to seek… Thu 30th Oct 2008

Found 101 Articles: showing 1 to 25
< 1 2 3 4 5 >
Title Summary Date
The Five Territorial Propositi… The first video is footage of Dr. Jeremy Mills, Symposium 20… Tue 4th Nov 2008
Symposium 2008 Ends With Prais… On Sunday morning, there was a spirit of optimism and unity … Mon 3rd Nov 2008
Dreaming Big at Symposium 2008 Friday was a busy day for Symposium 2008 delegates. Man… Sat 1st Nov 2008
Symposium 2008 Is Underway On Thursday, October 30, over 140 delegates convened at Jack… Fri 31st Oct 2008
Symposium 2008 Opening Service… Commissioner William W. Francis, Territorial Commander, spea… Fri 31st Oct 2008
Symposium 2008 Video Blog #1 Visit Salvationist.ca/symposium for more updates. Fri 31st Oct 2008
Symposium October 31 Preparati… Jeremy Mills offers an update for October 31. Salvationists … Fri 31st Oct 2008
Moving Forward, Together Symposium 2008 provides Salvationists an opportunity to seek… Thu 30th Oct 2008
Territorial Day of Prayer for … Greetings, As Symposium 2008 draws closer I am inviting e… Wed 8th Oct 2008
Offering a Hand Up Life doesn’t often turn out how we expect it to. This … Wed 3rd Sep 2008
Interacting with Current Cultu… In November 2005, more than 150 Salvationists from across Ca… Tue 26th Aug 2008
Salvation Army Identity In November 2005, more than 150 Salvationists from across Ca… Fri 22nd Aug 2008
An Explosion of Kindness Smoke isn’t usually part of the Sunday morning service… Thu 7th Aug 2008
City Shares Money From Parking… Penticton, B.C. - The City of Penticton donated $2,299 to Th… Wed 23rd Jan 2008
Life For Old Blue Boxes Toronto - We're not to use our old blue boxes when recycling… Tue 22nd Jan 2008
Cobourg Thanks Community Cobourg, ON - The Salvation Army Community and Family Servic… Mon 21st Jan 2008
Peel Regional Police And The S… The Crime Prevention Academy of 2008, a breakthrough concept… Tue 25th Dec 2007
Canada Post Plays Santa Claus … For the seventh consecutive year, Canada Post will present T… Mon 24th Dec 2007
'Tis The Season Toronto - Police officers from 51 Division have partnered wi… Wed 19th Dec 2007
Toy Donors Are Asked To Check … Many charities are asking people to check Health Canada's re… Fri 14th Dec 2007
Salvation Army Positive Lifest… Manitoba - At least 30 Manitoba poker players charged after … Fri 7th Dec 2007
Arrested Poker Players Offered… Winnipeg - Poker players who were arrested during raids at t… Tue 6th Nov 2007
Sally Ann mobile food service … Prince George, B.C. - Last weekend The Salvation Army's mobi… Mon 22nd Oct 2007
The Salvation Army Launches Mo… Prince George, B.C. - This past weekend The Salvation Army i… Thu 18th Oct 2007
Coats For Kids Campaign Is A C… Cobourg - The whole community is getting involved in their 1… Tue 25th Sep 2007