Issue when upgrading OJS

Hey all,

I’ve been trying to upgrade a site from OJS 3.2.1-2 → 3.3.0-7 and have been met with the same error a few times now.

error-line

I’ve created the site a few times from fresh on a new AWS instance, and have re-imported the database each time I’ve ran the upgrade process.

I’m really not sure what to do now. Thanks for any help.

We’ve had a further delve into the issue to no avail. We thought it might be something, as the the message suggests, to do with a DB issue relating to a duplicate entry within the plugin_settings table.

After having investigated, we aren’t able to find anything related to ‘blockTitle’ within the plugin_settings table.

The below screenshot is what was returned when searching for anything matching ‘plugin_name = accessibility’

accessibility error

And this is what was returned when searching for anything matching “plugin_name = accessibility AND context_id = 30”

accessibility_contextId_30

Thank you and kind regards,
Brody

Hi @brody, the blockTitle property is something new that’s generated during the upgrade to 3.3. The system tries to automatically create this property from the block content. You can see the code that does that here:

I suspect that you may have two blocks with the same name and the same content in the same journal, and that’s causing the issue when upgrading. You may be able to work around this by identifying those rows in the database, then modifying the corresponding blocks before you upgrade.

Hi @NateWr,

I had a look through the relevant table and found a few instances of duplicate block titles. Editing them has since (I think) solved the issue as the upgrade process ran and finished correctly.

Many thanks!

1 Like

This topic was automatically closed after 10 days. New replies are no longer allowed.