Closed ExpectationMax closed 8 years ago
Rendering of research areas still relies on the faculties table which was removed in previous jresearch releases. This results in errors similar to:
Table 'joomla.xxxxx_jresearch_facilities' doesn't exist SQL=SELECT * ...
A find+grep shows that these tables are still accessed in multiple files:
find . -type f -name "*.php" -print0 | xargs -0 grep -i facilities ./admin/toolbar.jresearch.html.php: public static function facilitiesAdminListToolbar() { ./admin/toolbar.jresearch.html.php: JToolBarHelper::title(JText::_('JRESEARCH_FACILITIES')); ./plugins/plg_jresearch_search/jresearch_search.php:define('FACILITIES', JText::_('JRESEARCH_FACILITIES')); ./sef_ext/com_jresearch.php: // theses, teams, facilities and cooperations ./site/models/researchareas/researcharea.php: public function getFacilities($n=0){ ./site/models/researchareas/researcharea.php: $facilities = array(); ./site/models/researchareas/researcharea.php: return $facilities; ./site/models/researchareas/researcharea.php: $query = 'SELECT * FROM '.$db->quoteName('#__jresearch_facilities').' WHERE '.$db->quoteName('published').' = 1' ./site/models/researchareas/researcharea.php: $facilities[] = $item; ./site/models/researchareas/researcharea.php: return $facilities; ./site/views/researcharea/view.html.php: $facilities = $model->getFacilities($area->id); ./site/views/researcharea/view.html.php: $this->assignRef('facilities', $facilities);
Rendering of research areas still relies on the faculties table which was removed in previous jresearch releases. This results in errors similar to:
Table 'joomla.xxxxx_jresearch_facilities' doesn't exist SQL=SELECT * ...
A find+grep shows that these tables are still accessed in multiple files: