[Forum] Attachment Database Error when opening from paperclip attachement icon

[yo!ijob]

I get this error when I open up all attachemnets in a thread, when I click on the attachemnet icon and a window opens up.

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT a.*, fd.filesize
FROM yo_post AS post
INNER JOIN yo_attachment AS a ON (a.contentid = post.postid AND a.state = 'visible')
INNER JOIN yo_filedata AS fd ON (a.filedataid = fd.filedataid)
WHERE
threadid = 25915
AND
post.visible = 1
AND
a.contenttypeid = 1
ORDER BY a.filename DESC;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Sunday, February 7th 2010 @ 08:35:54 PM
Error Date : Sunday, February 7th 2010 @ 08:35:54 PM
Script : http://www.yoliverpool.com/forum/mis...hments&t=25915
Referrer : http://www.yoliverpool.com/forum/sea...searchid=31392
IP Address : 86.162.193.13
Username : Kev
Classname : vB_Database
MySQL Version : 5.0.67-1~ui40+2

Any help would be appreciated

[yo!ijob]

It seems I have multiple database errors developing throughout my website. Any help?

[kat00]

I'm Tipping at some point that image has been deleted or moved. Ive seen some pretty wacky things by deleting and moving attachments and done a heap of trials in a test forum. Crashed Tables, DB and DB server.

If that is what has caused it, try deleting the thread..........The thread might or might not delete but the reference to the attachment will vanish and the DB errors should stop (A/ If that's what is causing your issues, B/If its only the one thread that has an attachment that has a deleted.)

This is supposed to be fixed in 4.0.3

It caused me massive problems till I figured out what the problem was.



How it has been allowed to go on this long amazes me.

See here. http://www.vbulletin.com/forum/proje...?issueid=35378

[yo!ijob]

It ws an issue with my web host and the Mysql databases, a table was locking up apparently.

all fixed now