sbarbz
07-11-2010, 01:32 PM
Hello, i upgraded from 3.8.5 to 4.0.4 and I encountered errors SQL every page in the forum.
index did not work(white page), other pages give this error:
Database error in vBulletin 4.0.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 AS package 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: Sunday, July 11th 2010 @ 05:35:26 PM
Error Date: Sunday, July 11th 2010 @ 05:35:26 PM
Referrer:
Username: Bar
Classname: vB_Database
MySQL Version: 5.0.67-community
Please Help me, thank you wholeheartedly!
index did not work(white page), other pages give this error:
Database error in vBulletin 4.0.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 AS package 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: Sunday, July 11th 2010 @ 05:35:26 PM
Error Date: Sunday, July 11th 2010 @ 05:35:26 PM
Referrer:
Username: Bar
Classname: vB_Database
MySQL Version: 5.0.67-community
Please Help me, thank you wholeheartedly!