Attribute dropped with Category Change

[HinterWelt2]

I know this is an old thread, but at least you know I searched for an answer before posting :) .

I have a client that has had this same thing happen. The file names just disappeared. I don't think she's made any recent changes, I will check to see, but on just some of her items, the file names are gone. I looked in the database and those records are completely gone from the products_attributes_download table, but are still in the products_attributes table. If I look at the product attributes in the attribute manager, the attributes are there, but the file names are gone.

Help?

Hah!!! I am not insane!...well, delusional anyway. ;)

This continues to happen to all three stores I manage. This ranges from 1.36 modded to be a mall vendor set up to an unmodded 1.38a install.

Take a look at this thread:
http://www.zen-cart.com/forum/showthread.php?t=136022

I have found a way to detect the dropped file names. This helps with one of my clients because they have a huge catalog. Who knows, it may lead to a solution down the road.

Hope it works out for you.

[Ajeh]

When you say Attributes are dropped on the Category change ... is this via a MOVE or a Copy to Duplicate Product?

[HinterWelt2]

When you say Attributes are dropped on the Category change ... is this via a MOVE or a Copy to Duplicate Product?

Not speaking for others, no, they are just sitting there.

Also, I realize I may be misleading you. It is an important distinction that the ATTRIBUTE is still there, the DOWNLOAD_FIELD is empty. So, you can go to the Attributes controller and see the download attribute still attached to the product but the download field is empty.

Hope that helps.

ETA: I had a theory at one time that somehow the stock level was being counted and it was dropping to 0 then releasing the download somehow. Unfortunately, I reconfigured the store to not track stock and it still does it.

[Ajeh]

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

[DigitalScrapDesigns]

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

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.

[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