creat group database error

[Ba$im]

hello
I have vBulletin 3.7.0 gold
when I try creat gruop
it give me database error
<!--
Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT *
FROM socialgroup
WHERE name = '*********'
AND groupid &lt;&gt; 0;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number : 1267
Request Date : Thursday, May 15th 2008 @ 03:29:33 AM
Error Date : Thursday, May 15th 2008 @ 03:29:33 AM
Script : http://*********/group.php?do=docreate&amp;groupid=
Referrer : http://********/group.php?do=create
IP Address : ***********
Username : ***********
Classname : vB_Database
MySQL Version :
--> I see it cuz I was convert all my database table to
utf8_general_ci and that since 3.6.5
then when i upgrade to 3.7.0
it look like table of new feature as group and album
installed with
latin1_swedish_ci now how can I fix it ?
PS: I go to phpmyadmin to convert
latin1_swedish_ci but edite button of these table nt work

please help

thanks in advance

[Ba$im]

MySQL client version: 4.1.22


phpMyAdmin - 2.11.4
5.0.45-community-log

[Steve Machol]

Here are the possible causes of the 'Illegal mix of collations' error and the ways to fix this:

1. The db is set to use one collation type and the tables are set to another. You need to change these to match one another. You can do this in phpMyAdmin.

2. The table collations do not match. They need to all be the same type and match the db collation. This too you can fix in phpMyAdmin.

3. The table collation does not match the collation of the individual fields in that table. You need to change these fields to match the table.

Also please see this thread:

http://www.vbulletin.com/forum/showthread.php?t=195137

[Ba$im]

thank u steve
but the problem is I can’t click on button of edite new table
the button is off light that’s mean I can’t edite table to change collation to utf8-general-

is there any way to solve these ? is there r wrong with myphpadmin?