Describe the issue or problem
Hi, I am trying to upgrade the OJS version from 3.1.2 to 3.2.1. However, I have encountered some issues and I have already searched for this issue but there is no solution.
From error_log
[04-Jun-2023 08:21:41 Asia/Kuala_Lumpur] PKP-Database-Logger 1685838091.2817:
(mysqli): SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = ‘VIEW’ THEN ‘V’ ELSE ‘T’ END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema()
[04-Jun-2023 08:21:41 Asia/Kuala_Lumpur] PKP-Database-Logger 1685838091.2817:
(mysqli): INSERT INTO user_settings (user_id, locale, setting_name, setting_value, setting_type) SELECT DISTINCT u.user_id, s.primary_locale, ‘givenName’, u.first_name, ‘string’ FROM users_tmp u, site s
[04-Jun-2023 08:21:41 Asia/Kuala_Lumpur] PKP-Database-Logger 1685838091.2817: Query: INSERT INTO user_settings (user_id, locale, setting_name, setting_value, setting_type) SELECT DISTINCT u.user_id, s.primary_locale, ‘givenName’, u.first_name, ‘string’ FROM users_tmp u, site s failed. Duplicate entry ‘205-en_US-givenName-0-0’ for key ‘user_settings.user_settings_pkey’
[04-Jun-2023 08:21:41 Asia/Kuala_Lumpur] PKP-Database-Logger 1685838091.2817: 1062: Duplicate entry ‘205-en_US-givenName-0-0’ for key ‘user_settings.user_settings_pkey’
From debug ON
ADOConnection._Execute(SHOW INDEXES FROM email_templates_settings, false) % line 1241, file: [adodb.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php) ADOConnection.Execute(SHOW INDEXES FROM email_templates_settings) % line 348, file: [adodb-mysqli.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php) ADODB_mysqli.MetaIndexes(email_templates_settings, false, false) % line 217, file: [adodb-datadict.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-datadict.inc.php) ADODB_DataDict.MetaIndexes(email_templates_settings) % line 484, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php) dbTable.create(Object:adoSchema) % line 349, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php)
ADOConnection._Execute(SHOW COLUMNS FROM email_templates_settings, false) % line 1241, file: [adodb.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php) ADOConnection.Execute(SHOW COLUMNS FROM email_templates_settings) % line 632, file: [adodb-mysqli.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php) ADODB_mysqli.MetaColumns(email_templates_settings, true, false) % line 205, file: [adodb-datadict.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-datadict.inc.php) ADODB_DataDict.MetaColumns(email_templates_settings) % line 496, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php) dbTable.create(Object:adoSchema) % line 349, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php)
ADOConnection._Execute(SHOW INDEXES FROM publication_settings, false) % line 1241, file: [adodb.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php) ADOConnection.Execute(SHOW INDEXES FROM publication_settings) % line 348, file: [adodb-mysqli.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php) ADODB_mysqli.MetaIndexes(publication_settings, false, false) % line 217, file: [adodb-datadict.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-datadict.inc.php) ADODB_DataDict.MetaIndexes(publication_settings) % line 484, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php) dbTable.create(Object:adoSchema) % line 349, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php)
ADOConnection._Execute(SHOW COLUMNS FROM publication_settings, false) % line 1241, file: [adodb.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php) ADOConnection.Execute(SHOW COLUMNS FROM publication_settings) % line 632, file: [adodb-mysqli.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php) ADODB_mysqli.MetaColumns(publication_settings, true, false) % line 205, file: [adodb-datadict.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-datadict.inc.php) ADODB_DataDict.MetaColumns(publication_settings) % line 496, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php) dbTable.create(Object:adoSchema) % line 349, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php)
ADOConnection._Execute(SHOW INDEXES FROM categories, false) % line 1241, file: [adodb.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php) ADOConnection.Execute(SHOW INDEXES FROM categories) % line 348, file: [adodb-mysqli.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php) ADODB_mysqli.MetaIndexes(categories, false, false) % line 217, file: [adodb-datadict.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-datadict.inc.php) ADODB_DataDict.MetaIndexes(categories) % line 484, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php) dbTable.create(Object:adoSchema) % line 349, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php)
ADOConnection._Execute(SHOW COLUMNS FROM categories, false) % line 1241, file: [adodb.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php) ADOConnection.Execute(SHOW COLUMNS FROM categories) % line 632, file: [adodb-mysqli.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php) ADODB_mysqli.MetaColumns(categories, true, false) % line 205, file: [adodb-datadict.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-datadict.inc.php) ADODB_DataDict.MetaColumns(categories) % line 496, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php) dbTable.create(Object:adoSchema) % line 349, file: [adodb-xmlschema.inc.php](file://home/gadingss/staging.gadingssuitm.com/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php)
ADOConnection._Execute(SHOW INDEXES FROM category_sett
