Hey Firefly, I installed this hack awhile ago and then all of a sudden it stops working for alot of my members and even myself. It still works, only on certain threads and only for certain users, it's all messed up. This is the email I recieved right before it went "wacky"
Database error in vBulletin 2.2.2:
Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.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
WHERE post.postid IN (0,45327,45328)
ORDER BY dateline
mysql error: Got error 28 from table handler
mysql error number: 1030
Any help in fixing this would be great because my members and myself love this hack.
I've already tried running the repair script from my admin directory with the default 2 options it gives you on the repair.php page also to no avail.
|