By Jboo on

Hi,

I've been reading the book page at http://drupal.org/node/571470 regarding fixing illegla mix of collations problems. However, I'm a bit unsure of what I need to change exactly for the errors I'm getting.

I get the following errors regarding the xmlsitemap module:

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/m/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 283.

Could anyone point out exactly what I need to do?

Thanks for any help.

⋅ Categories: Drupal 6.x

Comments

vincent sg’s picture

vincent sg commented

Put your site to offline mode first. Then, backup your site (especially your database) completely before continuing.

Change your collations to utf8_general_ci.

See node 298820. The discussion is good.
http://drupal.org/node/298820

Jboo’s picture

Jboo commented

Thanks Vincent, I'll take a read through that.

My new EasySnoozing, Nursing and BusinessEgghead websites on D7!