By daniel5383 on

I just got this message when I went to go back to home...

user warning: 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 in /home/sar1n/public_html/modules/trigger/trigger.module on line 147.

im stupid so i have no idea what this means lol but it sounds bad

⋅ Categories: Drupal 6.x

Comments

daniel5383’s picture

daniel5383 commented

can anybody help??? i thought this was the place to come for help?

dman’s picture

dman commented

Help only happens for those who are able to help themselves.
Bumping your own topic within hours with a complaint may not always help.

Illegal mix of collations is the sort of place you should be looking. (Short answer - probably a MySQL upgrade or import issue)

.dan. is the New Zealand Drupal Developer working on Government Web Standards

Ildar Samit’s picture

Ildar Samit commented

But try providing more detail, maybe someone knows about the way trigger module works...

selvakumar’s picture

selvakumar commented

You can fix this problem changing the table collations. You are using two table but table coolation are different from one another. So first thing you will change the collation f the tables. May it will fix your error.

daniel5383’s picture

daniel5383 commented

sorry if i came across like that...i did try researching the answer and couldnt find anything...i even went as far as to open up the trigger file in notepad and go to that exact line and see what it was. the thing is, im new to this, i really have no web experience, and came to drupal because it looked like it was a lot easier to run by yourself then hiring someone to maintain a site for you. i ended up disabling the trigger module and the errors went away, so it was obviously something in the trigger module i would think. i just dont know.