OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Upgrade OJS 2.2.3 to 2.3.8 Database error

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.

Upgrade OJS 2.2.3 to 2.3.8 Database error

Postby hamsavijay » Sun Oct 07, 2012 7:46 am

We are upgrading the OJS from 2.2.3 to 2.3.8 using full install. We've unpacked all the folders of 2.3.8 in the ojs installation directory and updated the config.inc.php with the same credentials/settings as the previous version 2.2.3. Then set the installed=off mode to go through php mode and clicked "upgrade open journal system". It came with an error as below:
"A database error has occurred: Incorrect table definition; there can be only one auto column and it must be defined as a key."

Our journal is on a shared server so we have less control of SQL database and other useful tips. I wonder anyone could help us to get through this. I even attempted by restoring the database again.

PHP version 5.3.17
MySQL version 5.1.63-cll

By frustration, I've clicked again the "upgrade open journal system" and it gave me the following error:

"A database error has occurred: Table 'maftree_ijvss.copyed_assignments' doesn't exist".

I've tried searching forum and tried few options. We are struck. Please reply with the tip/trick if you have some solution.

Thanks,
Priya
hamsavijay
 
Posts: 18
Joined: Fri Jul 03, 2009 3:14 pm

Re: Upgrade OJS 2.2.3 to 2.3.8 Database error

Postby hamsavijay » Sun Oct 07, 2012 1:11 pm

I think the DB is corrupted due to few attempts - install, upgrade, upgrade etc. I've deleted the existing database at the OJS installation server and then retrieved the backedup version. After retreiving, i've reassigned the user.

Then, I've done it rightly by clicking "Upgrade" once. It came up with a message "Upgrade successful". The new version seems to group the subscriptions automatically based on provided IP into individual and instituitional subscriptions.

My query is Resolved.

Thanks for the forum.
hamsavijay
 
Posts: 18
Joined: Fri Jul 03, 2009 3:14 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests