Author Topic: vmError: VmTable #__virtuemart_products_nl_nl Check not passed  (Read 1538 times)

comfix

  • Beginner
  • *
  • Posts: 1
  • A beginner
vmError: VmTable #__virtuemart_products_nl_nl Check not passed
« on: February 01, 2020, 13:06:26 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9897
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: vmError: VmTable #__virtuemart_products_nl_nl Check not passed
« Reply #1 on: February 02, 2020, 13:13:07 pm »
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

Code: [Select]
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation