[Probably Solved] Bug very annoying in 'product -> product sons' editing

[SteP[IT]]

The problem in VM 2.0.22a arises when you add and then rename a son inside a parent product.

To reproduce the problem:

1) add a new product
2) set up a generic son variant
3) add this variant to the product
4) add a son
5) save

At this stage, you get a random value for the product son name, and you get also the SKU field filled with that name
Now:

1) change the SKU of the product son
2) save

After that operation, you get both the SKU and the NAME changed by the value you placed into the SKU field.

To get the right SKU displayed, right now you must edit the son by clicking the link on the left of the son's list, and add the SKU (that is empty inside the son)

Could you please fix it? ...we use a lot of son

Thank you in advance
Regards

EDIT: also, if you try to change the product son name by filling the appropriate field inside the son's list, it has no effect when saving: the name remains unchanged

SECOND EDIT (31-07): in addition to the problem described above, after adding a new son, a further son can't be added, I get this error:
vmError: Database error: createChild Duplicate entry 'ideal-remote6094' for key 'slug' SQL=INSERT INTO `j25_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("617","ideal-remote6094");
where 'deal-remote6094' is the name of the latest son previously added

[SteP[IT]]

Any chance to get this fixed soon?
Thank you in advance

[agps]

I have the same problem in a new installation

[Milbo]

i need someone of you in skype and then you must show me via screenshare, atm I was not able to reproduce

[agps]

Please check your pms.

The screen shot is after product save.

[attachment cleanup by admin]

[Milbo]

agps, you have a different problem, which is solved. Please look here http://forum.virtuemart.net/index.php?topic=114891.msg398711#msg398711

[agps]

Thanks but I have already uninstalled the 2.0.22a and I have installed 2.0.20b and everything works perfect!

[Milbo]

2.0.22a is definitly better. the error is also fixed.

[agps]

Could you please watch the following video?

http://vimeo.com/72582462

Why after save the child products alter their names?

[attachment cleanup by admin]

[Milbo]

Thanks to your video, I found it

just replace in file product_edit_information (BE view product) at line 383 the code

Code Select Expand


$attrib = 'product_name';
$childAttrib = $child->$attrib;


to

Code Select Expand


$childAttrib = $child->product_name;


[agps]

Thanks

[SteP[IT]]

Hi Milbo

Your solution seems not working for me (VM 2.0.22b).

So I have made this change to the line 379 of that file to get it working as expected:

Original Line:

Code Select Expand

if(isset($child->$attrib)){


Changed to:

Code Select Expand

if((isset($child->$attrib)) || ($attrib =='product_sku')){


Could you please confirm that it's a right modding?

Thank you in advance
Regards

[Limonbay]

Using the last mentioned solution I cannotsee the products in the backoffice.

The problem of getting an error when creating a child product remains. :-(

[MarioP]

I still have similar errors when I create children products. Has anybody encountered that strange behavior?

Code Select Expand

2013-12-27 14:19:42 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1688' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("241","pss-midi-stereo1688");
2013-12-27 22:08:34 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1688' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("242","pss-midi-stereo1688");
2013-12-27 22:09:23 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("243","pss-midi-stereo1685");
2013-12-27 22:10:19 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("247","pss-midi-stereo1685");
2013-12-27 22:11:57 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1688' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("248","pss-midi-stereo1688");
2013-12-27 22:13:53 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("250","pss-midi-stereo1685");
2013-12-27 22:15:35 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1682' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("253","pss-midi-stereo1682");
2013-12-27 22:15:53 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("254","pss-midi-stereo1685");
2013-12-27 22:16:48 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1684' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("256","pss-midi-stereo1684");
2013-12-27 22:17:02 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1684' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("257","pss-midi-stereo1684");
2013-12-27 22:17:16 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("258","pss-midi-stereo1685");
2013-12-27 22:17:49 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1688' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("260","pss-midi-stereo1688");
2013-12-27 22:18:01 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1682' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("261","pss-midi-stereo1682");
2013-12-27 22:27:28 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1684' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("266","pss-midi-stereo1684");
2013-12-27 22:37:24 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1681' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("267","pss-midi-stereo1681");
2013-12-27 22:40:24 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1679' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("272","pss-maxi-stereo1679");
2013-12-30 07:13:27 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1677' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("276","pss-maxi-stereo1677");
2013-12-30 07:15:00 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1678' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("279","pss-maxi-stereo1678");
2013-12-30 07:17:38 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1676' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("283","pss-maxi-stereo1676");
2013-12-30 07:21:01 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1678' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("286","pss-maxi-stereo1678");
2013-12-30 07:24:18 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1673' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("287","pss-maxi-stereo1673");
2013-12-30 07:25:02 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1678' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("288","pss-maxi-stereo1678");
2013-12-30 07:25:36 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1674' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("290","pss-maxi-stereo1674");
2013-12-30 07:28:33 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1675' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("295","pss-maxi-stereo1675");
2013-12-30 07:29:05 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1671' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("298","pss-maxi-stereo1671");
2014-01-02 09:23:31 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("299","pss-midi-stereo1685");
2014-01-02 11:52:52 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1685' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("302","pss-midi-stereo1685");
2014-01-02 12:25:05 ERROR vmError: Database error: createChild Duplicate entry 'pss-midi-stereo1681' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("303","pss-midi-stereo1681");
2014-01-02 13:38:05 ERROR vmError: Database error: createChild Duplicate entry 'pss-maxi-stereo1676' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("307","pss-maxi-stereo1676");
2014-01-02 14:05:29 ERROR vmError: Database error: createChild Duplicate entry 'pss-mini-stereo1693' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("315","pss-mini-stereo1693");
2014-01-02 14:07:42 ERROR vmError: Database error: createChild Duplicate entry 'pss-mini-stereo1695' for key 'slug' SQL=INSERT INTO `xxxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES ("316","pss-mini-stereo1695");
I can't find the rule. It's enough to create more than 3 child product and the problem shows up. Despite the error the new child product is created. Is there everything ok? I have a multilanguage site.