Suite Illegal mix of collations error on step 9 install .... help!

محروم.كوم · #1 06-26-2010, 07:12 AM

Help!

Getting stuck on Step 9 of the install (see error below)....my db guy has gone through and tried to change everything over to utf8_general_ci and he is sure he has found them all (maybe not) but I still get the same error about utf8_general_ci and utf8_unicode_ci.

It looks like byt_package, byt_product and byt_contenttype tables are the offenders and he has scoured them well. He has also searched for other places for the "utf8_unicode_ci" and has replaced any he could find.

All plug-ins were disabled before the upgrade was started. Host Gator is the host (if that matters).

Any ideas? Are there some temp/hidden files/settings that we are missing?

Thanks for any help.

--Chris

Quote:

Step 9) Albums System Alterations
Moving picture 1 into the Attachment System

Database error in vBulletin 3.8.4:

Invalid SQL:

(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM byt_package AS package
LEFT JOIN byt_product AS product
ON product.productid = package.productid

WHERE product.active = 1
OR package.productid = 'vbulletin'
)

UNION

(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM byt_contenttype AS contenttype
INNER JOIN byt_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN byt_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, June 25th 2010 @ 09:29:12 PM
Error Date : Friday, June 25th 2010 @ 09:29:12 PM
Classname : vB_Database
MySQL Version : 5.1.47 __DEFINE_LIKE_SHARE__