Attribute dropped with Category Change

[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

[DigitalScrapDesigns]

We do have un_wishlist... could this be the whole reason its happening? Its utilized by some of our customers, but not the majority so it may just be better to get it off??

We are still dealing with this, two orders today missing download links, and unfortunately while I can poke around and fix some minor things I am not comfy with delving too deeply in the databases yet.

I've installed the things we have myself, but pretty much just following directions... not too much heavy lifting on my own.

What exactly does your fix do? Find the products missing attributes? Or fix the orders missing download links?

At least it helps to know we're not the only ones dealing with this.

Misery loves company right??

[DigitalScrapDesigns]

Well just to be safe I did remove the un_wishlist...

[HinterWelt2]

Well, my fix was far from graceful. I had wanted to update the wishlist to inject a link with the attributes but Linda said this could not be done. I have not had the time to dig into it to see if I could make a workaround. So, I ended up disabling the links. It worked out o.k. but now there are no links to the products from the wishlist and as you can imagine, it just is not very useful.

Sorry I do not have better news.

Bill

[digidiva-kathy]

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?

[DigitalScrapDesigns]

This still randomly happens to products in our store too. I have never been able to figure it out (but not by any means an expert at looking either)... we just fix the ones we find that way, usually when a customer emails saying there was no download for their order - not a fun way to find them but with thousands of products about the only way.

Once we fix them, they seem to stay fixed at least...

[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?