Author Topic: Deleting product variant creates a "ghost"  (Read 822 times)

dslove

  • Jr. Member
  • **
  • Posts: 51
Deleting product variant creates a "ghost"
« on: December 15, 2016, 16:49:03 pm »
Hi,
Deleting a multivariant has removed the child product itself, but not the variant from the Parent product. Also, now it is impossible to save any changes to the parent product:

Error
vmError: VmTable #__virtuemart_products_el_gr Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 1087
vmError: You are not an administrator or the correct vendor, storing of product cancelled

In the attachment you can see the "ghost" of the variant. I cannot find this anywhere in the database to try and remove it manually. I have cleaned website & browser cache multiple times but without any success.

Joomla 3.6.5
VM 3.0.18.6
PHP 5.6.21
MySQL 5.6.34

dslove

  • Jr. Member
  • **
  • Posts: 51
Re: Deleting product variant creates a "ghost"
« Reply #1 on: December 20, 2016, 10:17:32 am »
Any suggestions as to where in the database should I look to remove the "ghost" variant?

dslove

  • Jr. Member
  • **
  • Posts: 51
Re: Deleting product variant creates a "ghost"
« Reply #2 on: January 11, 2017, 11:24:43 am »
Hi, any suggestions as to where in the database should I look to remove the "ghost" variant?
It has been a full month we have this issue. Should I purchase a membership to have this looked into?

Studio 42

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2135
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Deleting product variant creates a "ghost"
« Reply #3 on: January 14, 2017, 01:17:49 am »
Do a backup and try the last beta release.
I think that the code is missing and don't check about this, perhaps some dev have added it since?
Another solution is perhaps to remove the multivariant custom field and save you product and readd multivariant  annd all  the variant again.

David

  • Beginner
  • *
  • Posts: 39
Re: Deleting product variant creates a "ghost"
« Reply #4 on: February 22, 2017, 05:36:43 am »
I have the same issue as dslove.
Joomla 3.6.5 , VirtueMart 3.2.1

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9161
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Deleting product variant creates a "ghost"
« Reply #5 on: February 24, 2017, 08:03:31 am »
Hi,
Deleting a multivariant has removed the child product itself, but not the variant from the Parent product. Also, now it is impossible to save any changes to the parent product:
I have big problems to understand this. "Deleting a multivariant " means for me, you removed the customfield "Multivariant" from the parent. But I think you mean, that you deleted the child, right? The deleted child is still listed in the multivariant of the parent. Storing the parent should automatically remove the ghost variant.

Error
vmError: VmTable #__virtuemart_products_el_gr Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 1087
vmError: You are not an administrator or the correct vendor, storing of product cancelled
[/quote]
As your attachment shows, there are no names for the product, so it tries to store the non existing product with an empty name.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9161
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Deleting product variant creates a "ghost"
« Reply #6 on: February 24, 2017, 13:54:54 pm »
Thank you, found the error, fixed.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/