Каталог товаров
Обратный звонок
Оставьте ваши контактные данные
Zend Framework Default Application

An error occurred

Application error

Exception information:

Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.stock' in 'order clause', query was: SELECT `p`.`id`, `p`.`name`, `p`.`currency`, `p`.`url`, `p`.`count`, `p`.`sku_count`, `p`.`category_id`, `p`.`image_id`, `p`.`ext`, `p`.`min_price`, `p`.`price`, `p`.`compare_price`, `p`.`max_price`, `p`.`rating`, `p`.`rating_count`, `p`.`description`, `p`.`summary`, `p`.`sku_id` FROM `shop_product` AS `p` INNER JOIN `shop_category_products` AS `cp` ON p.id = cp.product_id WHERE (cp.category_id IN (616)) AND (p.status = 1 OR p.status = 2) GROUP BY `p`.`id` ORDER BY `p`.`stock` ASC LIMIT 12

Stack trace:

#0 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `p`.`id`...', Array)
#3 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Db/Select.php(686): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#4 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Paginator/Adapter/DbSelect.php(170): Zend_Db_Select->query()
#5 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Paginator.php(797): Zend_Paginator_Adapter_DbSelect->getItems(0, 12)
#6 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Paginator.php(626): Zend_Paginator->getItemsByPage(1)
#7 /var/www/eltorg/data/www/electrotorg.biz.ua/application/modules/frontend/controllers/CategoryController.php(105): Zend_Paginator->getCurrentItems()
#8 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Controller/Action.php(516): CategoryController->viewAction()
#9 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('viewAction')
#10 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#11 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
#12 /var/www/eltorg/data/www/electrotorg.biz.ua/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#13 /var/www/eltorg/data/www/electrotorg.biz.ua/public_html/index.php(36): Zend_Application->run()
#14 {main}  

Request Parameters:

array (
  'category' => 'parkovye-svetilniki',
  'module' => 'seoFilter',
  'controller' => 'frontend',
  'action' => 'seo-filter-route',
  'sort' => 'stock',
  'order' => 'desc',
)  
Обратная связь
Заказатьв 1 клик