Fatal error: Uncaught Exception: Error: Table 'stkildastore_opencart.oc_product_option_image' doesn't exist<br />Error No: 1146<br />SELECT oc_product.product_id,
oc_product_description.name,
oc_product.image AS baseImage,
COALESCE(IF(LENGTH(oc_product_option_image.option_image)>3,oc_product_option_image.option_image,NULL),oc_product.image) AS image,
(SELECT oc_category_description.name FROM oc_product_to_category INNER JOIN oc_category ON oc_category.category_id = oc_product_to_category.category_id INNER JOIN oc_category_description ON oc_category_description.category_id = oc_category.category_id WHERE oc_product_to_category.product_id = oc_product.product_id LIMIT 1 ) AS min_category_id
FROM oc_option_value
INNER JOIN oc_option_value_description ON oc_option_value_description.option_value_id = oc_option_value.option_value_id
INNER JOIN oc_option ON oc_option.option_id = oc_option_value.option_id
INNER JOIN oc_product_option ON oc_product_option.option_id = oc_option.option_id
INNER JOIN oc_product ON oc_product.product_id = oc_product_option.product_id
INNER JOIN oc_product_description ON oc_product_description.product_id = oc_product.product_id
INNER JOIN oc_product_option_value ON oc_product_option_value.product_id = oc_product.product_id AND oc_product_option_value.option_value_id = oc_option_value.option_value_id
LEFT JOIN oc_product_option_image ON oc_product_option_image.product_option_value_id = oc_product_option_value.product_option_value_id
WHERE oc_option_value_description.NAME = 'Fraser'
AND oc_product.status = 1
UNION
SELECT oc_product.product_id,
oc_product_description.name,
oc_product.image,
oc_product.image,
(SELECT oc_category_description.name FROM oc_product_to_category INNER JOIN oc_category ON oc_category.category_id = oc_product_to_category.category_id INNER JOIN oc_category_description ON oc_category_description.category_id = oc_category.category_id WHERE oc_product_to_category.product_id = oc_product.product_id LIMIT 1 ) AS min_category_id
FROM oc_product
INNER JOIN oc_product_description ON oc_product_description.product_id = oc_product.product_id
WHERE oc_product_description.NAME LIKE '% clan Fraser%'
AND oc_product.status = 1
ORDER BY 5,1 in /var/www/vhosts/stkildastore.com/httpdocs/store/system/library/db/mysqli.php:48
Stack trace:
#0 /var/www/vhosts/stkildastore.com/storage/modification/system/library/db.php(55): DB\MySQLi->query()
#1 /var/www/vhosts/stkildastore.com/httpdocs/store/catalog/model/clan/product.php(125): DB->query()
#2 /var/www/vhosts/stkildastore.com/storage/modification/system/engine/loader.php(256): ModelClanProduct->getClanProducts()
#3 /var/www/vhosts/stkildastore.com/httpdocs/store/system/engine/proxy.php(47): Loader->{closure}()
#4 /var/www/vhosts/stkildastore.com/httpdocs/store/catalog/controller/clan/products.php(82): Proxy->__call()
#5 /var/www/vhosts/stkildastore.com/storage/modification/system/engine/action.php(79): ControllerClanProducts->index()
#6 /var/www/vhosts/stkildastore.com/httpdocs/store/catalog/controller/startup/router.php(25): Action->execute()
#7 /var/www/vhosts/stkildastore.com/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index()
#8 /var/www/vhosts/stkildastore.com/storage/modification/system/engine/router.php(134): Action->execute()
#9 /var/www/vhosts/stkildastore.com/storage/modification/system/engine/router.php(123): Router->execute()
#10 /var/www/vhosts/stkildastore.com/httpdocs/store/system/framework.php(169): Router->dispatch()
#11 /var/www/vhosts/stkildastore.com/httpdocs/store/system/startup.php(104): require_once('...')
#12 /var/www/vhosts/stkildastore.com/httpdocs/store/index.php(19): start()
#13 {main}
thrown in /var/www/vhosts/stkildastore.com/httpdocs/store/system/library/db/mysqli.php on line 48