Hello,
I am totally new to this app. I was working on a mult-journal project: jdons.org. I stopped for some time. Now, I am trying to resume but have been unable to get past upgrading the application. Fortunately, I was able to bring it to a 3.5.However, it is popping up the errors below, which I was hoping someone might be familiar with how to resolve any or some of them:
Errors occurred during installation:
- A database error has occurred: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘at.assoc_type’ in ‘WHERE’ in /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407 Stack trace: #0 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare() #1 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #3 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run() #4 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select() #5 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3362): Illuminate\Database\Query\Builder->runSelect() #6 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3358): Illuminate\Database\Query\Builder->onceWithColumns() #8 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(636): Illuminate\Database\Query\Builder->pluck() #9 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(535): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->PKP\migration\upgrade\v3_4_0\{closure}() #10 [internal function]: PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->PKP\migration\upgrade\v3_4_0\{closure}() #11 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(535): array_reduce() #12 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(525): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->processTable() #13 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(58): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->clearOrphanedEntities() #14 /home/abcwuird/jdons.org/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(28): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->up() #15 /home/abcwuird/jdons.org/lib/pkp/classes/install/Installer.php(445): APP\migration\upgrade\v3_4_0\PreflightCheckMigration->up() #16 /home/abcwuird/jdons.org/lib/pkp/classes/install/Installer.php(298): PKP\install\Installer->executeAction() #17 /home/abcwuird/jdons.org/lib/pkp/classes/install/Installer.php(207): PKP\install\Installer->executeInstaller() #18 /home/abcwuird/jdons.org/lib/pkp/classes/install/form/UpgradeForm.php(49): PKP\install\Installer->execute() #19 /home/abcwuird/jdons.org/lib/pkp/pages/install/InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #20 [internal function]: PKP\pages\install\InstallHandler->installUpgrade() #21 /home/abcwuird/jdons.org/lib/pkp/classes/core/PKPRouter.php(327): call_user_func() #22 /home/abcwuird/jdons.org/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #23 /home/abcwuird/jdons.org/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route() #24 /home/abcwuird/jdons.org/lib/pkp/classes/core/PKPApplication.php(426): PKP\core\Dispatcher->dispatch() #25 /home/abcwuird/jdons.org/index.php(21): PKP\core\PKPApplication->execute() #26 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘at.assoc_type’ in ‘WHERE’ (Connection: mariadb, SQL: select distinct `at`.`type_id` from `announcement_types` as `at` left join `journals` as `c` on `at`.`assoc_id` = `c`.`journal_id` where `c`.`journal_id` is null or `at`.`assoc_type` <> 256) in /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825 Stack trace: #0 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #1 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run() #2 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select() #3 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3362): Illuminate\Database\Query\Builder->runSelect() #4 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/abcwuird/jdons.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3358): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(636): Illuminate\Database\Query\Builder->pluck() #7 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(535): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->PKP\migration\upgrade\v3_4_0\{closure}() #8 [internal function]: PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->PKP\migration\upgrade\v3_4_0\{closure}() #9 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(535): array_reduce() #10 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(525): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->processTable() #11 /home/abcwuird/jdons.org/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(58): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->clearOrphanedEntities() #12 /home/abcwuird/jdons.org/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(28): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->up() #13 /home/abcwuird/jdons.org/lib/pkp/classes/install/Installer.php(445): APP\migration\upgrade\v3_4_0\PreflightCheckMigration->up() #14 /home/abcwuird/jdons.org/lib/pkp/classes/install/Installer.php(298): PKP\install\Installer->executeAction() #15 /home/abcwuird/jdons.org/lib/pkp/classes/install/Installer.php(207): PKP\install\Installer->executeInstaller() #16 /home/abcwuird/jdons.org/lib/pkp/classes/install/form/UpgradeForm.php(49): PKP\install\Installer->execute() #17 /home/abcwuird/jdons.org/lib/pkp/pages/install/InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #18 [internal function]: PKP\pages\install\InstallHandler->installUpgrade() #19 /home/abcwuird/jdons.org/lib/pkp/classes/core/PKPRouter.php(327): call_user_func() #20 /home/abcwuird/jdons.org/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #21 /home/abcwuird/jdons.org/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route() #22 /home/abcwuird/jdons.org/lib/pkp/classes/core/PKPApplication.php(426): PKP\core\Dispatcher->dispatch() #23 /home/abcwuird/jdons.org/index.php(21): PKP\core\PKPApplication->execute() #24 {main}
Thanks a bunch.