Attribute dropped with Category Change

[Ajeh]

If a product is moved all that is done is the categories_id is changed on the products_to_categories table ...

If a product is copied to another category, the download is not copied with it ...

Do you know if it was moved or copied to the new category?

[HinterWelt2]

If a product is moved all that is done is the categories_id is changed on the products_to_categories table ...

If a product is copied to another category, the download is not copied with it ...

Do you know if it was moved or copied to the new category?

Not sure. I will query and let you know. This is definitely within the realm of possibility.

Thanks,
Bill

[kobra]

Bill,

Place the shop in maintenance mode and take a backup "right" before you do something like this.

If you have cPanel, plesk, or another featured manager, this only takes 5 min

[HinterWelt2]

Bill,

Place the shop in maintenance mode and take a backup "right" before you do something like this.

If you have cPanel, plesk, or another featured manager, this only takes 5 min

Not a problem. That is how I do it. I use Navicat. The problem is the owners will do these things much like you would use a file system;i.e. without much thought to data loss and without warning me. This is a good lesson for them as they are doing the re-attributing.

I will keep it in mind to try and impress on them how important it is.

Thanks,
Bill

[HinterWelt2]

If a product is moved all that is done is the categories_id is changed on the products_to_categories table ...

If a product is copied to another category, the download is not copied with it ...

Do you know if it was moved or copied to the new category?

The used Move. This begins to worry me more and more.

Bill

[Ajeh]

The used Move. This begins to worry me more and more.

Bill

Worries you? Worries me ...

There is nothing in the:
/admin/includes/modules/move_product_confirm.php that even refers to the attributes ...

What version of Zen Cart are you running and what add-ons are you using?

Are your products all done manually or are you using add-ons?

Did you use the M for Move or something else?

[HinterWelt2]

Worries you? Worries me ...

There is nothing in the:
/admin/includes/modules/move_product_confirm.php that even refers to the attributes ...

What version of Zen Cart are you running and what add-ons are you using?

Are your products all done manually or are you using add-ons?

Did you use the M for Move or something else?

Using 1.3.6.

I have done some custom mods and that could be an issue. Mostly it is supporting a muti-vendor mall setup with just two changes to the DB (a vendor status and vendor ID in the customer table). They did not use any of my mods to move the products (I have a Vendor Tools console).

Add-Ons - Sales Report, running a modded version of Future Zen Template 15, About Us 1.3, Go Daddy and Paypal Seals, Login BoxBack up MySQL Plugin (couldn't get it to work).

Just got this from the owners:

Update: Just ran a test with one of Goodman's products. We found it didn't have an linked download, but the attribute controller had been assigned so that on the screen it still had the button that says "download zip file."

I purchased the product and didn't receive a link. The product then changed to red disabled and listed 0- just like what our XRP products had done. I think that means the problem is coming first from something erasing the linked file, but the attributes still thinking there is an attached file.

They used the M for move.

Sorry to be such a pain. It has me a bit stumped.

Thanks,
Bill

[Ajeh]

Me too ...

Off to do a bunch of testing ...

[Ajeh]

Check one other thing ...

On the products_attributes_download where the filenames removed from the field products_attributes_filename? The records themselves removed? Or were the filenames missing from the /download directory?

[HinterWelt2]

Check one other thing ...

On the products_attributes_download where the filenames removed from the field products_attributes_filename? The records themselves removed? Or were the filenames missing from the /download directory?

The entire record was missing. The files were still in place. The download attribute was set but the download field was not....ah, when you look at the Attribute Controller you would see a "Download" attribute but no file path/name. So, the attribute is not being dropped per se, but the file information is lost, like it gets deleted from the product_attribute_download table.

Clear?

Thanks for your help,
Bill