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 tag Donation

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

Found 17 Articles:
Title Summary Date
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
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 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
Wal-Mart, USA, Donates $150,00… Wal-Mart Stores, Inc., has donated $150,000 to assist in The… Thu 30th Aug 2007
Don’t expect to see ATM… Offerings of plastic could be the next big thing for churchg… Mon 26th Feb 2007
Salvation Army gets huge shoe … Saskatoon - Less fortunate families will get an extra specia… Thu 21st Dec 2006
Being a Geek pays off! A new computer donation program provides underprivileged chi… Tue 12th Dec 2006
Become a fundraiser, win an iP… SalvationArmy.ca is having a fundraising contest! Between No… Tue 14th Nov 2006
Maritimes response unit thanks… The Salvation Army Maritimes Community Resonse Unit will kee… Wed 4th Oct 2006
In memory of their mom Glovertown, Nfld. - Children of the late Olive Holloway dona… Mon 10th Jul 2006
Edmonton West rotary club help… The Rotary Club of Edmonton West donated a 15-passenger vehi… Sun 18th Jun 2006
A Gift That Will Keep On Givin… Long after retirement from a remarkable career as a public s… Mon 5th Jun 2006
Curves in Burnaby donates to T… The owner of several Curves in Burnaby, B.C., Susan Ruetz, i… Thu 25th May 2006