Problem with database

[negrowarez]

Disable all plugins and now what I get is this

Database error in vBulletin 4.0.8:

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   : Table 'undermu1_negrow.contenttype' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, November 9th 2010 @ 01:37:16 AM
Error Date    : Tuesday, November 9th 2010 @ 01:37:16 AM
Script        : http://undermusicworld.com/newthread.php?do=newthread&f=66
Referrer      : http://undermusicworld.com/forumdisplay.php?66-PRESENTATE
IP Address    : **.***.***.***
Username      : Negrowarez
Classname     : vB_Database
MySQL Version : 5.0.91-community

I can not post anything, the forum I can see it and everything but I can not delete or post anything.

[negrowarez]

Thanks everybody for the help

[YankForum]

First, try running Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

OR:
it seems the table undermu1_negrow.contenttype doesn't exist , try to DROP TABLE IF EXISTS and then recreate it , You can get its structure from the mysql-schema.php file inside the install folder.

[negrowarez]

Originally Posted by YankForum

First, try running Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

OR:
it seems the table undermu1_negrow.contenttype doesn't exist , try to DROP TABLE IF EXISTS and then recreate it , You can get its structure from the mysql-schema.php file inside the install folder.

Thanks YankForum I go to try that.

[negrowarez]

The problem remains the same ... I do not know what to do

[Lynne]

Exactly what did you do? If you actually added a new table, then I don't see how you can still be getting this error. Do you see a table called contenttype in your database?