I am receiving the same error on one of my Harvester sites when browsing to index.php/admin/updateIndex/5:
DB Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
I've tried to resolve this error by applying the fix as per viewtopic.php?f=2&t=333
, but receive a MySQL error for only one of the tables:
SQL query: ALTER TABLE search_keyword_list CONVERT TO CHARACTER SET 'utf8';
MySQL said: #1062 - Duplicate entry 'manner' for key 2
Would it be safe to delete all duplicate keyword_text entries from the table until the SQL query executes successfully? Should I run this query on all new OHS deployments to prevent this problem from occurring?
OHS version 220.127.116.11 used.