Hello,
I’m trying update OJS database through CLI, but only Code Version have been updated.
When I run a command for check, the output is:
php tools/upgrade.php check
Code version: 2.4.6.0
Database version: 2.3.6.0
Latest version: 2.4.6.0
Database version is older than code version
Run “tools/upgrade.php upgrade” to update
When I run command for upgrade, the results are:
php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 2.4.6.0]
[schema: lib/pkp/xml/schema/signoff.xml]
[data: dbscripts/xml/upgrade/2.4.3_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.3_preupdate_usageStatistics2.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_article_files.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_emaillog.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_reviewrounds.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issues.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_articles.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issue_galleys.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_notifications.xml (skipped)]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/groups.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/comments.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/gifts.xml]
[schema: lib/pkp/xml/schema/mutex.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[code: Installer Installer::migrateReviewingInterests2]
[data: dbscripts/xml/upgrade/2.3.7_update.xml]
[code: Installer Installer::removeAuthorRevisedFilesFromSignoffs]
[note: docs/release-notes/README-2.3.7]
[code: Installer Installer::installEmailTemplate]
[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/2.4.0_idupgrade_article_galleys2.xml (skipped)]
[data: lib/pkp/xml/mutexData.xml]
[data: dbscripts/xml/upgrade/2.4.0_update.xml]
ERROR: Upgrade failed: DB: Duplicate entry ‘199-old_log_id’ for key ‘event_log_settings_pkey’
I tried updating by Web, but the same error is also displayed.
Regards,
Leandro