Announcement

Collapse
No announcement yet.

UserCP Database Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] UserCP Database Error

    Hello, vBulletin

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


    Code:
    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

    Code:
    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


    Code:
    _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.

  • #2
    Someone help?

    Comment


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

      Comment


      • #4
        Have done that and it does not seem to work.

        Comment


        • #5
          Do you have a recent backup?

          Comment


          • #6
            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?

            Comment


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

              Comment


              • #8
                And is this in phpMyAdmin>>Operations?

                Comment

                Related Topics

                Collapse

                Working...
                X