Attribute dropped with Category Change

[HinterWelt2]

So the records are still in the products_attributes_download table but the field products_attributes_filename is mysteriously blank?

For reference, here is the SQL I use to find the missing filenames:

select pa.products_id, pa.products_attributes_id, p.products_name
from Products_attributes as pa, products_description as p
where not exists(select * from products_attributes_download as pad where pa.products_attributes_id = pad.products_attributes_id ) and pa.products_id=p.products_id order by pa.products_id

So the entry in products_attributes_download is missing but the entry in products_attributes is still there.

Yeah, it has taken me two years to track this down just because it makes not sense.

I believe this is what happens for us. I am not sure though whether its triggered by a category change or what exactly. We have 2300+ downloadable products. So it's been mostly just stumbling across the ones missing them when someone emails and says they are missing from their orders.

As stated, it's still set like their was originally a file attached but the field itself referring to that file is empty.

Thanks for the link to the other thread, I will definitely check it out.

I just ran the script and found another four products BEFORE anyone purchased them.

My next mod will be one that allows for attaching downloads to orders directly. Currently, it is all through SQL scripts on the DB. Still, if we coudl just stop it from happening it would be great. Luckily, I have a version of this with the Subscription mod I did so whipping this bad boy up should not be too hard.

Good luck!

Bill