I see this is being discussed in another thread but I don't want to hijack that one with my question.
I also had this error (the first in all upgrades from 3.6.8)
I went in and altered a couple of the collations from latin1_swedish_ci to latin1_general_ci
Upgrade proceeded without a problem.
I do notice the the DB contains a mixture throughout. Is there a reason why the error only occurred for this upgrade ?
Should the DB contain the same collation throughout ?
I also had this error (the first in all upgrades from 3.6.8)
Code:
Database error in vBulletin 3.7.3: Invalid SQL: SELECT forumprefixset.* FROM forumprefixset AS forumprefixset INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid) ORDER BY prefixset.displayorder; MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' Error Number : 1267
Upgrade proceeded without a problem.
I do notice the the DB contains a mixture throughout. Is there a reason why the error only occurred for this upgrade ?
Should the DB contain the same collation throughout ?
Comment