Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 05 Jan 2013, 11:29
TTF TTF is offline
 
Join Date: Aug 2010
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.
Reply With Quote
  #2  
Old 05 Jan 2013, 13:36
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I don't understand much about how attachments are stored, but it could be that you also need to restore the filedata table.
Reply With Quote
  #3  
Old 06 Jan 2013, 03:04
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #4  
Old 07 Jan 2013, 14:03
TTF TTF is offline
 
Join Date: Aug 2010
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.
Reply With Quote
  #5  
Old 07 Jan 2013, 17:02
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 07 Jan 2013, 17:21
TTF TTF is offline
 
Join Date: Aug 2010
Originally Posted by Lynne View Post
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?
All of those are set up correctly. It's only an issue with the one thread which got deleted and then I manually restored in the file system and database. I've also rebuilt threads, posts etc and no joy.

Thanks.
Reply With Quote
  #7  
Old 07 Jan 2013, 17:25
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #8  
Old 08 Jan 2013, 09:01
TTF TTF is offline
 
Join Date: Aug 2010
Originally Posted by Lynne View Post
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?
I have sent you a link to the site, hope that's ok. Yes that's correct, I merged an old version with the current version (as the board is quite active and couldn't simply restore) just those database tables.

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
Reply With Quote
  #9  
Old 08 Jan 2013, 20:36
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #10  
Old 09 Jan 2013, 09:42
TTF TTF is offline
 
Join Date: Aug 2010
Originally Posted by Lynne View Post
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.
Yep, tried rebuilding everything. No problem, well thanks for your help anyway.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 18:15.

Layout Options | Width: Wide Color: