Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'iconlive.prices' doesn' in /var/www/b2b/system/library/db/mysqli.php on line 40
Exception: Error: Table 'iconlive.prices' doesn't exist
Error No: 1146
SELECT DISTINCT *, p.maxqty as mqty, p.description AS name, d.name as nameov,
(
SELECT
price
FROM
prices pd2
WHERE
pd2.stockid = p.stockid
AND pd2.typeabbrev = 'A1'
AND NOW() BETWEEN pd2.startdate AND pd2.enddate
limit 1
) AS price,
(
SELECT
price
FROM
pricematrix ps
WHERE
ps.stockid = p.stockid
AND ps.salestype = 'A1'
AND (
NOW() BETWEEN ps.startdate AND ps.startdate
)
ORDER BY
ps.price ASC
LIMIT 1
) AS special
FROM
stockmaster p
LEFT JOIN product_description d on p.stockid = d.stockid
LEFT JOIN purchdata on p.stockid = purchdata.stockid
WHERE
p.stockid = 'QNSKQUA290' in /var/www/b2b/system/library/db/mysqli.php on line 40
Call Stack:
0.0000 235296 1. {main}() /var/www/b2b/index.php:0
0.0010 351992 2. start() /var/www/b2b/index.php:32
0.0010 353696 3. require_once('/var/www/b2b/system/framework.php') /var/www/b2b/system/startup.php:130
0.0043 540016 4. Front->dispatch() /var/www/b2b/system/framework.php:119
0.0102 962088 5. Front->execute() /var/www/b2b/system/engine/front.php:28
0.0102 962088 6. Action->execute() /var/www/b2b/system/engine/front.php:33
0.0103 966296 7. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51
0.0103 966680 8. ControllerStartupRouter->index() /var/www/b2b/system/engine/action.php:51
0.0104 967560 9. Action->execute() /var/www/b2b/catalog/controller/startup/router.php:25
0.0104 974416 10. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51
0.0104 980200 11. ControllerProductProduct->index() /var/www/b2b/system/engine/action.php:51
0.0213 1146048 12. Proxy->getProduct() /var/www/b2b/catalog/controller/product/product.php:185
0.0213 1146576 13. Proxy->__call() /var/www/b2b/catalog/controller/product/product.php:185
0.0213 1147888 14. call_user_func_array:{/var/www/b2b/system/engine/proxy.php:25}() /var/www/b2b/system/engine/proxy.php:25
0.0213 1149416 15. Loader->{closure:/var/www/b2b/system/engine/loader.php:153-197}() /var/www/b2b/system/engine/proxy.php:25
0.0218 1151184 16. call_user_func_array:{/var/www/b2b/system/engine/loader.php:184}() /var/www/b2b/system/engine/loader.php:184
0.0218 1152896 17. ModelCatalogProduct->getProduct() /var/www/b2b/system/engine/loader.php:184
0.0219 1154520 18. DB->query() /var/www/b2b/catalog/model/catalog/product.php:262
0.0219 1154656 19. DB\MySQLi->query() /var/www/b2b/system/library/db.php:16