Quote:
Database error in vBulletin 4.0.6:
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 : Incorrect information in file: './XXXXXX_vb/contenttype.frm'
Error Number : 1033
Request Date : Saturday, September 11th 2010 @ 03:19:39 PM
Error Date : Saturday, September 11th 2010 @ 03:19:40 PM
Script : http://www.XXXXXXXXX.net/test_vb/for...hread.php?t=43
Referrer : http://www.XXXXXXXXXX.net/test_vb/fo...isplay.php?f=5
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community