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 Donation, Emergency-Disaster-Services

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

Found 47 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Bermudian Salvationists Assist… Six Salvationists from Bermuda flew to Galveston, Texas… Wed 8th Oct 2008
Celebrating Service in Quebec The Salvation Army in Quebec recently held a retirement cele… Wed 3rd Sep 2008
Mobilize 2008 Prepares for Eme… More than 200 delegates from across Canada met in Calgary to… Fri 22nd Aug 2008
The Salvation Army Helps - Tor… The Salvation Army Helps Those Affected by the East York Hig… Mon 21st Jul 2008
Emergency Disaster Services - … On March 7 and 8, 2008, 18 representatives including officer… Thu 13th Mar 2008
City Shares Money From Parking… Penticton, B.C. - The City of Penticton donated $2,299 to Th… Wed 23rd Jan 2008
Salvation Army Shelter Receive… Yellowknife - The Salvation Army shelter received 20 brand n… Mon 14th Jan 2008
Launch Of The National Disaste… Since the attack on the World Trade Centre in New York City … Thu 10th Jan 2008
Canada Post Plays Santa Claus … For the seventh consecutive year, Canada Post will present T… Mon 24th Dec 2007
History Of The Salvation Army … The Salvation Army's kettles have been used for more than a … Thu 15th Nov 2007
The Salvation Army Builds 205 … Following the completion of 100 homes in Galagodawatte durin… Wed 14th Nov 2007
The Salvation Army Responds to… ALEXANDRIA, VA (October 23, 2007) - Having completed recover… Wed 24th Oct 2007
The Salvation Army Celebrates … On Tuesday, September 25, The Salvation Army joined with the… Wed 3rd Oct 2007
Canada Post Workers Stamp Out … B.C. - This Saturday, Sept. 22, in Dawson Creek and Fort St.… Fri 21st Sep 2007
Canadian Idol Fans Support The… Drumheller, AB - On Tuesday September 11, more than 1,200 Dr… Tue 18th Sep 2007
One of Humanity’s Darke… “The Salvation Army was the greatest thing that happen… Tue 11th Sep 2007
Wal-Mart, USA, Donates $150,00… Wal-Mart Stores, Inc., has donated $150,000 to assist in The… Thu 30th Aug 2007
Salvation Army Responds To Nee… Salvation Army emergency disaster personnel in Jamaica are r… Wed 22nd Aug 2007
Peru Earthquake (Update 1) Salvation Army relief teams continue to bring urgently neede… Tue 21st Aug 2007
The Salvation Army Sends Finan… Friday August 17, 2007 - After a 7.9 magnitude earthquake hi… Mon 20th Aug 2007
SA Emergency Disaster Vehicle … Nanaimo - For the past few days, people forced from their ho… Fri 15th Jun 2007
Emergency Preparedness Kits The Salvation Army and St. John Ambulance have partnered wit… Fri 18th May 2007
Emergency Preparedness Week Ma… This week is Emergency Preparedness Week. A number of Salva… Mon 7th May 2007
The Salvation Army continues t… Released April 17,2007 - The Salvation Army continues to mon… Wed 18th Apr 2007
Stories from The Salvation Arm… THE Salvation Army recently finished a project in Pakistan t… Thu 8th Mar 2007