user warning: Illegal mix of collations error, help?

I get the same error...

Some help?

Coke: Have you used Fantastico to install drupal?

Are you still having this problem because I have been. I disabled the Trigger module as a result but would like to enable again. I am using Drupal 6.2 at this time.

Location reference: http://realdivatv.com/taxonomy/term/31

a:4:{s:6:"%error";s:12:"user warning";s:8:"%message";s:287:"Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
query: SELECT aa.aid, a.type FROM trigger_assignments aa LEFT JOIN actions a ON aa.aid = a.aid WHERE aa.hook = 'nodeapi' AND aa.op = 'view' ORDER BY weight";s:5:"%file";s:55:"/home/divatv/public_html/modules/trigger/trigger.module";s:5:"%line";i:146;}

Any luck with this? I think I have more or less the same issue:

user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta LEFT JOIN i18n_blocks i18n ON b.module = i18n.module AND b.delta = i18n.delta WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( b.theme = 'greenNblack' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) )ORDER BY b.region, b.weight, b.module in /home/***usenamer****/public_html/modules/block/block.module on line 407.

Regards

I'm getting the same error whenever I try to add any content. Any clues how to fix this please???

See here for a discussion and some possible solutions: http://drupal.org/node/140303

- Arie

This comes from triggers it seems. I disabled anything that used triggers and still got it until disabling triggers alltogether.
I'm using drupal 6.10, I think. I'm not sure where I'd see my version from the web site itself.

Im getting these errore when I want to add field in views 2 in drupal v: 6.16 . I searched everywhere but I couldnt find the solution for this. by the I downloaded drupal through fantastico, if its helpful to know.

Could anyone help me with this please?
thanks very much.

* 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 != '9b2fa1af5fd5957551c1e517daf962d0' and v.name = 'people' and v.obj = 'view' ORDER BY v.updated ASC in /home/kamalif/public_html/drupal/sites/default/modules/views/views_ui.module on line 236.

* 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 != '9b2fa1af5fd5957551c1e517daf962d0' and v.name = 'people' and v.obj = 'view' ORDER BY v.updated ASC in /home/......./public_html/drupal/sites/default/modules/views/views_ui.module on line 236.

I'm having a similar issue. PLEASE HELP!!
I have the latest stable release of Drupal. I have run update.php, I have run Cron, yet...

In Panels, when trying to create a Panel Page, each step of the way:

user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT s.uid, c.updated FROM ctools_object_cache c INNER JOIN sessions s ON c.sid = s.sid WHERE s.sid != '5f54b862ad0b26ccc72e2b39941d6612' AND c.obj = 'page_manager_page' AND c.name = 'page-home' ORDER BY c.updated ASC in /home/baba/public_html/sites/all/modules/ctools/includes/object-cache.inc on line 95.

Thanks in advance

Subscribing. I have the same problem, but it's related to pathauto and views. And I also used fantastico to install Drupal 6.

Yeah, I'm getting this too, but it's definitely relevant to triggers. I was suspicious because I just upgraded my drupal core to 6.17. Subscribing...

I've been getting this too with views and triggers.

Drupal 6.19
Access to update.php Protected
ActivityStream Feed: SimplePie Parser Installed correctly
The current installed version of SimplePie is 1.1.1
CTools CSS Cache Exists
Configuration file Protected
Cron maintenance tasks Last run 6 min 21 sec ago
You can run cron manually.
Database updates Up to date
Drupal core update status Up to date
File system Writable (public download method)
GD library bundled (2.0.34 compatible)
GD library bundled (2.0.34 compatible)
Mime type detection File Extension
MimeDetect is using the browser supplied filename for file extension lookups. It is strongly recommended that you install and configure the PHP Fileinfo Extension or the UNIX 'file' command to provide more accurate sever-side mime type detection.
Module and theme update status Out of date
There are updates available for one or more of your modules or themes. To ensure the proper functioning of your site, you should update as soon as possible. See the available updates page for more information.
MySQL database 5.1.48
PHP 5.2.13
PHP memory limit 128M
PHP register globals Disabled
Panels operating in Legacy mode
Panels is operating in Legacy mode due to the following issues:
Panels 3.6 made changes to the rendering order in a way that affects certain style plugins. The above modules implement style plugins, but have not indicated their compatibility with this new system. See http://drupal.org/node/###FIXME for information on how to update style plugins to the new system.
skinr - Style plugins

Unicode library PHP Mbstring Extension
Update notifications Enabled
Upload progress Not enabled
Your server is not capable of displaying file upload progress. File upload progress requires PHP be run with mod_php and not as FastCGI.
Web server Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
getID3() 1.7.9-20090308
jQuery UI 1.6
jQuery Update 1.2.6

I just got the following error after saving a View Page that I just created:

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 != 'e797d32153f0cd94179152bf80876f46' and v.name = 'VakoPhotoGallery' and v.obj = 'view' ORDER BY v.updated ASC in /home/wwwkrik/public_html/sites/all/modules/views/views_ui.module on line 236.

Hi,

I get the same warning refering to /modules/views/views_ui.module on line 236. Any fixes to this bug?

*******************************************************************************************
* 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 != '6ef34c9588e88aa307135d2d7c74a6da' and v.name = 'Medisin' and v.obj = 'view' ORDER BY v.updated ASC in /home/anitwo/public_html/modules/views/views_ui.module on line 236.

* 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 != '6ef34c9588e88aa307135d2d7c74a6da' and v.name = 'Medisin' and v.obj = 'view' ORDER BY v.updated ASC in /home/anitwo/public_html/modules/views/views_ui.module on line 236.
*********************************************************************************************