Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘index-6-blockTitle’ for key ‘plugin_settings_pkey’

Hi @acahya .
Happy that it worked for you.

Yes, if you delete the settings for CustomBlockManager Plugin in the plugin_settings table
your custom blocks get lost.

To avoid it, you should edit the serialized content of the setting_value field.
But working on serialized content is very complicated.

So, the easiest, cleanest and quickest should be the following:

  • before you proceed with the upgrade make a copy of title and HTML content of any custom block used on your journal
  • remove the custom blocks form the journal’s pages (Should be in “Web site > Settings > Appearance”)
  • delete the custom blocks in the Custom Block plugin’s configuration.
  • execute the above query (SELECT * FROM plugin_settings WHERE plugin_name = “customblockmanagerplugin” and setting_name = “blocks”) and remove the resulting records (if any)

Then you can proceed with the OJS upgrade.

After upgrade is complete, re-create the content blocks using titles and HTML saved before and add the blocks to your journal’s pages.

Hope this helps.