Once upon a time we upgraded from OJS 2 to OJS 3 and faced some problems due to character encoding originating a “Failed AJAX request or invalid JSON returned” error. I was able to solve the problem for the es_ES locale thanks to @asmecher 's tips
Now … after upgrading from 220.127.116.11 to 18.104.22.168 the es_ES locale is still working OK, but if I add any other locale (tested with pt_BR, it_IT, fr_FR) I cannot access the email templates. So I started working on FIXING the problem instead of PATCHING it…
To make the story short
- I changed “connection_charset” from Off to utf-8 and the whole site showed ‘code’ instead of special characters (ex: Ã© instead of é)
- I dumped each table of the OJS database to a separated .sql file
- I replaced all corresponding characters in the relevant .sql files (ex: sed -i ‘s/Ã©/é/g’ author_settings.sql)
- I reimported the .sql file to overwrite the previous table with the fixed one
- Profit (almost)
This process has proven to be very successful for these tables:
But when I try to do the same with submission_search_keyword_list.sql and import it, I get an error due to duplicate entries …
So here is the question:
Is there a way to empty the submission_search_keyword_list table and re-populate it from the contents of the database?
Thanks in advance and sorry fo the long post!