Hello,
We have to update from OJS 2.4.4.1 to OJS 2.4.7.0.
The problem is that the database is reporting to be versión 2.3.4.0 (We have updated from that versión to 2.4.4.1 long time ago).
Apparently the 2.4.4.1 is working with an inconsistent database.
When checking versions with “php tools/upgrade.php check” command the result is:
Code version: 2.4.4.1
Database version: 2.3.4.0
Latest version: 2.4.7.0
Database version is older than code version
Run “tools/upgrade.php upgrade” to update
And when we run that the reult is:
admin@aaot.org.ar [~/subdomains/ojs/ojsr]# php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 2.4.4.1]
[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]
[data: dbscripts/xml/upgrade/2.3.5_update.xml]
[note: docs/release-notes/README-2.3.5]
[note: docs/release-notes/README-2.3.6]
[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: Table ‘aaot_org_ar_ojs.article_event_log’ doesn’t exist
Is there any way this can be solved without restoring the database from the a backup prior to the previous version update?.
It is possible to manually adjust the current database structure to make it consistent to version 2.4.4.1 so we can then update to OJS ver 2.4.7.0?
Can you point us to someone who has the necesary skills to do this?
We do not want to lose almost two years of information updates to the database.
Thanks in advance,
Manrique