Hi! I am trying to upgrade OJS 2.4.8.1 to OJS 3.1.1.4 but I get the following error:
[root@########## ojs311]# php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.1.1.4]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml (skipped)]
[code: Installer Installer::removeReviewEntries]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptTimedViews.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_adaptReferrals.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptBooksForReview.xml]
[data: dbscripts/xml/upgrade/remove_timed_views_bots.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_preupdate_commentsToEditor.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_notes.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_payments.xml]
[data: dbscripts/xml/upgrade/3.1.1_preupdate_citations.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: lib/pkp/xml/schema/navigationMenus.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[code: Installer Installer::installDefaultNavigationMenus]
[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
[code: Installer Installer::migrateSRLocale]
[code: Installer Installer::migrateNOLocale]
[code: Installer Installer::concatenateIntoAbout]
[code: Installer Installer::concatenateIntoMasthead]
[code: Installer Installer::migrateCounterPluginUsageStatistics (skipped)]
[code: Installer Installer::migrateTimedViewsUsageStatistics (skipped)]
[code: Installer Installer::migrateDefaultUsageStatistics (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration2.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postCounterMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postTimedViewsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type.xml]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_settings.xml]
[code: Installer Installer::installDefaultGenres]
[code: Installer Installer::migrateArticleMetadata]
PHP Warning: Cannot use a scalar value as an array in /ojs/ojs311/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Warning: Cannot use a scalar value as an array in /ojs/ojs311/lib/pkp/classes/db/SettingsDAO.inc.php on line 35
[data: dbscripts/xml/upgrade/3.0.0_update.xml]
[code: Installer Installer::clearDataCache]
[code: Installer Installer::migrateUserRoles]
PHP Warning: Cannot use a scalar value as an array in /ojs/ojs311/lib/pkp/classes/core/DataObject.inc.php on line 133
[code: Installer Installer::fixReviewForms]
[code: Installer Installer::htmlifyEmailTemplates]
PHP Warning: Cannot use a scalar value as an array in /ojs/ojs311/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Warning: Cannot use a scalar value as an array in /ojs/ojs311/lib/pkp/classes/db/SettingsDAO.inc.php on line 35
[note: docs/release-notes/README-BEACON]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[data: dbscripts/xml/upgrade/3.0.0_scheduledTasks.xml]
[code: Installer Installer::localizeCustomBlockSettings]
[code: Installer Installer::convertEditorDecisionNotes]
[code: Installer Installer::convertQueries]
[code: Installer Installer::migrateFiles]
WARNING: Unable to find a match for “1-3-1-SM.pdf” in “/ojs/datos/journals/1//articles/1/”. Skipping this file.
WARNING: Unable to find a match for “1-5-1-RV.pdf” in “/ojs/datos/journals/1//articles/1/”. Skipping this file.
WARNING: Unable to find a match for “1-19-1-CE.pdf” in “/ojs/datos/journals/1//articles/1/”. Skipping this file.
WARNING: Unable to find a match for “5046-24040-2-ED.doc” in “/ojs/datos/journals/1//articles/5046/”. Skipping this file.
WARNING: Unable to find a match for “6933-24966-1-SP.docx” in “/ojs/datos/journals/1//articles/6933/”. Skipping this file.
WARNING: Unable to find a match for “6933-24967-1-SP.docx” in “/ojs/datos/journals/1//articles/6933/”. Skipping this file.
WARNING: Unable to find a match for “6933-24968-1-SP.docx” in “/ojs/datos/journals/1//articles/6933/”. Skipping this file.
WARNING: Unable to find a match for “9-1308-1-SM.pdf” in “/ojs/datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-1309-2-RV.pdf” in “/ojs/datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-1309-1-RV.pdf” in “/ojs/datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-5451-1-ED.pdf” in “/ojs/datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-1310-1-CE.pdf” in “/ojs/datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-5452-1-LE.pdf” in “/ojs/datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “200-634-1-SM.pdf” in “/ojs/datos/journals/2//articles/200/”. Skipping this file.
WARNING: Unable to find a match for “200-635-1-RV.pdf” in “/ojs/datos/journals/2//articles/200/”. Skipping this file.
WARNING: Unable to find a match for “2802-9909-1-CE.pdf” in “/ojs/datos/journals/5//articles/2802/”. Skipping this file.
WARNING: Unable to find a match for “2802-9908-1-SM.pdf” in “/ojs/datos/journals/5//articles/2802/”. Skipping this file.
WARNING: Unable to find a match for “6764-24155-2-PB.pdf” in “/ojs/datos/journals/5//articles/6764/”. Skipping this file.
WARNING: Unable to find a match for “6000-24946-1-PB.pdf” in “/ojs/datos/journals/4//articles/6000/”. Skipping this file.
WARNING: Unable to find a match for “6311-24944-1-PB.pdf” in “/ojs/datos/journals/4//articles/6311/”. Skipping this file.
WARNING: Unable to find a match for “6612-24945-1-PB.pdf” in “/ojs/datos/journals/4//articles/6612/”. Skipping this file.
WARNING: Unable to find a match for “6818-24939-1-PB.pdf” in “/ojs/datos/journals/4//articles/6818/”. Skipping this file.
WARNING: Unable to find a match for “6760-24148-2-SP.xlsx” in “/ojs/datos/journals/7//articles/6760/”. Skipping this file.
[code: Installer Installer::convertSupplementaryFiles]
PHP Warning: copy(/ojs/datos/journals/7//articles/6760/attachment/6760-73-24148-2-13-20180517.xlsx): failed to open stream: No existe el fichero o el directorio in /ojs/ojs311/lib/pkp/classes/file/FileManager.inc.php on line 159
PHP Warning: assert(): Assertion failed in /ojs/ojs311/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php on line 123
PHP Warning: copy(/ojs/datos/journals/1//articles/6933/attachment/6933-1-24966-1-13-20180625.docx): failed to open stream: No existe el fichero o el directorio in /ojs/ojs311/lib/pkp/classes/file/FileManager.inc.php on line 159
PHP Warning: assert(): Assertion failed in /ojs/ojs311/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php on line 123
PHP Warning: copy(/ojs/datos/journals/1//articles/6933/attachment/6933-1-24967-1-13-20180625.docx): failed to open stream: No existe el fichero o el directorio in /ojs/ojs311/lib/pkp/classes/file/FileManager.inc.php on line 159
PHP Warning: assert(): Assertion failed in /ojs/ojs311/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php on line 123
PHP Warning: copy(/ojs/datos/journals/1//articles/6933/attachment/6933-1-24968-1-13-20180625.docx): failed to open stream: No existe el fichero o el directorio in /ojs/ojs311/lib/pkp/classes/file/FileManager.inc.php on line 159
PHP Warning: assert(): Assertion failed in /ojs/ojs311/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php on line 123
[code: Installer Installer::provideSupplementaryFilesForReview]
[code: Installer Installer::setFileUploader]
[code: Installer Installer::setFileName]
[data: dbscripts/xml/upgrade/3.0.0_postupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_pubId_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_galley_files.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_issue_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_submission_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_review_method.xml]
[data: dbscripts/xml/upgrade/3.0.0_edit_decisions.xml]
[code: Installer Installer::convertCommentsToEditor]
[note: docs/release-notes/README-3.0]
[note: docs/release-notes/README-3.0.1]
[data: dbscripts/xml/upgrade/3.0.2_update.xml]
[note: docs/release-notes/README-3.0.2]
[code: Installer Installer::moveReviewerFiles]
ERROR: Reviewer files with ID 6357 from review assignment 222 could not be found in the database table submission_files
ERROR: Reviewer files with ID 6633 from review assignment 240 could not be found in the database table submission_files
ERROR: Reviewer files with ID 8393 from review assignment 671 could not be found in the database table submission_files
ERROR: Reviewer files with ID 13489 from review assignment 1769 could not be found in the database table submission_files
ERROR: Reviewer files with ID 18256 from review assignment 2749 could not be found in the database table submission_files
ERROR: Reviewer files with ID 22120 from review assignment 3616 could not be found in the database table submission_files
ERROR: Reviewer files with ID 20793 from review assignment 3646 could not be found in the database table submission_files
ERROR: Reviewer files with ID 22899 from review assignment 4184 could not be found in the database table submission_files
[code: Installer Installer::fixAuthorGroup]
[data: dbscripts/xml/upgrade/3.0.0_reviewer_files.xml]
ERROR: Upgrade failed: DB: Column ‘review_round_id’ cannot be null
Hi @jose.galeano,
There are some suggestions in this topic: Error Upgrade 2.4.8.2 to 3.1.0 - #16 by Adriano_Jose
Best,
Amanda Stevens
Public Knowledge Project Team