Attribute dropped with Category Change

[HinterWelt2]

The drama continues. It appears to be a deletion from the products_attributes_download table and it happens at random or atleast in a pattern I cannot discern. These are definitely not files that are being touched. The entries for the downloads are deleted though.

So, likely suspects. I have modified the admin pages to create a second interface called Vendor Tools. This is for self administration of the products on the site. Would/Could this be due to a heavily modified Attributes Controller page? The strange thing is the entry is still there but the download information is gone. So, you hit Display and an empty assigned attribute comes up.

Theory: Could be a delete attribute artifact in the vendor pages just deleting the entry in products_attributes_download. This seems a bit far fetched but I will pursue it.

Grr, what a pain. (But thanks for all the help guys. Not mad at you, just the situation.)

Bill

[Ajeh]

Could you look in your admin_activity_log ... this should give you the movement through the Admin when this was done ...

Maybe it can help locate a pattern in there?

Thanks for the update ... still cannot repeat it myself either ...

[HinterWelt2]

Could you look in your admin_activity_log ... this should give you the movement through the Admin when this was done ...

Maybe it can help locate a pattern in there?

Thanks for the update ... still cannot repeat it myself either ...

This is going to sound stupid, but I can't find the Admin log...where might it be?

Thanks,
Bill

[Ajeh]

In phpMyAdmin ... look for the admin_activity_log ... browse that to see actions in the Admin that are recorded ...

[DigitalScrapDesigns]

We are suddenly having this problem on our site too. Two orders in today customers emailed to say downloads weren't there... only some products are missing like this.

Went in to look -- it shows the attribute has a download, but it's no longer linked to the actual file.

It's very difficult to check in our store what other products may have lost their files, as we have 900+ products all download and growing.

[Ajeh]

When you say:

Went in to look -- it shows the attribute has a download, but it's no longer linked to the actual file.

Do you mean that the Attribute is added but the Download filename is blank?

Have you looked at the Downloads Manager to see if it can help spot these?

If you browse the products_attributes_download table in phpMyAdmin, do you see any entries without the download filename?

More or less what I am trying to discover is if the record is missing or blank or not filled in with the right information in the products_attributes_download table ...

[DigitalScrapDesigns]

Hopefully I can explain clearly enough...

As far as I can tell, the products missing their download files are not showing up in the download manager, and when a person purchases them no download at all shows.

However, when I have gone in to look at the file itself and its attributes, it still has a "download" attribute set, just blank for the actual file name and path.

I know these were originally set.

We do have some addon modules - admin permissions (for multiple manufacturers to be able to add their own products), export orders, image handler. These have all been installed since the get go (about 9 months now) and we've had no issues with them. And this issue has only been occuring within the last week to two.

[Ajeh]

Might see what files that you have added, changed, etc. reference the products_attributes and products_attributes_download tables to see if there is something askew ...

[HinterWelt2]

Just to add, this continues to be an issue with us as well. I have three Zen stores I maintain and all have this issue. Two are heavily modded while the third is virtually unchanged from the original install. Versions range from 1.36-1.38a.

Bill

[HinterWelt2]

Also, if you have the UN_Wishlist installed it is VERY BAD for downloads.

If you are dealing with lost download links I have developed a tool for dealing with it. Here is the SQL. Zencart Gurus, this seems to work but am I missing something?

insert into orders_products_download (orders_id,orders_products_id, orders_products_filename, download_maxdays, download_count, products_prid) VALUES (ORDERNO, ORDERS_PRODUCT_ID, (select products_attributes_filename from products_attributes_download where products_attributes_id=YOUR_PRODUCT_ID), 0, 5, (select products_prid from orders_products where orders_products_id=ORDERS_PRODUCT_ID))

Replace CAPS vars with your values.

Hope that helps.

Bill