Exception:
Error: Unknown column 'ps.price' in 'order clause'<br />Error No: 1054<br />SELECT p.product_id FROM oc_product p WHERE p.price>0 AND isbn=1 AND p.jan <> 5 AND p.jan > 0 ORDER BY (p.quantity > 0) DESC, ps.price DESC LIMIT 144,48
at /home/web5/str-mobile.ru/storage/modification/system/library/db/mysqli.php:67
at DB\MySQLi->query('SELECT p.product_id FROM oc_product p WHERE p.price>0 AND isbn=1 AND p.jan <> 5 AND p.jan > 0 ORDER BY (p.quantity > 0) DESC, ps.price DESC LIMIT 144,48')
(/home/web5/str-mobile.ru/www/system/library/db.php:45)
at DB->query('SELECT p.product_id FROM oc_product p WHERE p.price>0 AND isbn=1 AND p.jan <> 5 AND p.jan > 0 ORDER BY (p.quantity > 0) DESC, ps.price DESC LIMIT 144,48')
(/home/web5/str-mobile.ru/storage/modification/catalog/model/catalog/product.php:433)
at ModelCatalogProduct->getProductSpecials(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 144, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true))
(/home/web5/str-mobile.ru/storage/modification/system/engine/loader.php:267)
at Loader->{closure}(array(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 144, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true)), array(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 144, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true)))
(/home/web5/str-mobile.ru/www/system/engine/proxy.php:47)
at Proxy->__call('getProductSpecials', array('getProductSpecials', array(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 144, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true))))
(/home/web5/str-mobile.ru/storage/modification/catalog/controller/product/special.php:173)
at ControllerProductSpecial->index()
(/home/web5/str-mobile.ru/storage/modification/system/engine/action.php:84)
at Action->execute(object(Registry))
(/home/web5/str-mobile.ru/www/system/engine/router.php:67)
at Router->execute(object(Action))
(/home/web5/str-mobile.ru/www/system/engine/router.php:56)
at Router->dispatch(object(Action), object(Action))
(/home/web5/str-mobile.ru/www/system/framework.php:177)
at require_once('/home/web5/str-mobile.ru/www/system/framework.php')
(/home/web5/str-mobile.ru/www/system/startup.php:108)
at start('catalog')
(/home/web5/str-mobile.ru/www/index.php:24)
|