Application Version
OJS 3.3.0-3 (https://pkp.sfu.ca/ojs/download/ojs-3.3.0-3.tar.gz)
Server
- PHP: 7.3.20
- Database server: MariaDB 10.3.27
Description of issue
Successfully upgraded OJS from 3.2.1-3 to OJS 3.2.1-4
Upgrade fails when trying to upgrade from OJS 3.2.1-3 or from OJS 3.2.1-4 to OJS 3.3.0-3
We have two different OJS installations, and the same result occurs when trying to upgrade both on our staging server.
The database user has been granted all rights for the OJS database.
Any insights would be appreciated.
Best,
Eirik Hanssen
OsloMet University Library.
Error message:
ERROR: Upgrade failed: DB: PDOException: SQLSTATE[HY000]: General error: 1005 Can’t create table skriftserien_stage
.submission_file_revisions
(errno: 150 “Foreign key constraint is incorrectly formed”) in /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘alter table su...', Array) #3 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('alter table
su…’, Array, Object(Closure))
#4 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run(‘alter table su...', Array, Object(Closure)) #5 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement('alter table
su…’)
#6 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(549): Illuminate\Database\Schema\Builder->table(‘submission_file…’, Object(Closure))
#9 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(137): PKPv3_3_0UpgradeMigration->_migrateSubmissionFiles()
#10 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#11 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)
#12 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#13 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#14 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#15 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/tools/upgrade.php(22): UpgradeTool->execute()
#16 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1005 Can’t create table skriftserien_stage
.submission_file_revisions
(errno: 150 “Foreign key constraint is incorrectly formed”) in /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘alter table su...', Array) #3 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('alter table
su…’, Array, Object(Closure))
#4 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run(‘alter table su...', Array, Object(Closure)) #5 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement('alter table
su…’)
#6 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(549): Illuminate\Database\Schema\Builder->table(‘submission_file…’, Object(Closure))
#9 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(137): PKPv3_3_0UpgradeMigration->_migrateSubmissionFiles()
#10 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#11 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)
#12 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#13 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#14 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#15 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/tools/upgrade.php(22): UpgradeTool->execute()
#16 {main}
Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1005 Can’t create table skriftserien_stage
.submission_file_revisions
(errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table submission_file_revisions
add constraint submission_file_revisions_submission_file_id_foreign
foreign key (submission_file_id
) references submission_files
(submission_file_id
)) in /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘alter table su...', Array, Object(Closure)) #1 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run('alter table
su…’, Array, Object(Closure))
#2 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement(‘alter table `su…’)
#3 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(549): Illuminate\Database\Schema\Builder->table(‘submission_file…’, Object(Closure))
#6 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(137): PKPv3_3_0UpgradeMigration->_migrateSubmissionFiles()
#7 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#8 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)
#9 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#10 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#11 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#12 /var/www/vhosts/skriftserien-stage.oslomet.no-ojs-3.3.0-3/tools/upgrade.php(22): UpgradeTool->execute()
#13 {main}