Fatal error: Uncaught Exception: Error: Unknown column 'p.product_pdf' in 'field list'<br />Error No: 1054<br />
SELECT DISTINCT
*,
pd.name AS name,
p.image,
p.product_pdf,
m.name AS manufacturer,
(SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = '1'
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC
LIMIT 1) AS discount,
(SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC
LIMIT 1) AS special,
(SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id
AND pr.customer_group_id = '1') AS reward,
(SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id
AND ss.language_id = '3') AS stock_status,
(SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id
AND wcd.language_id = '3') AS weight_class,
(SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id
AND lcd.language_id = '3') AS length_class,
(SELECT AVG(r1.rating)
FROM oc_review r1
WHERE r1.product_id = p.product_id
AND r1.status = '1') AS rating,
(SELECT COUNT(*)
FROM oc_review r2
WHERE r2.product_id = p.product_id
AND r2.status = '1') AS reviews,
p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd
ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s
ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m
ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7968'
AND pd.language_id = '3'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
in /home/totalarmenia/public_html/system/library/db/mysqli.php:49
Stack trace:
#0 /home/totalarmenia/storage/modification/system/library/db.php(55): DB\MySQLi->query('\n SE...')
#1 /home/totalarmenia/storage/modification/catalog/model/catalog/product.php(15): DB->query('\n SE...')
#2 /home/totalarmenia/storage/modification/system/engine/loader.php(256): ModelCatalogProduct->getProduct(7968)
#3 /home/totalarmenia/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/totalarmenia/storage/modification/catalog/controller/product/product.php(172): Proxy->__call('getProduct', Array)
#5 /home/totalarmenia/storage/modification/system/engine/action.php(79): ControllerProductProduct->index()
#6 /home/totalarmenia/public_html/catalog/controller/startup/router.php(27): Action->execute(Object(Registry))
#7 /home/totalarmenia/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index()
#8 /home/totalarmenia/storage/modification/system/engine/router.php(134): Action->execute(Object(Registry))
#9 /home/totalarmenia/storage/modification/system/engine/router.php(123): Router->execute(Object(Action))
#10 /home/totalarmenia/public_html/system/framework.php(179): Router->dispatch(Object(Action), Object(Action))
#11 /home/totalarmenia/public_html/system/startup.php(104): require_once('/home/totalarme...')
#12 /home/totalarmenia/public_html/index.php(17): start('catalog')
#13 {main}
thrown in /home/totalarmenia/public_html/system/library/db/mysqli.php on line 49