vBulletin Database Question

Pompidou

Faceless Poster
Adventurer
Joined
Sep 24, 2004
Messages
1,137
Age
47
Location
Connecticut
Website
www.buchisdma.com
Main Job
BlackMage-Male
Server
Quetzalcoatl
Linkshell
Roninrebirth
I think I'm going to have to restore my database, because a segment has corrupted and seemingly can't be repaired, specifically "picture", and it's causing a myriad of problems. I was just wondering if it's possible to restore a database without losing everything that's on it. I made a backup of the database minus the corrupted table. I'd prefer not to have to reinstall vBulletin and the accessories from scratch. Can I just reset that single table to factory settings, for lack of a better description? That would be even better. I ran a diagnostic in both mysql and the admincp and they both show only one flawed database table. I'll post the error reports for the hell of it. I have nothing to lose at this point. I'm more likely to get help here than any of the support forums because QCDN actually has members that don't ignore me.

This is the error report vBulletin calls up:
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT picture.pictureid, picture.userid, picture.caption, picture.extension, picture.filesize,
picture.width, picture.height, picture.reportthreadid, picture.state,
picture.idhash, picture.thumbnail_filesize, albumpicture.dateline, albumpicture.albumid
FROM albumpicture AS albumpicture
INNER JOIN picture AS picture ON (picture.pictureid = albumpicture.pictureid)
WHERE albumpicture.albumid = 1
AND albumpicture.pictureid = 179;
MySQL Error : Table './buchisdm_buchisdma/picture' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Tuesday, August 5th 2008 @ 06:35:28 AM
Error Date : Tuesday, August 5th 2008 @ 06:35:28 AM
Script : http://www.buchisdma.com/forums/albu...&pictureid=179
Referrer :
IP Address : 66.212.205.234
Username : Pompidou
Classname : vB_Database
-----------------------------------------------------------------------------
And this is the status report in the admin cp:
pictureCheckWarning: Table is marked as crashed and last repair failed
pictureCheckWarning: Size of indexfile is: 9216 Should be: 7168
pictureCheckError: Record-count is not ok; is 236 Should be: 127
pictureCheckWarning: Found 289 parts Should be: 127 parts
pictureCheckError: Corrupt
 
Back
Top