[Forum] UserCP Database Error

[★Jigsaw]

Hello, vBulletin

I am receiving the following error as I visit my UserCP....

Database error in vBulletin 4.1.2:

Invalid SQL:

                SELECT contenttype.contenttypeid AS itemid
                    
                FROM _vbcontenttype AS contenttype
                    INNER JOIN _vbpackage AS package
                    ON package.packageid = contenttype.packageid LEFT JOIN _vbproduct AS product
                    ON product.productid = package.productid 
                WHERE
                    1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.canattach = '1';

MySQL Error   : Incorrect information in file: './xxxxxx_forumdb/_vbcontenttype.frm'
Error Number  : 1033
Request Date  : Friday, April 22nd 2011 @ 07:22:41 PM
Error Date    : Friday, April 22nd 2011 @ 07:22:41 PM
Script        : http://www.forum.xxxxx.info/usercp.php
Referrer      : http://www.forum.xxxxx.info/member.php?1-Jigsaw
IP Address    : XX.XXX.XXX.XXX
Username      : Jigsaw
Classname     : vB_Database
MySQL Version : 5.0.92-community

The forum works absolutely however as I tried fixing the database issue in AdminCP and cPanel, I received this statistic from both of them. As you would notice when analysing my database report I only included the one's which was posing as an issue.

cPanel

Error    : Incorrect information in file: './xxxxxx_forumdb/_vbtag.frm'
error    : Corrupt
xxxxxx_forumdb._vbtagcontent
Error    : Incorrect information in file: './xxxxxx_forumdb/_vbsearchcore.frm'
error    : Corrupt
xxxxxx_forumdb._vbsearchgroup
Error    : Incorrect information in file: './xxxxxx_forumdb/_vbsearchgroup.frm'
error    : Corrupt
xxxxxx_forumdb._vbsearchlog
Error    : Incorrect information in file: './xxxxxx_forumdb/_vbsearchlog.frm'
error    : Corrupt
xxxxxx_forumdb._vbsession
note     : The storage engine for the table doesn't support repair
Error    : Incorrect information in file: './xxxxxx_forumdb/_vbtagcontent.frm'
Error    : Incorrect information in file: './xxxxxx_forumdb/_vbcontenttype.frm'
error    : Corrupt
xxxxxx_forumdb._vbcpsession

vBulletin

_vbcontenttype     Check     Error: Incorrect information in file: './xxxxxx_forumdb/_vbcontenttype.frm'
_vbcontenttype     Check     Error: Corrupt
_vbsearchcore     Check     Error: Incorrect information in file: './xxxxxx_forumdb/_vbsearchcore.frm'
_vbsearchcore     Check     Error: Corrupt
_vbsearchgroup     Check     Error: Incorrect information in file: './xxxxxx_forumdb/_vbsearchgroup.frm'
_vbsearchgroup     Check     Error: Corrupt
_vbsearchlog     Check     Error: Incorrect information in file: './xxxxxx_forumdb/_vbsearchlog.frm'
_vbsearchlog     Check     Error: Corrupt
_vbtag     Check     Error: Incorrect information in file: './xxxxxx_forumdb/_vbtag.frm'
_vbtag     Check     Error: Corrupt
_vbtagcontent     Check     Error: Incorrect information in file: './xxxxxx_forumdb/_vbtagcontent.frm'
_vbtagcontent     Check     Error: Corrupt

Could someone please help me out with this database error as I have not as much experience with Database sticky situations.

[★Jigsaw]

Someone help?

[Zachery]

Have you tried repiaring it more than once? It can take several times.

[★Jigsaw]

Have done that and it does not seem to work.

[Zachery]

Do you have a recent backup?

[★Jigsaw]

Yes I do have a backup however it won't solve the solution because the backup's database is corrupt for the forum just as my current database, isn't there any possible way of fixing this?

[Zachery]

If you cant repair those tables you'll need to drop and re-create them.

[★Jigsaw]

And is this in phpMyAdmin>>Operations?