vB - MySQL Query gone wrong.
 

Hi there, in vB we are getting a database error that is not allowing us to use the PM Tracking, the following error is sent to the email address when that PM tracking page is loaded:

Database error in vBulletin 2.2.8:

Invalid SQL:
SELECT DISTINCT privatemessage.*, user.username AS tousername, user.emailonpm, user.invisible,
user.lastactivity, icon.iconpath, session.userid AS sessionuserid
FROM privatemessage
LEFT JOIN user ON (user.userid = privatemessage.touserid)
LEFT JOIN icon ON (icon.iconid = privatemessage.iconid)
LEFT JOIN session ON (session.userid = user.userid
AND session.userid <> 0 AND user.invisible = 0 AND session.lastactivity>0)
WHERE fromuserid=1
AND folderid <> -1
AND receipt > 0

ORDER BY dateline DESC
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Friday 06th of December 2002 06:44:18 PM
Script: http://www.oddworldforums.net/forum...80a87a2defd287c
Referer:


Thanks,
Alcar...

Looks like table corruption.... You can try to fix it by running the repair.php utility that you found in your extra's directory.

Hmm, that didn't seem to help.

It's an on and off thing. One day the Message Tracking works, the next day that error I posted above is sent, because of the error.

It's very weird.

Alcar...

Have you installed any hacks lately? You can try to ask over vbulletin.com and see if they can help you out.

Repair the table - it's a database corruption issue. Upload and run the vB repair file.

I tried that before, when JulianD suggested it. Even after the repair file was uploaded and accessed/browsed.

Alcar...

try to rerun it sometimes it's needed twice or more ;)

Xenon is right - run it a few times. Back up your db first no matter what.