Ive installed the module on other sites/hosting providers and have had no issues. However, I installed it on Drupal 6.14 on Hostgator. They assure me its a script bug in the module. Could you please help troubleshoot this error?

The error below is thrown when editing an existing view. Also, the module doesnt ever really display properly.

Error: (Thrown when editing an existing view)

user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT s.uid, v.updated FROM views_object_cache v INNER JOIN sessions s ON v.sid = s.sid WHERE s.sid != '061d677589904fee75dd0b6f629623d2' and v.name = 'archive' and v.obj = 'view' ORDER BY v.updated ASC in /home/bigdogs1/public_html/sites/all/modules/views/views_ui.module on line 235.
user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT s.uid, v.updated FROM views_object_cache v INNER JOIN sessions s ON v.sid = s.sid WHERE s.sid != '061d677589904fee75dd0b6f629623d2' and v.name = 'archive' and v.obj = 'view' ORDER BY v.updated ASC in /home/bigdogs1/public_html/sites/all/modules/views/views_ui.module on line 235.

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

This means your tables were installed with incompatible collations. This doesn't happen under normal circumstances, generally only if 1) the default collations changed sometime between two tables being installed or 2) if a collation was changed manually.

This isn't a Views problem at all, but a problem with your database that will have to be fixed probably manually.

merlinofchaos’s picture

merlinofchaos commented

http://drupal.org/node/319193 contains further discussion on the topic.

jlane’s picture

jlane commented
Status: Closed (won't fix) » Fixed

The sessions table was in UTF8_Unicode and the views_object_cache were all in UTF8_General. This fixed the error I was seeing. However, the module is still not displaying correctly. Can we upload screen shots to this site?

Status: Fixed » Closed (fixed)

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