A database error has occurred: while upgrading from 3.3.0.13 to 3.4.0.4

Software Support
1

Errors occurred during installation:

  • A database error has occurred: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ (SQL: select p.submission_id, p.publication_id, ps.setting_value from publications as p inner join publication_settings as ps on ps.publication_id = p.publication_id left join issues as i on CAST(i.issue_id AS CHAR(20)) = ps.setting_value where ps.setting_name = issueId and i.issue_id is null)

Kindly let me know how to rectify this error?

Thank you in advance.
C. Srinivasan
xlescience.org