I attempted to log onto my board this morning and immediately got this error:
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:
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!
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
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
THANKS IN ADVANCE!
Comment