DB Error, Invalid SQL - just started

[Franky]

Hi,

I have just recently started receiving errors being e-mailed to me from my forum. This does NOT happen for all posts, but just some.

Database error in vBulletin: Invalid SQL: 
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath, attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline FROM post LEFT JOIN icon ON icon.iconid=post.iconid LEFT JOIN user ON user.userid=post.userid LEFT JOIN userfield ON userfield.userid=user.userid LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                       LEFT JOIN customavatar ON customavatar.userid=user.userid LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
                                            AND session.userid > 0
                                            AND user.invisible = 0
                                            AND session.lastactivity>991690530) WHERE post.postid IN (0,1110,1111,1277,1303) ORDER BY dateline 

mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Monday 04th of June 2001 10:50:30 PM
Script: /network/nthellworld/vbb/showthread.php?postid=1277#post1277

I received three of these with approx 5 min gaps between e-mails. All are from the same URL/session. Any help would be appreciated. Thanks in advance,

-f

PS.

Linux 2.2.16
PHP Version 4.0.3pl1
Apache/1.3.14
VB 2.0.0

http://www.frankw.net/network/nthellworld/vbb/

[John]

This looks to me like database corruption. Do a search around these forums for database corruption and repairing it, and you will find the solution.

This page may also be useful:

http://www.mysql.com/doc/R/e/Repair.html

John