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 [~]#
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
[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