OJS 2.3.7 to 2.4.8 migration problems

Hello PKP Community,

I am having problem in migrating OJS 2.3.7 to 2.4.8. I migrated my old postgres database (the schema where is my OJS data) to MySQL. The process was succesful. Once migrated my database, I tried to migrate from OJS 2.3 to 2.4, the main goal is migrate to OJS 3.1, however as says UPGRADE file it is necessary first migrated to intermediate version. At middle of upgrading showed up the following error:

Errors occurred during installation:

  • A database error has occurred: Duplicate entry 'sanchez ’ for key ‘article_search_keyword_text’

Both database and config.ini.php have charset = utf-8.

I did the following query and I obtained next:


The problem seems to be that OJS upgrade does not consider accents.

How I could to resolve this problem?

thanks so much

Hi @Juan_Pablo_Giron_Rui

You may clear this field contents as instructions from this thread with a similiar issue to yours: