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 201 to 225
< 1 2 … 7 8 9 10 11 … 48 49 >
Title Summary Date
Extreme Clergy - Vision TV VisionTV doc series tells true stories of clergy who fight f… Thu 15th May 2008
Booth College Celebrates its 2… The last weekend of April brought to a climax the 2007-2008 … Wed 14th May 2008
VisionTV's Naked Archaeologist In the new season of his acclaimed VisionTV documentary seri… Wed 14th May 2008
Army Publications Win Eight Ch… Salvationist and Faith & Friends magazines won a total of ei… Mon 12th May 2008
Volunteer Appreciation - New W… Bakery donations distributed Lunch Volunteers Service Pun… Mon 12th May 2008
It's All About People New chief secretary shares how integrated mission continues … Sun 11th May 2008
Volunteer Appreciation - Sunse… Pictures from the Sunset Lodge volunteer appreciation dinner… Fri 9th May 2008
Volunteer Appreciation - Campb… Campbell River Appreciation Dinner for Kettle Volunteers … Tue 6th May 2008
Fire Ravages Salvation Army Wa… A weekend fire at a Toronto Salvation Army warehouse has cau… Mon 5th May 2008
Handle With Care When it comes to evangelism, pressure tactics don’t w… Mon 5th May 2008
2008 Soldier and Adherent Enro…   Brampton, Ontario (L-R) Boyd Cooper, Lynn Coope… Fri 2nd May 2008
Responding to God’s Cal… The decision I made to become a soldier of The Salvation Arm… Wed 30th Apr 2008
Catch the Vision Dr. Jeremy Mills, Chair, Symposium2008At Symposium 2008, del… Tue 29th Apr 2008
Gateway Linens Opens Doors for… Dion Oxford and Jay Hockaday help prepare the new laundry fa… Mon 28th Apr 2008
New Mattresses for Yellowknife… Cpt Dale Sobool, northern territories ministry co-ordinator,… Sat 26th Apr 2008
Annual Change 2008 See a pdf version here: Annual Change 2008 ANNUAL CHANGE 200… Fri 25th Apr 2008
Job Opportunity - Editor of Sa… If you have writing and web management skills, submit your r… Fri 25th Apr 2008
Pray for Zimbabwe The Chief of the Staff, Commissioner Robin Dunster is urging… Fri 25th Apr 2008
Miraculous Makeovers - VisionT… Miraculous makeovers: VisionTV's Divine Restoration returns … Thu 24th Apr 2008
Privilege or Pledge? In an age of customer loyalty cards and rewards programs, ha… Thu 24th Apr 2008
New Candidates Accepted for Pr… Nine new candidates have been accepted to enter CFOT in Winn… Mon 21st Apr 2008
We Need Heroes Rescuing the Army’s military metaphor from a quaint h… Mon 21st Apr 2008
Outside the City Gates Tackling the HIV/AIDS pandemic in Africa means walking with … Thu 10th Apr 2008
Excerpts From My Journal Here I am, 30,000 feet in the air with God’s creation… Thu 3rd Apr 2008
General's Pastoral Letters Num…       April 2008 - From the Office of th… Thu 3rd Apr 2008