Bug on child product delete Vm 4.2.2

[niosme]

When we delete a child product it always this child product not deleted from the fields in database and always throws an error
e.g we have a product with id 1
and 4 child procuts with id's 2,3,4,5

When we go to delete the product e.g. with id 5 then everytime it throws the following error:

vmError: Empty slug product with id 5, entries exists for language? el-GR.  (or en-GB) langugage dont make any difference on that

Then we must go to edit the table from mysql by hand because
inside the
##_virtuemart_product_customfields

on the custom field params it remains like that

Code Select Expand


selectoptions=[
    {
        "voption": "clabels",
        "clabel": "\u03a7\u03c1\u03ce\u03bc\u03b1",
        "values": "\u039c\u03b1\u03cd\u03c1\u03bf\/\u0393\u03ba\u03c1\u03b9\/\u039b\u03b5\u03c5\u03ba\u03cc\r\n\u0393\u03ba\u03c1\u03b9\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u03a0\u03bf\u03c1\u03c4\u03bf\u03ba\u03b1\u03bb\u03af\r\n\u039b\u03b5\u03c5\u03ba\u03cc\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u039a\u03cc\u03ba\u03ba\u03b9\u03bd\u03bf\r\n\u039b\u03b5\u03c5\u03ba\u03cc\/\u0393\u03ba\u03c1\u03b9\/\u039c\u03c0\u03bb\u03b5"
    }
]|options={
    "1": [
        "\u039c\u03b1\u03cd\u03c1\u03bf\/\u0393\u03ba\u03c1\u03b9\/\u039b\u03b5\u03c5\u03ba\u03cc"
    ],
    "2": [
        "\u0393\u03ba\u03c1\u03b9\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u03a0\u03bf\u03c1\u03c4\u03bf\u03ba\u03b1\u03bb\u03af"
    ],
    "3": [
        "\u039b\u03b5\u03c5\u03ba\u03cc\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u039a\u03cc\u03ba\u03ba\u03b9\u03bd\u03bf"
    ],
    "4": [
        "\u039b\u03b5\u03c5\u03ba\u03cc\/\u0393\u03ba\u03c1\u03b9\/\u039c\u03c0\u03bb\u03b5"
    ],
    "5": [
        "\u039b\u03b5\u03c5\u03ba\u03cc\/\u0393\u03ba\u03c1\u03b9\/\u039c\u03c0\u03bb\u03b5"
    ]
}|

Which contains the id 5 and we should manually delete it and make it like this

Code Select Expand


selectoptions=[
    {
        "voption": "clabels",
        "clabel": "\u03a7\u03c1\u03ce\u03bc\u03b1",
        "values": "\u039c\u03b1\u03cd\u03c1\u03bf\/\u0393\u03ba\u03c1\u03b9\/\u039b\u03b5\u03c5\u03ba\u03cc\r\n\u0393\u03ba\u03c1\u03b9\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u03a0\u03bf\u03c1\u03c4\u03bf\u03ba\u03b1\u03bb\u03af\r\n\u039b\u03b5\u03c5\u03ba\u03cc\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u039a\u03cc\u03ba\u03ba\u03b9\u03bd\u03bf\r\n\u039b\u03b5\u03c5\u03ba\u03cc\/\u0393\u03ba\u03c1\u03b9\/\u039c\u03c0\u03bb\u03b5"
    }
]|options={
    "1": [
        "\u039c\u03b1\u03cd\u03c1\u03bf\/\u0393\u03ba\u03c1\u03b9\/\u039b\u03b5\u03c5\u03ba\u03cc"
    ],
    "2": [
        "\u0393\u03ba\u03c1\u03b9\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u03a0\u03bf\u03c1\u03c4\u03bf\u03ba\u03b1\u03bb\u03af"
    ],
    "3": [
        "\u039b\u03b5\u03c5\u03ba\u03cc\/\u039c\u03b1\u03cd\u03c1\u03bf\/\u039a\u03cc\u03ba\u03ba\u03b9\u03bd\u03bf"
    ],
    "4": [
        "\u039b\u03b5\u03c5\u03ba\u03cc\/\u0393\u03ba\u03c1\u03b9\/\u039c\u03c0\u03bb\u03b5"
    ]
}|

Which is unacceptable.

Also the characters are saved in translated format. They should be in utf8 or something to be readable.

Please fix it asap!

[niosme]

Any support? Also opened ticket because have passed 15 days and have no answer on bugs.

[Milbo]

Just go to the parent product, and store it again, to update this. The line of the deleted product is removed. Could be better yes.

[niosme]

Going to the parent product and storing it again doesnt work.
The registration stays forever in the database.

It could be better or it should be right and be deleted instead of going to the db and delete it by hand?

[Milbo]

No, I tested it before I wrote that. In my case it works. I remember when I wrote the whole thing, I had to write a lot stuff to store it always right. For example if a product is missing. Or if you load it.
so if you load it and the product is missing, it should not be displayed and when you store it, it overrides the old stuff, always completly!

So please test again. Maybe you used 2 tabs. you deleted on one tab, stored with the other. That cant work!
you must, if you use 2 tabs, delete it on one tab. On the tab with the parent reload the page and THEN store it. I know it is not a cooool solution. But from my point of view an acceptable workaround. This problem is quite rare in real shops. My estimation, there is a store with 5000 multivariants and they use this 1-2 times a year.

I mean, I think you know, that the whole thing is dynamic. So for example if you use stocking and one product is without stock, it wont be displayed in the dropdowns anylonger. The whole data for the dropdowns is stored and if they are created, the not available products are filtered out.

So most shops wont need it. They may just set the product on unpublished, because they may use it later anyway. Your case only happens if someone created too many options, or so.

[niosme]

Problem still exists in the latest version.
If we make a product with child products and we use the multi variant, then we delete from the main list of products,when we click the parent it throws the "vmError: Empty slug product with id ##, entries exists for language el-GR" and it stays in the database.

No multiple tabs, no parallel saving, no nothing. Just delete a child product which is assign to multi variant from the parent.Then in the parent it throws that error.

[anihilator]

I can agree that this problem still persist in version 4.2.14.