vB - MySQL Query gone wrong.

[Alcar Lazuli]

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...

[JulianD]

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

[Alcar Lazuli]

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...

[JulianD]

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

[Erwin]

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

[Alcar Lazuli]

Originally posted by Erwin
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...

[Xenon]

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

[Erwin]

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