Dear All,
I’ve received an error message while updating the database:
A database error has occurred: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8mb4_general_ci,COERCIBLE), (utf8mb4_general_ci,COERCIBLE) for operation ‘replace’
Am using the same charset utf-8 for both versions.
Please help
Hi @arunabraham,
What are your specific character set configurations in config.inc.php
for both the OJS 2.x and 3.x installations?
Regards,
Alec Smecher
Public Knowledge Project Team
latin1_swedish_ci
Am using the same charset utf-8 for both versions.
Hi @arunabraham,
Can you include the specific settings for client_charset
, connection_charset
, and database_charset
? Where are you specifying latin1_swedish_ci
?
Regards,
Alec Smecher
Public Knowledge Project Team
Dear,
client_charset = utf-8
connection_charset = Off
during the time of database creation I select latin1_swedish_ci
Dear ,
I manually change collation of all tables and columns to utf8_general_ci, after performing the updation the following error occurs
A database error has occurred: Duplicate entry ‘one–’ for key ‘submission_search_keyword_text’
anyone, please help me to finish it am still facing this issue
Hi @arunabraham,
If the only remaining issue is the search index, see this post for instructions on regenerating the search index: OJS 3.1.2.1 - 3.1.2.4 - Upgrade failed due to corrupt 'submission search object keywords' table - #2 by jnugent
Regards,
Alec Smecher
Public Knowledge Project Team
Dear,
It’s not working, still showing the follwing error
A database error has occurred: Duplicate entry ‘one–’ for key ‘submission_search_keyword_text’
Hi @arunabraham,
Can you describe the process you’re following, incorporating the suggestion I made above?
Regards,
Alec Smecher
Public Knowledge Project Team