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 601 to 625
< 1 2 … 23 24 25 26 27 … 48 49 >
Title Summary Date
Age of Protection Bill Passes … Bill C-22 (Age of Protection) was passed by the House of Com… Mon 14th May 2007
Letter to the Editor Dear Colonel Moulton, I just read the information you posted… Mon 14th May 2007
Snapshot of Rural Ministry Winds of change are blowing … Small-town churches are … Mon 14th May 2007
A Woman of Distinction Winnipeg - Congratulations to Laurie Read who recently was a… Fri 11th May 2007
A Legacy and a Promise William and Catherine Booth College celebrates 25 years of m… Thu 10th May 2007
Opening of The Wiseman Centre … On April 11, 2007, Commissioner M. Christine MacMillan, alon… Thu 10th May 2007
Smithers Thrift Store Undergoi… The Town of Smithers, population 5,414, is situated in the B… Thu 10th May 2007
Stewardship - Make your Mark As a member of the church, Christ’s body, you’… Thu 10th May 2007
Anniversary celebrations Newfoundland - Congratulations to the Mount Moriah Corps, NL… Wed 9th May 2007
International Leaders Visit Ca… On Wednesday, April 25, 2007, a large group of officers and … Wed 9th May 2007
Ontario Great Lakes Division S… The Salvation Army Lakeshore Breeze is a quarterly newslette… Wed 9th May 2007
Cadet Summer Assignments 2007 CFOT.ca is pleased to announce Summer Assignments for the Go… Tue 8th May 2007
Chief Secretary's Quarterly Re… The following is the 1st Quarter 2007 Chief Secretary's repo… Tue 8th May 2007
Smaller Churches Have Big Appe… Do small churches suffer from inferiority complexes? Elzo Te… Tue 8th May 2007
Canadian Church Press Awards o… Congratulations go out to the THQ Editorial Department on aw… Mon 7th May 2007
CFOT Congratulates One of Its … Booth College was the scene of much excitement this weekend … Mon 7th May 2007
CSB Visits Montreal The morning of Saturday, May 5, dawned bright and early as t… Mon 7th May 2007
Emergency Preparedness Week Ma… This week is Emergency Preparedness Week. A number of Salva… Mon 7th May 2007
Not For Sale More people are enslaved today than ever before-but most peo… Mon 7th May 2007
When the Music Isn’t in… Six ideas for congregations when music resources are scarce … Fri 4th May 2007
INTEGRATE - HAITI '07 A team of 14 youth from the Ontario Great Lakes area (INTEGR… Thu 3rd May 2007
No more door-to-door collectin… Kitchener-Waterloo - Times have changed and The Salvation Ar… Thu 3rd May 2007
One woman’s hell…… Domestic violence - a personal story. Growing up Mennonite, … Thu 3rd May 2007
UK Territory Leader Inducted a… COMMISSIONER Betty Matear (Territorial President of Women's … Wed 2nd May 2007
A Blast of Brass The Montreal Citadel Corps is alive and well. One evidence o… Tue 1st May 2007