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