منتدى استراحات زايد

Trying to upgrade from 3.8.4 to 4.0.1 but got the following error on Step 9) Albums System Alterations

Code:
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 VB_package AS package
LEFT JOIN VB_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 VB_contenttype AS contenttype
INNER JOIN VB_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN VB_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 (greek_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Monday, January 25th 2010 @ 02:57:30 AM
Error Date : Monday, January 25th 2010 @ 02:57:31 AM
Script : http://www.indianwatchdogs.com/forum...0a1.php?step=9
Referrer : http://www.indianwatchdogs.com/forum...0a1.php?step=8
IP Address : 202.74.219.105
Username :
Classname : vB_Database
MySQL Version : 4.1.22-standard
How to fix it?

However, more urgent issue is that after uploading 4.0.1 files, the forum layout has gone beserk.. http://indianwatchdogs.com/forums/index.php

How to fix?