[Forum] data base error while upgrading

[drsmash]

i found this error while upgrading

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_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Wednesday, December 23rd 2009 @ 05:53:32 PM
Error Date    : Wednesday, December 23rd 2009 @ 05:53:32 PM
Script        : http://www.7war.org/vb4/install/upgrade_400a1.php?step=8
Referrer      : http://www.7war.org/vb4/install/upgrade_400a1.php?step=7
IP Address    : 41.233.108.126
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.85-community 

what is that error ?

[ChopSuey]

Did you disable ALL hooks via config.php ?

[drsmash]

yes
i will try to delete them now and reply again

[drsmash]

the problem was the new databse collation was latin1_general_ci and the old database was latin1_swedish_ci i changed the collation then copied the databse again and its worked

thanks