PDA

View Full Version : Error of attach


iamquangnam
03-19-2006, 02:40 AM
In the admincp->Attachment Manager. Have error :

Warning: mysql_query(): Unable to save result set in /includes/class_core.php on line 404
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT attachmentid, attachment.dateline, attachment.postid, filename, filesize,
user.userid, IF(user.userid<>0, user.username, post.username) AS username
FROM attachment AS attachment
LEFT JOIN user AS user ON (attachment.userid=user.userid)
LEFT JOIN post AS post ON (attachment.postid=post.postid)
ORDER BY filesize DESC
LIMIT 5;

MySQL Error : Got error 124 from storage engine
Error Number : 1030


who know,plz help me

CMX_CMGSCCC
03-21-2006, 05:45 PM
It doesnt even say what the error is? It looks like attachmentid should be attachment.attachmentid

-CMX