I just installed the 6.x-1.x-dev and got the following error upon running update.php:
user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: SELECT COUNT(xsm.loc) FROM xmlsitemap xsm INNER JOIN system s ON s.name = xsm.module WHERE s.type = 'module' AND s.status = 1 AND xsm.changefreq <> 0 AND xsm.changed <> 0 AND (xsm.priority >= 0 AND xsm.priority <= 1) in /home/wwwsite/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 283.
Followed by:

The following queries were executed
xmlsitemap_engines module
Update #6111

The non-dev version is also giving the same issue. This error was supposed to be fixed in the Dev version.

any suggestions?

Comments

Anonymous’s picture

Anonymous (not verified) commented
Version: 6.x-2.x-dev » 6.x-1.x-dev
Category: bug » support
Status: Active » Fixed

Is it 1.x-dev or 2.x-dev?

This is your problem and not xmlsitemap. You have incorrectly set the defaults for the table collation on your database to be utf8_unicode_ci instead of utf8_general_ci. Correct the issue at the database level and your issue will go away.

vako’s picture

vako commented

Thanks, I was using 1.x-dev, upgraded to 2.x-dev. However this time I am getting tons of errors (will open another case).
Also will look into the database collation issue, although haven't changed any collation myself, maybe it's a default of the ISP.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.