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 426 to 450
< 1 2 … 16 17 18 19 20 … 48 49 >
Title Summary Date
Grand Opening Brantford, Ont. - The Salvation Army Wyndfield Community Chu… Mon 17th Sep 2007
Taking the Fear Out of Biblica… How do I know that the Bible is accurate? What difference do… Mon 17th Sep 2007
Sleep In The Park To Help Home… Dunnville, Ont. - "We want to make the public aware that hom… Fri 14th Sep 2007
Workers' Rites What happens when an employee's freedom of religion crosses … Fri 14th Sep 2007
School Breakfast Program Gets … Victoria, B.C. - This week Telus donated $20,000 to The Salv… Thu 13th Sep 2007
Territorial Camp Celebrates 40… On August 25, 2007, 138 students arrived at Jackson’s… Thu 13th Sep 2007
Salvation Army calls for praye… The Salvation Army has designated Sept. 28-30, 2007, as a we… Wed 12th Sep 2007
One of Humanity’s Darke… “The Salvation Army was the greatest thing that happen… Tue 11th Sep 2007
School’s Back How to help your child succeed and grow in the coming year H… Mon 10th Sep 2007
Young Salvationist Becomes Loc… Earlier this year, Salvationist Becky Puddicombe of Niagara … Mon 10th Sep 2007
Personnel Services Announcemen… IHQ has given approval for  personnel services to institu… Fri 7th Sep 2007
CFOT Announces... Cfot is pleased to announce the flagbearer for the Witnesses… Wed 5th Sep 2007
History Bites September 3 - In 1934, in London, England, Evangeline Cory B… Wed 5th Sep 2007
Reflecting On Liberty The symbolic epicenter of freedom, the Statue of Liberty, ho… Wed 5th Sep 2007
Wal-Mart, USA, Donates $150,00… Wal-Mart Stores, Inc., has donated $150,000 to assist in The… Thu 30th Aug 2007
Community Spirit When fire struck a Toronto neighbourhood, members of The War… Mon 27th Aug 2007
Captain Elizabeth Nelson
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Heather Richardson
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Karen Lemke
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Margaret McLeod
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Sharon and Cadet Jason…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains (Dr.) Paul and Pedrin…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Keith and Joyce Warfo…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Mark and Barbara Stan…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Sheldon and Clare Fee…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007