News:

Looking for documentation? Take a look on our wiki

Main Menu

vmError: VmTable #__virtuemart_products_nl_nl Check not passed

Started by comfix, February 01, 2020, 13:06:26 PM

Previous topic - Next topic

comfix

I have an issue where I have some ghost products within a parent product which I cannot delete nor change/use. From 2081 - 2085.



So I tried to look in the db to see if I can find the product ID and delete it, but it cannot be found.  :-\

Changing the product via the multivariant gives me the error below (even tried to migrate vendor, update tables,..):

vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2081
vmError: You are not an administrator or the correct vendor, storing of product cancelled
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2083
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2082
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2084
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2085
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2109


When I open the product itself and add info like name, alias,... (the required stuff), it saves it with a new ID.

Anyone have an idea how to delete these ID's?

GJC Web Design

if the pids really don't exist in the product tables then ( is this a migration?) they might be still listed in the product_customfields table for that product

multvars are listed in a json format with the child ids

selectoptions=[
    {
        "voption": "clabels",
        "clabel": "Colour",
        "values": "Red\r\nGreen\r\nBlue"
    },
    {
        "voption": "clabels",
        "clabel": "Size",
        "values": "S\r\nM\r\nL"
    }
]|options={
    "2071": [
        "",
        ""
    ],
    "2072": [
        "Red",
        "S"
    ],
    "2073": [
        "Red",
        "M"
    ],
    "2074": [
        "Red",
        "L"
    ],
    "2075": [
        "Green",
        "S"
    ],
    "2076": [
        "Green",
        "M"
    ],
    "2077": [
        "Green",
        "L"
    ],
    "2078": [
        "Blue",
        "S"
    ],
    "2079": [
        "Blue",
        "M"
    ],
    "2080": [
        "Blue",
        "L"
    ]
}|
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation