Failed to upgrade from OJS 3.3.0-15 to OJS 3.4.0-3

Describe the issue or problem
I have tried to upgrade our OJS to the latest version. Unfortunately, the upgrade process has been skipped at the step of MergeLocalesMigration.

What application are you using?
For example, OJS 3.4.0-3 with PHP 8.0

Additional information
I figured out that the problem caused due to some errors in plugin_setting table in the database as shown in pics below. Hence, I got no errors on the error log file so I can trace the issue
Is there any way to overcome this issue? I tried to look through the posts in the forum but I didn’t any thing.
Thank you in advance for your help.
Kind regards,

1fc7155bc0b1f27381f71a1fc669054416bb6fff_2_690x382
1996fcef1b547f08efcc2884899e9eca56e212a9_2_690x345
a0381bdb6ff7f34f7ab3c05089a5a10145be86af_2_690x325

Dear @Salam_Al-Khammasi,

Just for testing purposes, disable the locale(s), leaving the journal only on en_US and run the upgrade again (don’t forget to make a backup of files and database, also drop all tables from the database and import the previous working one, before the upgrade error). If it works you can then re-enable the translations.

Best,
Josh

@jnoronha
I really appreciate your reply. I will test what you suggested in your comment and let you know what is going to happen. I have tried to delete all the incompatible plugins from files and plugin_setting table in the database but it didn’t work.
Regards,
-Salam

Hi @jnoronha
I disabled Arabic locale from OJS and left with only English and got the same error above.
The website displays the error below after upgrade failed.
Fatal error: Uncaught Exception: Invalid product name "academic_free" in /public_html/test/lib/pkp/classes/plugins/PluginRegistry.php:186 Stack trace: #0 //public_html/test/lib/pkp/classes/plugins/PluginRegistry.php(219): PKP\plugins\PluginRegistry::_instantiatePlugin('themes', 'academic_free', 'AcademicFreeThe...') #1 //public_html/test/lib/pkp/classes/plugins/PluginRegistry.php(112): PKP\plugins\PluginRegistry::_loadFromDatabase('themes', NULL) #2 //public_html/test/lib/pkp/classes/template/PKPTemplateManager.php(1392): PKP\plugins\PluginRegistry::loadCategory('themes', true) #3 //public_html/test/lib/pkp/classes/plugins/Plugin.php(403): PKP\template\PKPTemplateManager::getManager(Object(APP\core\Request)) #4 //public_html/test/lib/pkp/classes/plugins/Plugin.php(137): PKP\plugins\Plugin->_registerTemplateResource() #5 //public_html/test/lib/pkp/classes/plugins/LazyLoadPlugin.php(34): PKP\plugins\Plugin->register('generic', 'plugins/generic...', NULL) #6 /public_html/test/plugins/generic/htmlArticleGalley/HtmlArticleGalleyPlugin.php(36): PKP\plugins\LazyLoadPlugin->register('generic', 'plugins/generic...', NULL) #7 //public_html/test/lib/pkp/classes/plugins/PluginRegistry.php(76): APP\plugins\generic\htmlArticleGalley\HtmlArticleGalleyPlugin->register('generic', 'plugins/generic...', NULL) #8 //public_html/test/lib/pkp/classes/plugins/PluginRegistry.php(121): PKP\plugins\PluginRegistry::register('generic', Object(APP\plugins\generic\htmlArticleGalley\HtmlArticleGalleyPlugin), 'plugins/generic...', NULL) #9 [internal function]: PKP\plugins\PluginRegistry::PKP\plugins\{closure}(Object(APP\plugins\generic\htmlArticleGalley\HtmlArticleGalleyPlugin), 'plugins/generic...') #10 /public_html/test/lib/pkp/classes/plugins/PluginRegistry.php(121): array_walk_recursive(Array, Object(Closure)) #11 /public_html/test/lib/pkp/classes/core/Dispatcher.php(155): PKP\plugins\PluginRegistry::loadCategory('generic', true) #12 /public_html/test/lib/pkp/classes/core/PKPApplication.php(387): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #13 /public_html/test/index.php(21): PKP\core\PKPApplication->execute() #14 {main} thrown in //public_html/test/lib/pkp/classes/plugins/PluginRegistry.php on line 186

Hi @Salam_Al-Khammasi

The information in the error log indicates that the previous theme files are not compatible with the version of OJS you are currently using. As our customer satisfaction is our commitment to provide them with priority support and satisfaction, we would be glad to provide you with the updated product. Please contact us via email at support@openjournaltheme.com so we would inform you on how to get the latest version.

Best regards
Ghazi
OJT Team

Thanks for your suggestion @goodzy.
I tried to delete the theme from the files and the database but the upgrade still fail at the same stage. I will try to delete all the incompatible plugins in the plugin_setting and versions tables and try upgrading again. Lets see what is going to happen.
Regards,
-Salam

Hi @jnoronha
I hope you are doing fine
Before I upgrade I did these steps
1- Disabled the locales and left the site with English.
2- deleted all the incompatible plugins from files and DB ( Plugin_setting and version tables )
3- increased the memory size from 2048M to 4355443M
4- Then I did the upgrade
I got the error message below. Any advices will be appreciated

Kind regards,
-Salam

Dear @Salam_Al-Khammasi,

You need to “tell” OJS that it can use the memory, try to run the upgrade with “php -d memory_limit=2048M upgrade.php upgrade”.

Best regards,
Josh

Thanks a lot @jnoronha for your time and effort. You solved the problem for me and the OJS successfully upgraded to ojs 3.4.0-3
Kind regards
-Salam