Oh now I’m getting somewhere!
I cleaned out the entire cache folder on the OJS installation folder and now my error log is looking like it’s making more sense on what I need to be looking for.
[01-Mar-2021 19:08:43 UTC] ojs2: 404 Not Found
[01-Mar-2021 19:22:42 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘g.submission_file_id’ in ‘on clause’ in …/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 …/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘SELECT sf., g…', Array)
#1 …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCa in …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[01-Mar-2021 19:37:31 UTC] PHP Fatal error: Uncaught Error: Call to a member function getData() on null in …/ojs/plugins/generic/htmlArticleGalley/HtmlArticleGalleyPlugin.inc.php:70
Stack trace:
#0 …/ojs/lib/pkp/classes/plugins/HookRegistry.inc.php(107): HtmlArticleGalleyPlugin->articleViewCallback(‘ArticleHandler:…’, Array)
#1 …/ojs/pages/article/ArticleHandler.inc.php(311): HookRegistry::call(‘ArticleHandler:…’, Array)
#2 …/ojs/lib/pkp/classes/core/PKPRouter.inc.php(395): ArticleHandler->view(Array, Object(Request))
#3 …/ojs/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#4 …/ojs/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request))
#5 …/ojs/lib/pkp/classes/core/PKPApplication.inc.php(365): Dispatcher->dispatch(Object(R in …/ojs/plugins/generic/htmlArticleGalley/HtmlArticleGalleyPlugin.inc.php on line 70
[01-Mar-2021 19:41:21 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘g.submission_file_id’ in ‘on clause’ in …/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 …/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('SELECT sf., g…’, Array)
#1 …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCa in …/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[01-Mar-2021 19:42:27 UTC] ojs2: 404 Not Found
Now that I know it’s something I’m not familiar with at all, I feel better (oddly). I’m not familiar at all with the database running it all, which I can access on the phpAdmin page, but don’t know much about.
Any advice would be welcome!
EDIT 2021-03-01T06:00:00Z
When I turn the installation to installed = off
, I can’t even access the Install webpage. Maybe it didn’t update the database correctly when I ran the script on the server.
EDIT 2 2021-03-01T06:00:00Z
The update did in fact fail when I attempted to run it but I didn’t get the script as to why it failed until now when I attempted it again.
[pre-install]
[load: upgrade.xml]
[version: 3.3.0.3]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::installDefaultNavigationMenus]
[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
[migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘url’ in ‘field list’ (SQL: select url
, navigation_menu_item_id
from navigation_menu_items
where context_id
= 1)
I’m not good at anything with SQL so all help would be appreciated.