I am upgrading from PKP 2.4 to 3.0.2 on Ubuntu, MySQL 5.5.
I followed the full package procedure. The upgrade command completed with no message.
When I access the website, I get the following screen:
DB Error: Unknown column ‘context_id’ in ‘on clause’
Stack Trace:
File: /var/www/html/journal/lib/pkp/classes/site/VersionDAO.inc.php line 238
Function: DAO->retrieve(“SELECT v.* FROM versions v LEFT JOIN plugin_settings ps ON …”, Array(1), False)
File: /var/www/html/journal/lib/pkp/classes/core/PKPApplication.inc.php line 301
Function: VersionDAO->getCurrentProducts(Array(1))
File: /var/www/html/journal/lib/pkp/classes/plugins/PluginRegistry.inc.php line 103
Function: PKPApplication->getEnabledProducts(“plugins.generic”, Null)
File: /var/www/html/journal/lib/pkp/classes/core/Dispatcher.inc.php line 132
Function: PluginRegistry::loadCategory(“generic”, True)
File: /var/www/html/journal/lib/pkp/classes/core/PKPApplication.inc.php line 227
Function: Dispatcher->dispatch(Object(Request))
File: /var/www/html/journal/index.php line 68
Function: PKPApplication->execute()
After the failure, I upgraded to MySQL 5.7, but with the same result.
It seems somehow related with the plug-ins.
We had installed very few plugins (e.g., Crossref). But, since some time, on the production server, the System plugin page cannot be loaded. So there could be an issue there.