OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Update 2.2.0 to 2.4.2 database problem

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Update 2.2.0 to 2.4.2 database problem

Postby franciscogarrido » Mon Oct 14, 2013 11:12 am

Dear
When I try to update the database from version 2.2.0 to version 2.4.2 I get the following error.


[pre-install]
[load: upgrade.xml]
[version: 2.4.2.0]
[data: dbscripts/xml/upgrade/2.3.0_usersettings.xml]
[schema: lib/pkp/xml/schema/signoff.xml]
[data: dbscripts/xml/upgrade/2.3.0_preupdate.xml]
[data: dbscripts/xml/upgrade/2.3.0_subscription_ip.xml]
[data: dbscripts/xml/upgrade/2.3.3_preupdate1.xml]
[data: dbscripts/xml/upgrade/2.3.3_preupdate2.xml]
[data: dbscripts/xml/upgrade/2.3.3_preupdate3.xml]
[data: dbscripts/xml/upgrade/2.3.3_preaffiliations1.xml]
[data: dbscripts/xml/upgrade/2.3.3_preaffiliations2.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_article_files.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_emaillog.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_reviewrounds.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issues.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_articles.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issue_galleys.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files.xml]
[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: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[data: dbscripts/xml/upgrade/2.2.3_update.xml]
[note: docs/release-notes/README-2.2.3]
[code: Installer Installer::separateSubscriptions]
[data: dbscripts/xml/upgrade/2.3.0_update.xml]
[code: Installer Installer::localizeMoreJournalSettings]
[code: Installer Installer::cleanImageAlts]
[code: Installer Installer::cleanTitles]
[note: docs/release-notes/README-2.3.0]
[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]
[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.3.0_subscription_ip2.xml]
[note: docs/release-notes/README-2.3.1]
[note: docs/release-notes/README-2.3.2]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::migrateReviewingInterests]
<h1>DB Error: Duplicate entry 'interest-4096-10932' for key 2</h1>ojs2: DB Error: Duplicate entry 'interest-4096-10932' for key 2


Help!!!!!!!!!!
franciscogarrido
 
Posts: 53
Joined: Fri May 11, 2012 12:05 pm

Re: Update 2.2.0 to 2.4.2 database problem

Postby asmecher » Tue Oct 15, 2013 9:43 am

Hi franciscogarrido,

Please see e.g. http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9401. This looks like a data error; that post should help guide you through it.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 1 guest