OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



OCS 2.1.1.2 => 2.3.0.0 DB upgrade fail

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

Moderators: jmacgreg, michael, John

Forum rules
What to do if you have a technical problem with OCS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

OCS 2.1.1.2 => 2.3.0.0 DB upgrade fail

Postby JohnGrobler » Thu Apr 15, 2010 3:31 am

Good day,

I am trying to perform a Full Package upgrade from OCS 2.1.1.2 to OCS 2.3.0.0 and receive the following error when trying to perform the DB upgrade from either the web interface or CLI:

ERROR: Upgrade failed: DB: Duplicate entry 'REVIEW_ACK-0-1' for key 2

Hosting environment:
Apache 2.2.3
PHP 5.2.0-8
MySQL 5.0.51a

Can this problem be related to another issue experienced on this OCS site, logged here: viewtopic.php?f=3&t=5980

Thank you,
John Grobler
JohnGrobler
 
Posts: 51
Joined: Mon Dec 07, 2009 1:41 pm

Re: OCS 2.1.1.2 => 2.3.0.0 DB upgrade fail

Postby mcrider » Tue Apr 20, 2010 11:49 am

Hi John,

This is likely caused by an upgrade on an already failed upgrade (thus on a fractured database). Please try restoring from backup to a stable state, then trying to upgrade again.

Cheers,
Matt
mcrider
 
Posts: 952
Joined: Mon May 05, 2008 10:29 am
Location: Vancouver, BC


Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 4 guests