Forum Problem in Step 9 - Upgrading from 3.8.4 to 4.0.7

[محروم.كوم]

Today I start to make the upgrade for my forum, that was working on 3.8.4, and I download the last version to 4.0.7 but I have a problem in Step 9 (Albums System Alterations).

Here is the message from the error:


Quote:
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 package AS package
LEFT JOIN 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 contenttype AS contenttype
INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Tuesday, September 21st 2010 @ 07:22:01 PM
Error Date : Tuesday, September 21st 2010 @ 07:22:01 PM
Script : http://www.myaddress.com/forum/insta...0a1.php?step=9
Referrer : http://www.myaddress.com/forum/insta...0a1.php?step=9
IP Address : 186.207.93.186
Username :
Classname : vB_Database
MySQL Version : 5.0.90-community


Can anyone give me a hand with this problem? What should I need to do?


Thanks!
Regards, __DEFINE_LIKE_SHARE__