[Suite] All CMS attachments now gone after upgrade

[monoco]

After upgrading from 4.0.3 to 4.0.4, attachments for all my articles in the CMS have disappeared.

Images are now replaced by "Attachment xxx". Clicking on them says invalid attachment specified. If you have followed an invalid link contact the administrator"

Any ideas wha this is happening?

[DCX000]

Same problem here.

Any thoughts on this, anyone, please....

[Trevor Hannant]

Can you access the database and check whether the 'contentid' value for the relevant attachmentid in the attachment table is the same as the article number (i.e. if your article is "content.php?17-Help-Me-Please", then the contentid should be 17)

[DCX000]

Thanks for the follow up Trevor. I responded in the support ticket.

[Alec W]

I have the same problem. 100s of articles now have no pictures.

[Alec W]

Example:

http://www.trail-recon.com/vforum/content.php/217-Quick-Easy-Trans-Fluid-Change

SELECT * FROM `attachment` WHERE contentid = 217 - Returns no rows

[Alec W]

Some more info.

All 389 CMS attachments (contenttypeid = 18) in the attachment table have a contentid of 226.

This article has an attached image (Attachment 1979) - http://www.trail-recon.com/vforum/co...inal-Jeep-Tiki!!

In the backup database I made last night before moving from 4.0.3 to 4.0.4 the contentid in the attachment table for this row was 211.




Help!!!

[rootsxrocks]

I have the same issue, the images are shown as a link rather then the previous thumbnail that enlarges when hoovering. in edit mode I get the advance tool I had not seen previously but it only works for the first two images. The pencil is non responcive on the third image in an article.

[Trevor Hannant]

Some more info.

All 389 CMS attachments (contenttypeid = 18) in the attachment table have a contentid of 226.

This article has an attached image (Attachment 1979) - http://www.trail-recon.com/vforum/co...inal-Jeep-Tiki!!

In the backup database I made last night before moving from 4.0.3 to 4.0.4 the contentid in the attachment table for this row was 211.




Help!!!

Bug Report for this is http://tracker.vbulletin.com/browse/VBIV-7608

You'll have to either manually change the contentid to the article number for each attachment or create a query which will do a mass-change.

It may be possible to extract this from a backup of that table from prior to the upgrade. I'm not aware of any changes being made to the contentid structure in the attachment table so you could, in theory, replace the contentid values with those from your backup.

Note that I've not tested this though (and won't be able to until tomorrow evening GMT at the earliest) so if you choose to do this, please ensure you do it on a test site/database in the first instance.

[Alec W]

Thanks Trevor. This is what I did and it worked.


1). Download your vb backup database locally - You did make one before you upgraded right?
2). Extract the attachment table locally into its own database
3). Rename the table oldattachment
4). Export the oldattchment table locally
5). Import the oldattachment table into your vbulletin database
6). Run this query
UPDATE attachment AS toTable, oldattachment AS fromTable SET toTable.contentid = fromTable.contentid WHERE toTable.attachmentid = fromTable.attachmentid AND fromTable.contenttypeid = 18
8). Clear CMS Cache

[ArchAngelz]

I'm wondering why users have to do so much self-patching to fix a bug caused by an upgrade? I lost all my attachments as well and looking at these "self-fixes" does not inspire a lot of confidence.

[kfrosty]

Does this problem exist with 4.0.4 PL 1 or just 4.0.4?

[DCX000]

For me it started with 4.0.4 and continues with PL1. Unfortunately the above fixes didn't put everything back in place for me. Waiting for developer support to figure out what's going on.

[ArchAngelz]

I went directly from 4.03 to 4.04PL1+patch; I think it doesn't really matter; once you go to 4.04, 4.04PL1 or 4.04PL1+patch you will get the same problem.

[wcguy]

I use the mod found in this post

http://www.vbulletin.com/forum/showt...nto-the-Forums......

and I still have all of my attachments.....

Maybe you all could try it out too.