500 Internal Server Error when clicking on a post.

[Fungsten]

Hello Everyone,

On my test forum I am running 4.0.6. Whenever I click on a post I get the Internal Error. I have also disabled the Hooks/Plugins and it comes up with a database error.

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/forums/showthread.php?t=43
Referrer : http://www.XXXXXXXXXX.net/test_vb/forums/forumdisplay.php?f=5
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community

Also not all the options are showing up under ACP - Maintenance - Update counters. The list stops half way between the Rebuild Search Index.

Anyone have a solution for these? TIA.

[ragtek]

Incorrect information in file: './XXXXXX_vb/contenttype.frm
I think your database is broken. Try to repair it.

--------------- Added 1284306116 at 1284306116 ---------------

http://www.vbulletin.com/forum/showthread.php?44909-3-ways-to-repair-a-database

[Fungsten]

I think your database is broken. Try to repair it.

--------------- Added 12 Sep 2010 at 08:41 ---------------

http://www.vbulletin.com/forum/showthread.php?44909-3-ways-to-repair-a-database

I'll try what's at the link. BTW I would have tried through the ACP but the option to repair is not shown! The options stop at Repair Search or something.

--------------- Added 13 Sep 2010 at 14:06 ---------------

I think your database is broken. Try to repair it.

--------------- Added 12 Sep 2010 at 08:41 ---------------

http://www.vbulletin.com/forum/showthread.php?44909-3-ways-to-repair-a-database

Here's the error code during the repair:

XXXXX_vb.contenttype
Error : Incorrect information in file: './XXXXX_vb/contenttype.frm'
error : Corrupt
XXXXX_vb.cpsession
note : The storage engine for the table doesn't support repair