Exception

HTTP 500 Whoops, looks like something went wrong.

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 240,48

Exception

Exception

  1.                 return $result;
  2.             } else {
  3.                 return true;
  4.             }
  5.         } else {
  6.             throw new \Exception('Error: ' $this->connection->error  '<br />Error No: ' $this->connection->errno '<br />' $sql);
  7.         }
  8.     }
  9.     public function escape($value) {
  10.         return $this->connection->real_escape_string($value);
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 240,48') in /home/web5/str-mobile.ru/www/system/library/db.php (line 45)
  1.      * @param    string    $sql
  2.      * 
  3.      * @return    array
  4.      */
  5.     public function query($sql) {
  6.         return $this->adaptor->query($sql);
  7.     }
  8.     /**
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 240,48') in /home/web5/str-mobile.ru/storage/modification/catalog/model/catalog/product.php (line 433)
  1.                             }
  2.                         }
  3.                     }
  4.                 }
  5.             
  6.         $query $this->db->query($sql);
  7.         foreach ($query->rows as $result) {
  8.             $product_data[$result['product_id']] = $this->getProduct($result['product_id']);
  9.         }
ModelCatalogProduct->getProductSpecials(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 240, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true)) in /home/web5/str-mobile.ru/storage/modification/system/engine/loader.php (line 267)
  1.                 $method substr($routestrrpos($route'/') + 1);
  2.                 
  3.                 $callable = array($model[$key], $method);
  4.     
  5.                 if (is_callable($callable)) {
  6.                     $output call_user_func_array($callable$args);
  7.                 } else {
  8.                     throw new \Exception('Error: Could not call model/' $route '!');
  9.                 }                    
  10.             }
  11.             
Loader->{closure}(array(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 240, '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' => 240, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true))) in /home/web5/str-mobile.ru/www/system/engine/proxy.php (line 47)
  1.                 $arg_data[] =& $arg;
  2.             }
  3.         }
  4.         
  5.         if (isset($this->{$key})) {        
  6.             return call_user_func_array($this->{$key}, $arg_data);    
  7.         } else {
  8.             $trace debug_backtrace();
  9.             
  10.             exit('<b>Notice</b>:  Undefined property: Proxy::' $key ' in <b>' $trace[1]['file'] . '</b> on line <b>' $trace[1]['line'] . '</b>');
  11.         }
Proxy->__call('getProductSpecials', array('getProductSpecials', array(array('filter_category_id' => 0, 'filter_sub_category' => false, 'sort' => 'ps.price', 'order' => 'DESC', 'start' => 240, 'limit' => 48, 'mfp_overwrite_path' => true, 'mfp_enabled' => true)))) in /home/web5/str-mobile.ru/storage/modification/catalog/controller/product/special.php (line 173)
  1.                 $filter_data['mfp_overwrite_path'] = true;
  2.                 $filter_data['mfp_enabled'] = true;
  3.             
  4.         $product_total $this->model_catalog_product->getTotalProductSpecials();
  5.         $results $this->model_catalog_product->getProductSpecials($filter_data);
  6.         foreach ($results as $result) {
  7.             if ($result['image']) {
  8.                 $image $this->model_tool_image->resize($result['image'], $this->config->get('theme_' $this->config->get('config_theme') . '_image_product_width'), $this->config->get('theme_' $this->config->get('config_theme') . '_image_product_height'));
  9.                     $popup 
  1.             if (defined("IS_DEBUG") && IS_DEBUG) {
  2.                       global $debugControllerActions;
  3.                       $time microtime(true);
  4.                       $call_func call_user_func_array(array($controller$this->method), $args);
  5.                       $debugControllerActions[] = [
  6.                           'class' => get_class($controller),
  7.                           'method' => $this->method,
  8.                           'time' => microtime(true) - $time,
Action->execute(object(Registry)) in /home/web5/str-mobile.ru/www/system/engine/router.php (line 67)
  1.      *
  2.      * @param    object    $action
  3.      * @return    object
  4.      */
  5.     private function execute(Action $action) {
  6.         $result $action->execute($this->registry);
  7.         if ($result instanceof Action) {
  8.             return $result;
  9.         } 
  10.         
Router->execute(object(Action)) in /home/web5/str-mobile.ru/www/system/engine/router.php (line 56)
  1.                 break;
  2.             }
  3.         }
  4.         while ($action instanceof Action) {
  5.             $action $this->execute($action);
  6.         }
  7.     }
  8.     
  9.     /**
  10.      * 
Router->dispatch(object(Action), object(Action)) in /home/web5/str-mobile.ru/www/system/framework.php (line 177)
  1.         $route->addPreAction(new Action($value));
  2.     }
  3. }
  4. // Dispatch
  5. $route->dispatch(new Action($config->get('action_router')), new Action($config->get('action_error')));
  6. // Output
  7. $response->output();
require_once('/home/web5/str-mobile.ru/www/system/framework.php') in /home/web5/str-mobile.ru/www/system/startup.php (line 108)
  1. // Helper
  2. require_once(DIR_SYSTEM 'helper/general.php');
  3. require_once(DIR_SYSTEM 'helper/utf8.php');
  4. function start($application_config) {
  5.     require_once(DIR_SYSTEM 'framework.php');    
  6. }
start('catalog') in /home/web5/str-mobile.ru/www/index.php (line 24)
  1. // Startup
  2. require_once(DIR_SYSTEM 'startup.php');
  3. start('catalog');
  4. //require_once('debug_after_index.php');

Stack Trace

Exception

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 240,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 240,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 240,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' => 240, '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' => 240, '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' => 240, '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' => 240, '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)