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

[Jörgen]

Nice clue, Rudolf.

table: virtuemart_customs

Jörgen @ Kreativ Fotografi

[LP Webdesign]

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

[pinochico]

that was a test if we are ready 

[LP Webdesign]

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]

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.

[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 Expand

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

[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]

Ah yes ... because recent is stored in the session