vmError: Could not find product with id 100, entries exists for language? en-GB

Started by LP Webdesign, June 16, 2020, 23:32:45 PM

Previous topic - Next topic

Jörgen

Nice clue, Rudolf.

table: virtuemart_customs

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

LP Webdesign

Quote from: pinochico on June 22, 2020, 17:05:21 PM
You must find in customfield table, where is connection between parent and child.

Dou you search there?

Thank you for your reply.

I checked both tables:
virtuemart_customs
virtuemart_product_customfields

But both are empty.


Kind regards,
Laurens

LP Webdesign

Fixed by adding a random product with ID of 100 to table virtuemart_products & virtuemart_products_en_gb.

Jörgen

Do you have only one language ?

Was it an image that pointed to this item ? Or what was it ?

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

pinochico

www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

LP Webdesign

Quote from: Jörgen on June 30, 2020, 17:28:47 PM
Do you have only one language ?

Was it an image that pointed to this item ? Or what was it ?

Jörgen @ Kreativ Fotografi

I have multiple languages, but still don't know what exactly caused the error.

finbarr69

I found this on a customer's website.  It turned out to be that the owner had deleted some products, but those products had been set as "related products" of another product.  Seems like a bit of a bug here.  If a product is deleted, it should be removed as a related product.

Hope that helps. :-)

Brian

sirius

Quote from: finbarr69 on July 21, 2020, 00:49:03 AM
I found this on a customer's website.  It turned out to be that the owner had deleted some products, but those products had been set as "related products" of another product.  Seems like a bit of a bug here.  If a product is deleted, it should be removed as a related product.

Hope that helps. :-)

Brian
Hi Brian, hi all,

Agree, I had same issue, and did some SQL queries to clean up all related orphans products.
And also don't forget that if you delete a product, you or a customer that have an orders with this product involved, will get a "vmerror notice" for this on login.
This should be corrected in a future version.
J3.10.12 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

Planet Bodo

Hey there,
i know its an old topic but i search here my problem too and for all the people who come behind me...

For me was the problem that ill use the Products in a Dynamic Content Field and choose it there by hand before ill erase the products
If ill change the products in the dynamic content field the error wasnt shown anymore


sirius

Hi
just look for related product type with id 100 in the content in custom fields table

Edit: For those who need the query, I use this to find all unpublished complementary products that are attributed to products
Code (sql) Select
SELECT  a.*
FROM    `m2db5_virtuemart_products` a
            LEFT JOIN `m2db5_virtuemart_product_customfields` b
                ON a.`virtuemart_product_id` = b.`customfield_value`
                WHERE b.`virtuemart_custom_id` = 1 AND a.`published` = 0

J3.10.12 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

Vsevlod

I had the same problem after deleting some products. For my case, this error was displayd because of VM module "Recently viewed" for products that I had opened before deleting. When I opened site in brauser safe mode - error didn't display.

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers [url="https://www.gjcwebdesign.com"]https://www.gjcwebdesign.com[/url]
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
[url="https://extensions.joomla.org/profile/profile/details/67210"]https://extensions.joomla.org/profile/profile/details/67210[/url]
Contact for any VirtueMart or Joomla development & customisation