Attribute dropped with Category Change
Running 1.3.6 (heavily modded)
Hello,
The Admin for our site created a series of subcategories and moved products into them. These products all lost their information to the download file. The Download Attribute was still there but the file information (xxx/filename.zip) was not. It had gone missing out of the DB also.
I assume this is not default behavior. I could not find any other entries on this with a search. Any ideas? We lost 300+ links that must all be redone.:down:
Thanks for any help,
Bill
Re: Attribute dropped with Category Change
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?
Re: Attribute dropped with Category Change
Quote:
I assume this is not default behavior. I could not find any other entries on this with a search. Any ideas? We lost 300+ links that must all be redone
Too late for this time but "ALWAYS BACKUP THE SITE FILES AND THE DB" before doing things like this
Re: Attribute dropped with Category Change
Quote:
Originally Posted by
kobra
Too late for this time but "ALWAYS BACKUP THE SITE FILES AND THE DB" before doing things like this
Tried. We need to get better order than we are currently doing. They are very much treating it like a file system. So, I backed up Monday night and the moved Monday during the day. I could go back to a previous version but a lot of products have been added.
Like I said, more chaos than I am happy with currently.
Thanks for the advice. I am going to try for a more rigourous backup schedule, probably nightly, until things settle down.
Bill
Re: Attribute dropped with Category Change
Quote:
Originally Posted by
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?
Not sure. I will query and let you know. This is definitely within the realm of possibility.
Thanks,
Bill
Re: Attribute dropped with Category Change
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
Re: Attribute dropped with Category Change
Quote:
Originally Posted by
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?
The used Move. This begins to worry me more and more.
Bill
Re: Attribute dropped with Category Change
Quote:
Originally Posted by
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
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
Re: Attribute dropped with Category Change
Quote:
Originally Posted by
HinterWelt2
The used Move. This begins to worry me more and more.
Bill
Worries you? Worries me ... :eek:
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?
Re: Attribute dropped with Category Change
Quote:
Originally Posted by
Ajeh
Worries you? Worries me ... :eek:
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:
Quote:
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
