The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Attachments Table - Going Mad!
Basically what happened was a large thread with lots of images was soft deleted, then restored. The images have gone as the keep attachments wasn't ticked.
So I've got a backup, merged the attachment table so that all the fields are back and the attachments folder in the file system has also been sorted. In the database I can see the images point to the correct places, just like before the thread got deleted and I can load the images fine. However in the admin panel under attachment manager, it doesn't seem to show that the table has been updated. The number of rows is like before the tables were merged and the images aren't displaying in the thread - it just said invalid and shows a link of the attachment ID. I've been trying to sort this for ages now, any help would be ever so much appreciated as I'm going mad here!!! Hoping I just need to reset a counter or something to get vbulletin to see the newly added images in the database. Thanks. |
#2
|
|||
|
|||
I don't understand much about how attachments are stored, but it could be that you also need to restore the filedata table.
|
#3
|
||||
|
||||
The image data is actually stored in the filedata table as Kevin said. You need both the attachment table data and the filedata table data.
|
#4
|
|||
|
|||
Thank you very much for the reply. I have updated this table and now the image does work when you click on the 'attachment xxxx' link. Is there any way to get the previews back so it can open as normal in the lightbox? I have tried rebuilding thumbnails but that hasn't worked.
Thank you. |
#5
|
||||
|
||||
What do you have set in AdminCP > Settings > Options > Message Attachment Options > View Attachments Inline? Is it set to Display Thumbnails? And did you check all usergroup permissions to make sure they have permission to view Thumbnails?
|
#6
|
|||
|
|||
Quote:
Thanks. |
#7
|
||||
|
||||
Did you ever provide a link to the problem thread?
And just to clarify, you restored the attachment and filedata table from a backup but no other tables? |
#8
|
|||
|
|||
Quote:
I'm pleased that I've got the images back but if there's any way to get the thumbnails back as well then that would be really handy. Thanks again |
#9
|
||||
|
||||
Did you try rebuilding the attachment thumbnails? You are using vbseo on your site and so the attachment links are totally different than a default attachment link, so I can't really see what is wrong.
|
#10
|
|||
|
|||
Yep, tried rebuilding everything. No problem, well thanks for your help anyway.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|