Announcement

Collapse
No announcement yet.

UserCP Database Error

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

  • ★Jigsaw
    replied
    And is this in phpMyAdmin>>Operations?

    Leave a comment:


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

    Leave a comment:


  • ★Jigsaw
    replied
    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?

    Leave a comment:


  • Zachery
    replied
    Do you have a recent backup?

    Leave a comment:


  • ★Jigsaw
    replied
    Have done that and it does not seem to work.

    Leave a comment:


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

    Leave a comment:


  • ★Jigsaw
    replied
    Someone help?

    Leave a comment:


  • ★Jigsaw
    started a topic [Forum] UserCP Database Error

    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.

Related Topics

Collapse

Working...
X