Describe the issue or problem
This is a fresh install.
This error is similar to other reported errors on upgrading OJS 3.3.0-X, but that fix will not work in this case. The url being called is “/install”
PHP Fatal error: Uncaught Error: Call to a member function getConnection() on null in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php:74
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Capsule\Manager::connection()
#1 /var/www/ojs/lib/pkp/classes/db/DAO.inc.php(65): Illuminate\Database\Capsule\Manager::__callStatic()
#2 /var/www/ojs/lib/pkp/classes/context/ContextDAO.inc.php(63): DAO->retrieve()
#3 /var/www/ojs/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath()
#4 /var/www/ojs/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext()
#5 /var/www/ojs/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter()
#6 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(114): Request->getContext()
#7 /var/www/ojs/classes/template/TemplateManager.inc.php(28): PKPTemplateManager->initialize()
#8 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(1247): TemplateManager->initialize()
#9 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(359): PKPTemplateManager::getManager()
#10 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(115): Plugin->_registerTemplateResource()
#11 /var/www/ojs/lib/pkp/classes/plugins/LazyLoadPlugin.inc.php(28): Plugin->register()
#12 /var/www/ojs/plugins/generic/webFeed/WebFeedPlugin.inc.php(39): LazyLoadPlugin->register()
#13 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(69): WebFeedPlugin->register()
#14 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(142): PluginRegistry::register()
#15 /var/www/ojs/lib/pkp/classes/core/Dispatcher.inc.php(133): PluginRegistry::loadCategory()
#16 /var/www/ojs/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch()
#17 /var/www/ojs/index.php(68): PKPApplication->execute()
#18 {main}
thrown in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php on line 74
Steps I took leading up to the issue
access root page “/” and redirected to “/install” and crash with Fatal Error.
It seems the database doesn’t get initialized. Checked all Database Settings in “config.inc.php”.
Can access the database from a PHP test page with the same settings:
$mysqli_connection = new MySQLi('localhost', 'ojs_user', 'xxxxxxxx', 'ojs3_db');
if ($mysqli_connection->connect_error) {
echo "Database not connected, error: " . $mysqli_connection->connect_error;
}
else {
echo "Database is Connected.";
}
https://ojs.cogitatiopress.com/dbtest.php
What application are you using?
OJS 3.3.0-13 LTS (installed on root of this server)
Additional information
PHP Version 8.1.10
nginx/1.21.0
MariaDB 10.5.17
[UPDATE] i found a place to force “initializeDatabaseConnection” and get past this error, but bumped into another error.
I added
Application::get()->initializeDatabaseConnection();
to function “__construct()” in “/lib/pkp/classes/db/DAO.inc.php”
Now the error is this below.
It seems OJS thinks it’s already installed, although in “config.inc.php” “installed = Off” (i am sure of this).
Any idea on how to fix this?
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db_ojs3.journals' doesn't exist in
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/context/ContextDAO.inc.php(65): Generator->current()
#7 /var/www/ojs/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath()
#8 /var/www/ojs/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext()
#9 /var/www/ojs/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter()
#10 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(114): Request->getContext()
#11 /var/www/ojs/classes/template/TemplateManager.inc.php(28): PKPTemplateManager->initialize()
#12 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(1247): TemplateManager->initialize()
#13 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(359): PKPTemplateManager::getManager()
#14 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(115): Plugin->_registerTemplateResource()
#15 /var/www/ojs/lib/pkp/classes/plugins/LazyLoadPlugin.inc.php(28): Plugin->register()
#16 /var/www/ojs/plugins/generic/webFeed/WebFeedPlugin.inc.php(39): LazyLoadPlugin->register()
#17 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(69): WebFeedPlugin->register()
#18 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(142): PluginRegistry::register()
#19 /var/www/ojs/lib/pkp/classes/core/Dispatcher.inc.php(133): PluginRegistry::loadCategory()
#20 /var/www/ojs/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch()
#21 /var/www/ojs/index.php(68): PKPApplication->execute()
#22 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db_ojs3.journals' doesn't exist in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(83): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/context/ContextDAO.inc.php(65): Generator->current()
#7 /var/www/ojs/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath()
#8 /var/www/ojs/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext()
#9 /var/www/ojs/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter()
#10 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(114): Request->getContext()
#11 /var/www/ojs/classes/template/TemplateManager.inc.php(28): PKPTemplateManager->initialize()
#12 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(1247): TemplateManager->initialize()
#13 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(359): PKPTemplateManager::getManager()
#14 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(115): Plugin->_registerTemplateResource()
#15 /var/www/ojs/lib/pkp/classes/plugins/LazyLoadPlugin.inc.php(28): Plugin->register()
#16 /var/www/ojs/plugins/generic/webFeed/WebFeedPlugin.inc.php(39): LazyLoadPlugin->register()
#17 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(69): WebFeedPlugin->register()
#18 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(142): PluginRegistry::register()
#19 /var/www/ojs/lib/pkp/classes/core/Dispatcher.inc.php(133): PluginRegistry::loadCategory()
#20 /var/www/ojs/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch()
#21 /var/www/ojs/index.php(68): PKPApplication->execute()
#22 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db_ojs3.journals' doesn't exist (SQL: SELECT * FROM journals WHERE path = install) in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#2 [internal function]: Illuminate\Database\Connection->cursor()
#3 /var/www/ojs/lib/pkp/classes/context/ContextDAO.inc.php(65): Generator->current()
#4 /var/www/ojs/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath()
#5 /var/www/ojs/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext()
#6 /var/www/ojs/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter()
#7 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(114): Request->getContext()
#8 /var/www/ojs/classes/template/TemplateManager.inc.php(28): PKPTemplateManager->initialize()
#9 /var/www/ojs/lib/pkp/classes/template/PKPTemplateManager.inc.php(1247): TemplateManager->initialize()
#10 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(359): PKPTemplateManager::getManager()
#11 /var/www/ojs/lib/pkp/classes/plugins/Plugin.inc.php(115): Plugin->_registerTemplateResource()
#12 /var/www/ojs/lib/pkp/classes/plugins/LazyLoadPlugin.inc.php(28): Plugin->register()
#13 /var/www/ojs/plugins/generic/webFeed/WebFeedPlugin.inc.php(39): LazyLoadPlugin->register()
#14 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(69): WebFeedPlugin->register()
#15 /var/www/ojs/lib/pkp/classes/plugins/PluginRegistry.inc.php(142): PluginRegistry::register()
#16 /var/www/ojs/lib/pkp/classes/core/Dispatcher.inc.php(133): PluginRegistry::loadCategory()
#17 /var/www/ojs/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch()
#18 /var/www/ojs/index.php(68): PKPApplication->execute()
#19 {main}
thrown in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
I am also getting the same reply. I am trying to upgrade from 3.2.1-4 to 3.3.0.13.
I found and fixed the problem. Apparently an OJS fresh /install does not like when the “config.inc.php” already has been changed, specially to provide the [database] section variables.
The solution was to replace my changed “config.inc.php” with the original one and then the /install URL worked.
I noticed that the generated “config.inc.php” from the /install form fields put the password variable enclosed in quotes (password = “xxxxxxxx”). My previous settings didn’t have quotes (password = xxxxxxxx). Maybe that was causing the /install page errors…