Announcement

Collapse
No announcement yet.

Avatar Table Problem

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

  • Avatar Table Problem

    I attempted to log onto my board this morning and immediately got this error:

    Code:
     Database error in vBulletin 3.0.5: 
    Invalid SQL: 
    SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
    FROM user AS user
    LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
    LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
    WHERE user.userid = 1
    mysql error: Incorrect information in file: './angelica_forum/avatar.frm'
    mysql error number: 1033
    Date: Thursday 12th of May 2005 01:30:01 PM
    Script: http://www.angelicasylum.com/
    Referer: http://my.yahoo.com/index.html
    Username: Reggae Maan
    IP Address: 24.141.200.58
    While trying to do a repair and optimize on the SQL database using phpMyAdmin, I received the same mysql error: #1033 - Incorrect information in file: './angelica_forum/avatar.frm'

    The table (avatar) is showing as "in use" when I view the database structure in phpMyAdmin.

    Trying to use the Avatar Manager in the Admin Control Panel gets me the following:
    Code:
     Database error in vBulletin 3.0.5: 
    Invalid SQL: 
    SELECT imagecategory.*, COUNT(avatar.avatarid) AS items
    FROM imagecategory AS imagecategory
    LEFT JOIN avatar AS avatar USING(imagecategoryid)
    WHERE imagetype = 1
    GROUP BY imagecategoryid
    ORDER BY displayorder
     
    mysql error: Incorrect information in file: './angelica_forum/avatar.frm'
    mysql error number: 1033
    Date: Thursday 12th of May 2005 01:27:54 PM
    Script: http://www.angelicasylum.com/forums/...y&table=avatar
    Referer: http://www.angelicasylum.com/forums/admincp/index.php
    Username: Reggae Maan
    IP Address: 24.141.200.58
    I am a mySQL newb and am looking for some direction here. I have a database backup that is about a week old, but hate to have to use that and lose all the posts in between.

    THANKS IN ADVANCE!

  • #2
    What's "avatar.frm"?

    Comment


    • #3
      The MySQL table definition file for the avatar table.
      Want to take your board beyond the standard vBulletin features?
      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

      Comment


      • #4
        Disregard... I've figured it out. A few less hairs and a slightly higher blood pressure reading, but I figured it out.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X