Hi,
I just quickly describe my problem. I just started using drupal and felt great about it. However when i add modules to my drupal website, i encountered an error. It says:
PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=': SELECT ta.aid, a.type, a.label FROM {trigger_assignments} ta LEFT JOIN {actions} a ON ta.aid = a.aid WHERE ta.hook = :hook ORDER BY ta.weight; Array ( [:hook] => node_view ) in trigger_get_assigned_actions() (line 170 of /home/zanglin/public_html/modules/trigger/trigger.module)...
and cant loggin into my website again
Plz Help
Lin^-^
| Comment | File | Size | Author |
|---|---|---|---|
| Drupal_Error.png | 144.23 KB | LinZang |
Comments
Comment #1
guidot commentedI don't know for sure, but it looks like this isn't drupal's fault.
Before reporting a problem you may want to use the search on drupal.org to see if others have run into the same or a similar error. Maybe this has already been reported. I got quite some hits searching for "Illegal mix of collations utf8". For example have a look at the second hit: llegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT).
Please take some time and read the docs on how to report a problem.
Changing title to be more descriptive.
Setting status to active, see status settings for an issue.
Setting to unassigned. You should set it to your name only if you want to take responsibility for seeing the issue to completion, or to its next step towards completion.
Comment #2
dddave commentedComment #3
yuseferi commentedIt is because your tables collation , you should changing the collation to utf8_general_ci on all tables fixed it,