Hi
I'm view website with flexible overrides.
index.php?option=com_virtuemart&view=category&virtuemart_category_id=XX
I have an error sql when searching logos of manufacturers.
If I disable manufacturers logo, it's ok but when the query have to join manufacturers table, then it crashes.
$query
->select($db->quoteName('a.file_url'))
->from($db->quoteName('#__virtuemart_medias', 'a'))
->join('INNER', $db->quoteName('#__virtuemart_manufacturer_medias', 'b') . ' ON (' . $db->quoteName('b.virtuemart_manufacturer_id') . ' = '. $product->virtuemart_manufacturer_id[0].')')
->where($db->quoteName('a.virtuemart_media_id') . ' = '.$db->quoteName('b.virtuemart_media_id'));
$db->setQuery($query);
Because $product->virtuemart_manufacturer_id[0] is not always set !