I was up until 2 this morning and got up again at 6 to try to iron out where these duplicate files are in the database. For the most part there's a genuine reason, to do with a new server and Sage 50 Actinic Link.
Apologies if this is a little disjointed or even pointless, but I thought it might be handy to have a thread full of suggestions of where to look for potential duplicates. It would have helped me immensely last night.
Anyway my list (please feel free to add stuff):
It's only recently occurred to me to check the UserDefinedProperties table (field: "sValue") to look for filenames within variables. I'm trying that now and will post an update later.
Cheers,
Ian
Apologies if this is a little disjointed or even pointless, but I thought it might be handy to have a thread full of suggestions of where to look for potential duplicates. It would have helped me immensely last night.
Anyway my list (please feel free to add stuff):
- "Product" table.
In our case, the wrong paths in here were pushed in from Sage, so we had to fix these at the Sage end. Field: "Image FileName" - "Catalog section" table
The site is designed to display one product per page, using the single-product-in-its-own-section method. As a result, the section images and the product images have to be the same, but when the product image path changes (because amendments have been made in Sage), all hell breaks loose. Field: "sSectionImageFile" - "Filelist" table
I wasn't quite sure what this does, but there were a significant number of forum post suggesting it could be cleared down. I took a snapshot and a copy of the database and went for it. No harm done but it didn't fix the problem. All fields.
It's only recently occurred to me to check the UserDefinedProperties table (field: "sValue") to look for filenames within variables. I'm trying that now and will post an update later.
Cheers,
Ian
Comment