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 826 to 850
< 1 2 … 32 33 34 35 36 … 48 49 >
Title Summary Date
Emergency preparation essentia… Government officials and organizations such as the Salvation… Tue 2nd Jan 2007
Episode 218: The Salvation Arm… Feature: Looking back on 2006 and… Tue 2nd Jan 2007
Local newspapers a great suppo… Penticton, B.C. - One is constantly amazed at the volume of … Tue 2nd Jan 2007
Manitoba most generous provinc… When it comes to charitable donations, Manitoba ranks first … Fri 29th Dec 2006
The Cattle Were What? While listening to "Away in a Manger" at a Christmas program… Fri 29th Dec 2006
New homelessness partnering st… OTTAWA - Canada’s government has committed $526 milli… Thu 28th Dec 2006
Christmas memories When I was young, we were very poor. I was the baby in a fam… Wed 27th Dec 2006
Episode 217: The Salvation Arm… Feature: Commissioner Christine M… Tue 26th Dec 2006
Ontario North Divisional Semin… Leadership 360°, ‘Developing the Leader Within  Tue 26th Dec 2006
Salvation Army helps single mo… A few days ago, I was on the bus, when a lady sat beside me.… Tue 26th Dec 2006
Words and Songs to Greet the S… General Shaw Clifton challenges Salvationists to lift up the… Mon 25th Dec 2006
Vancouver 614 corps brings an … 1. Kettle coordinator Darren Hailes (614 Vancouver) drops th… Sun 24th Dec 2006
Dream comes true Calgary - Tiny faces lit up Calgary last week as Santa's hel… Fri 22nd Dec 2006
Episode 216: The Salvation Arm… Feature: Retired Vancouver busine… Fri 22nd Dec 2006
Good Samaritan saves kettle fr… Port Alberni, BC - A Christmas Grinch attempted to steal a S… Fri 22nd Dec 2006
Sally Ann really is centre of … Christine Elias wears an enormous pair of musical, red and g… Fri 22nd Dec 2006
Salvation Army helper shot in … New Waterford, NS - It was a sad payback for a teenager dona… Fri 22nd Dec 2006
God behind new online initiati… The Anglican Church in Australia has fully embraced the far-… Thu 21st Dec 2006
Salvation Army gets huge shoe … Saskatoon - Less fortunate families will get an extra specia… Thu 21st Dec 2006
Christmas spirit Hamilton, Ont. - The following letter was received at the Ha… Wed 20th Dec 2006
Salvation Army seniors' band b… British Columbia - Every Wednesday evening, the sounds of Th… Wed 20th Dec 2006
An unusual enrolment Jeni Parsons and Regan Lipsett are enrolled under the colour… Tue 19th Dec 2006
Canada's Christian Channel wel… TORONTO, Dec 18, 2006 - The Christian Channel is adding musi… Tue 19th Dec 2006
Authors eager to help Sally An… Two Nanaimo, B.C., authors hope to raise $100,000 for The Sa… Mon 18th Dec 2006
Canadian Staff Band Website Re… The Canadian Staff Band is happy to be back online with our … Mon 18th Dec 2006