Announcement

Collapse
No announcement yet.

SQL errors : Illegal mix of collations for operation 'in'

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL errors : Illegal mix of collations for operation 'in'

    Hi
    Since the migration from V4 to V5 we got a lot of errors like this :

    Database error in vBulletin 5.3.2:

    Invalid SQL:
    SELECT * FROM routenew
    WHERE `prefix` IN ('installation-et-mise-� -jour-/favicon.ico',installation-et-mise-� -jour' ... );

    MySQL Error : Illegal mix of collations for operation 'in'
    Error Number : 1271

    We have tried many settings without success.Could you please tell me how to fix this.
    Thanks
    French Joomla forum : https://forum.joomla.fr
Loading...
Working...
X