Avatar Table Problem

[winterhawke]

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

 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:

 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!

[Dennis Olson]

What's "avatar.frm"?

[Marco van Herwaarden]

The MySQL table definition file for the avatar table.

[winterhawke]

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