By joycejohnson on

Hello,

I just installed drupal 6.14 that was provided to me by my hosting company. The installation seem to go OK, but when I logged in to administer the site, I got the following error:

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 = 'user' AND aa.op = 'view' ORDER BY weight in /home/joycejohnson/public_html/onegodaddy.com/modules/trigger/trigger.module on line 146.

Can someone give me a clue as to where I can go to retrieve this file? Apparently there is an error at line 146, but I can't even find the file.

thanks in advance

⋅ Categories: Drupal 6.x

Comments

dbeall’s picture

dbeall commented

I have never loaded Drupal using a host control panel...
and
I am not a sql pro, but from reading the forums,, it looks like the database is somehow using 2 different collations.
This is nothing to do with the trigger module, it's database.

one thing you can check is..
goto 'sql manage', 'database manage' or 'phpmyadmin'
on the left, click the database that holds Drupal
then at the top click 'operations'
down at the bottom is a 'Collation:' select box.. there might be 2 selections highlighted in there..
select just one,, utf8_general_ci

I think that will do it..

If not try,, latin1_swedish_ci

if that won't work type 'sql collation' in the Drupal search box and see what you can find there

dbeall’s picture

dbeall commented

looking at the error, you seem to be using godaddys drupal installed database.. If that is the case, it's a godaddy issue.

as I had said, never have used a host installed application..
maybe make your own database and install drupal your self to have control over everything

dbeall’s picture

dbeall commented

I might be confused here.. is your site named onegodaddy.com?
that will confuse many people.

GDHosting’s picture

GDHosting commented

joycejohnson,

If you're using Go Daddy to host, I suggest that you uninstall and reinstall in Hosting Connection using these instructions-
http://help.godaddy.com/article/1736
http://help.godaddy.com/article/1724

If you still run into problems please give our support team a call so they can take a look. Support information can be found here: http://www.godaddy.com/community/community.aspx?tab=support