SELECT SQL_CALC_FOUND_ROWS p.virtuemart_product_id, l.product_name, l.product_s_desc, l.product_desc
FROM w2f9n3p4_virtuemart_products as p
LEFT JOIN w2f9n3p4_virtuemart_products_es_es as l ON l.virtuemart_product_id = p.virtuemart_product_id
LEFT JOIN w2f9n3p4_virtuemart_product_shoppergroups as ps ON p.virtuemart_product_id = ps.virtuemart_product_id
LEFT JOIN w2f9n3p4_virtuemart_product_categories as pc ON p.virtuemart_product_id = pc.virtuemart_product_id
LEFT JOIN w2f9n3p4_virtuemart_categories as c ON c.virtuemart_category_id = pc.virtuemart_category_id
LEFT JOIN w2f9n3p4_virtuemart_categories_es_es as cl ON cl.virtuemart_category_id = pc.virtuemart_category_id
WHERE (
(
l.product_name LIKE "%Safety%Helmet%"
OR p.product_sku LIKE "%Safety%Helmet%"
OR l.product_s_desc LIKE "%Safety%Helmet%"
OR l.product_desc LIKE "%Safety%Helmet%"
OR category_name LIKE "%Safety%Helmet%"
OR category_description LIKE "%Safety%Helmet%"
)
AND c.published = 1
AND (
ps.virtuemart_shoppergroup_id= "1"
OR ps.virtuemart_shoppergroup_id IS NULL
)
AND p.published="1"
)
group by p.virtuemart_product_id
ORDER BY p.product_sku ASC, p.virtuemart_product_id ASC
LIMIT 20WHERE MATCH(l.product_name, l.product_s_desc, l.product_desc, category_name, category_description)
AGAINST ('+Safety +Helmet' IN BOOLEAN MODE)$terms = explode(' ', $search);
foreach ($terms as $t) {
$where .= " OR (l.product_name LIKE '%$t%' OR ... )";
}
vmError: VmPlugin function createPlugin, class does not exist Plgvmcustomstockablecustomfields vmcustom stockablecustomfieldsI suspect that somewhere in the database some traces of the removed plugin are still around, but was unsuccessful in tracking down the respective records. There are no files left, and nothing remained in the extensions table either. It is a big shop, with tens of thousands of products, and more, than 300 VM custom fields set up, so checking one-by-one the entries is out of question.
Last version from date 12/15/2025 and repository https://dev.virtuemart.net/projects/virtuemart/repository down to see updates/fixes...Page created in 0.049 seconds with 13 queries.