Upgrade SQLSTATE[23000]

Software Support
1

Hello,

I’m performing the update from version 3.2.1-4 to 3.3.0-14 however during the process I got this error…

ERROR: Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘indexadores-21-blockTitle’ for key ‘plugin_settings.plugin_settings_pkey’ (SQL: insert into plugin_settings (context_id, plugin_name, setting_name, setting_type, setting_value) values
…
…
…
(21, indexers, blockTitle, object, a:1:{s:5:“en_US”;s:11:“indexers”;}),
(21, access map, blockTitle, object, a:1:{s:5:“pt_BR”;s:14:“access map”;}),
(21, indexers, blockTitle, object, a:1:{s:5:“en_US”;s:11:“indexers”;}))

But in the plugin_settings table there is no record.

Are there any procedures to be performed?

2

Hi @pmesquita,

As a first step, you can have a look at some of these posts here that report on a similar issue: Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘index-6-blockTitle’ for key ‘plugin_settings_pkey’ - #4 by jorgelpolanco

However, others with more direct experience with issues like this one may wish to weigh in.

-Roger
PKP Team