Alessandro
Alessandro
Offline
0
Hello,
in backend if in album view I look for "caffè" I get this error, with other search words this does not happen,
in frontend in search music same problem only with this word "caffè"

can you help me?
Thank you

1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

Accepted Answer

Tuesday, March 13 2018, 06:16 PM - #Permalink
0
do you have access to phpMyAdmin?

there you can perform "operations" on the table and change the collation.
The reply is currently minimized Show
Responses (4)
  • Accepted Answer

    Monday, March 12 2018, 02:05 PM - #Permalink
    0
    can you check what is the collation of your DB tables? are all of them utf8_general_ci?
    The reply is currently minimized Show
  • Accepted Answer

    Alessandro
    Alessandro
    Offline
    Monday, March 12 2018, 02:18 PM - #Permalink
    0
    All Acymailing and your component (Music colletctio and Content Statistics) tables are utf8_general_ci
    all other tables are utf8mb4_unicode_ci
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 12 2018, 02:22 PM - #Permalink
    0
    probably that's the problem. can you try changing DB tables to utf8mb4_unicode_ci ?
    The reply is currently minimized Show
  • Accepted Answer

    Alessandro
    Alessandro
    Offline
    Monday, March 12 2018, 02:54 PM - #Permalink
    0
    Please can you suggest me how?
    thank you!
    The reply is currently minimized Show
Your Reply