Upgrade from 2.3.7.0 to 2.4.8.0 - error - can only be one auto column and must be key

Software Support
1

Attempting to upgrade OJS to 3.3.0. Currently from:2.3.7.0. Working to upgrade in increments starting with 2.4.8.0. On php: 5.4.16 currently with ability to move up to V7.x

Error when upgrading:
[schema: lib/pkp/xml/schema/reviews.xml]
ERROR: Upgrade failed: DB: Incorrect table definition; there can be only one auto column and it must be defined as a key

Any ideas? We really just want to get this in a state where we can export the journal and import into our existing functional 3.3.x instance.

2

Hi @loola,

Have you taken a look at some of the other posts where this error is reported:

https://forum.pkp.sfu.ca/search?q=%22Upgrade%20failed%3A%20DB%3A%20Incorrect%20table%20definition%3B%20there%20can%20be%20only%20one%20auto%20column%20and%20it%20must%20be%20defined%20as%20a%20key%22

-that might be a good starting point.

-Roger
PKP Team