SELECT virtuemart_media_id, file_title, file_url, file_is_product_image
FROM #__virtuemart_medias
WHERE file_type = 'product'
ORDER BY virtuemart_media_id DESC
LIMIT 10;Results show file_title with incorrect extensions and file_is_product_image = 0.UPDATE `#__virtuemart_medias`
SET `file_is_product_image` = 1
WHERE `file_type` = 'product'
AND `file_mimetype` LIKE 'image/%'
AND `file_is_product_image` = 0;UPDATE `#__virtuemart_medias`
SET `file_title` = REGEXP_REPLACE(`file_title`, '\\.(jpg|jpeg|png|gif|webp)_[0-9]+$', '.$1')
WHERE `file_title` REGEXP '\\.(jpg|jpeg|png|gif|webp)_[0-9]+$'
AND `file_type` = 'product';Questions: // Reindex cart products to ensure sequential keys starting from 0 by Kuubs
if (isset($cart->products) && is_array($cart->products)) {
$cart->products = array_values($cart->products);
}
vDispatcher::trigger('plgVmOnUpdateCart',array(&$cart, &$force, &$html));
Quote from: drejk on December 09, 2021, 11:03:29 AMSolution is to slightly modify a line in administrator/components/com_virtuemart/helpers/vmtable.php:
a) comment out line aroud line 1570 (add // in front) - this fixes links (this line shouldn't be there anyways. Btw. "$unicodeslugs" is practically the opposite of what it is called - it should be called "$transliterate" )
//if($unicodeslugs)$this->{$slugName} = rawurlencode($this->{$slugName});
b) optional - if you want only alphanumeric characters, dashes and underscores add at next line
$this->{$slugName} = preg_replace('~[^-a-z0-9_]+~', '', $this->{$slugName});
Page created in 0.063 seconds with 13 queries.