Upgrade failed: DB: Incorrect table definition; there can be only one auto column and it must be defined as a key

Software Support
1

I am trying to upgrade from 3.1.1.4 to 3.1.2-1 and getting the following error.

jott@threatenedtaxa.org [~]# php public_html/tools/upgrade.php upgrade

[pre-install]

[load: upgrade.xml]

[version: 3.1.2.1]

[code: Installer Installer::checkPhpVersion]

[data: dbscripts/xml/upgrade/3.1.2_preupdate_user_author_names.xml]

[schema: lib/pkp/xml/schema/common.xml]

[schema: lib/pkp/xml/schema/log.xml]

ERROR: Upgrade failed: DB: Incorrect table definition; there can be only one auto column and it must be defined as a key

jott@threatenedtaxa.org [~]#

2

Please someone help me.

3

Hi @latha_ojs,

Have you made any manual changes to your database, specifically the event_log, event_log_settings, email_log, or email_log_users tables?

Could you try restoring your database from backup, turning on the show_stacktrace and debug options in config.inc.php, and running the upgrade again? This should generate more information that can help in debugging.

Regards,
Alec Smecher
Public Knowledge Project Team

4

[02-Apr-2020 03:35:56 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/------/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[02-Apr-2020 03:35:56 UTC] Incorrect table definition; there can be only one auto column and it must be defined as a key