Product page shows "404 not found" in page title

[phantonym]

One specific product shows "404 not found" in page title.

A large "Whoops, our bad..." where the Related Products block used to be.

Other product pages are fine.

What's wrong?

Screenshot: Link or view below

[russell_baker]

Hi phantonym,

Did you manage to fix this?

I'm having this across all our migrated sites and I can't figure out why.

Also noticed that single product lists don't show up in bundle product pges but that could be unrelated..

Thanks

Russell

[AleseiWailabs]

Same thing. Do you have solution? 

[elfling]

Anyone else got a follow up. A resave of the product fixes this, so thinking it's DB related and not cache.

Will investigate further

[elfling]

Solution to this was  to delete where attribute is custom_design in

catalog_product_varchar (possibly attribute id 85)

 

DELETE FROM `catalog_product_entity_varchar` WHERE `attribute_id` = '85';

 

Always double check the attribute_id

[ladbroke]

Did anybody find a solution to this?  It's driving me mad!  If I edit a product in admin and save, the product then behaves exactly the same as the OP (404 in page title etc).