PDOException making GET request to /cards/personalise/view/44

42000 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY prices.quantity ASC' at line 10

Stacktrace ?

• PDOStatement->execute [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Db/Adapter/Abstract.php, line 156]
  ? Args

  Arg	Name	Value
  0	$bound_input_params	array ( )

  ? Src
  151.         }
  153.         // prepare and execute the statement with profiling
  154.         $stmt = $this->prepare($sql);
  155.         $q = $this->_profiler->queryStart($sql);
  156.         $stmt->execute((array) $bind);
  157.         $this->_profiler->queryEnd($q);
  159.         // return the results embedded in the prepared statement object
  160.         $stmt->setFetchMode($this->_fetchMode);
  161.         return $stmt;
• Zend_Db_Adapter_Abstract->query [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Db/Adapter/Abstract.php, line 309]
  ? Args

  Arg	Name	Value
  0	$sql	Zend_Db_Select::__set_state(array(    '_adapter' =>    Zend_Db_Adapter_Pdo_Mysql::__set_state(array(      '_pdoType' => 'mysql',      '_config' =>      array (       'host' => 'localhost',       'username' => 'medicicards_pg',       'password' => 'pm06twdsf9sgs8',       'dbname' => 'medicicards_pg',     ),      '_fetchMode' => 2,      '_profiler' =>      Zend_Db_Profiler::__set_state(array(        '_queryProfiles' =>        array (       ),        '_enabled' => false,        '_filterElapsedSecs' => NULL,        '_filterTypes' => NULL,     )),      '_connection' =>      PDO::__set_state(array(     )),   )),    '_parts' =>    array (     'distinct' => false,     'forUpdate' => false,     'cols' =>      array (       0 => '*',       1 => 'prices.id',       2 => 'prices.quantity',       3 => 'prices.price',     ),     'from' =>      array (       0 => 'price_group',     ),     'join' =>      array (       0 =>        array (         'type' => NULL,         'name' => 'prices',         'cond' => 'price_group.id = prices.price_group_id',       ),     ),     'where' =>      array (       0 => 'price_group.id = ',     ),     'group' =>      array (     ),     'having' =>      array (     ),     'order' =>      array (       0 => 'prices.quantity ASC',     ),     'limitCount' => NULL,     'limitOffset' => NULL,   ),    '_tableCols' =>    array (   ), ))
  1	$bind	NULL

  ? Src
  304.      * @param array $bind Data to bind into SELECT placeholders.
  305.      * @return array
  306.      */
  307.     public function fetchAll($sql, $bind = null)
  308.     {
  309.         $result = $this->query($sql, $bind);
  310.         return $result->fetchAll($this->_fetchMode);
  311.     }
  314.     /**
• Zend_Db_Adapter_Abstract->fetchAll [/var/www/paperhouse/medicicards.co.uk/live/lib/S24/Database.php, line 131]
  ? Args

  Arg	Name	Value
  0	$sql	Zend_Db_Select::__set_state(array(    '_adapter' =>    Zend_Db_Adapter_Pdo_Mysql::__set_state(array(      '_pdoType' => 'mysql',      '_config' =>      array (       'host' => 'localhost',       'username' => 'medicicards_pg',       'password' => 'pm06twdsf9sgs8',       'dbname' => 'medicicards_pg',     ),      '_fetchMode' => 2,      '_profiler' =>      Zend_Db_Profiler::__set_state(array(        '_queryProfiles' =>        array (       ),        '_enabled' => false,        '_filterElapsedSecs' => NULL,        '_filterTypes' => NULL,     )),      '_connection' =>      PDO::__set_state(array(     )),   )),    '_parts' =>    array (     'distinct' => false,     'forUpdate' => false,     'cols' =>      array (       0 => '*',       1 => 'prices.id',       2 => 'prices.quantity',       3 => 'prices.price',     ),     'from' =>      array (       0 => 'price_group',     ),     'join' =>      array (       0 =>        array (         'type' => NULL,         'name' => 'prices',         'cond' => 'price_group.id = prices.price_group_id',       ),     ),     'where' =>      array (       0 => 'price_group.id = ',     ),     'group' =>      array (     ),     'having' =>      array (     ),     'order' =>      array (       0 => 'prices.quantity ASC',     ),     'limitCount' => NULL,     'limitOffset' => NULL,   ),    '_tableCols' =>    array (   ), ))

  ? Src
  126.          $select2->from ("price_group");
  127.          $select2->join("prices", "price_group.id = prices.price_group_id", array("prices.id","prices.quantity","prices.price"));
  128.          $select2->where("price_group.id = $price_group_id"); 
  129.          $select2->order("prices.quantity ASC"); 
  131.          $prices= $db->fetchAll($select2); 
  132.          
  133.          $card_info['prices'] = $prices; 
  134.          $card_info['card'] = $card[0];               
  135.          
  136.          return $card_info;            
• S24_Database->getCardInfo [/var/www/paperhouse/medicicards.co.uk/live/app/controllers/PersonaliseController.php, line 28]
  ? Args

  Arg	Name	Value
  0	$card_id	'44'

  ? Src
  23.         if (!$this->_getParam('id')) {
  24.             //TO DO
  25.         } else {
  26.             $card_id = $this->_getParam('id');
  27.             //echo $card_id;
  28.             $card_info = S24_Database::getInstance()->getCardInfo($card_id);
  30.             if (is_null( $card_info)) {
  31.                 //TO DO
  33.             } else {
• PersonaliseController->viewAction [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Controller/Action.php, line 118]
  ? Src
  113.         if (!method_exists($this, $methodName)) {
  114.             $this->__call($methodName, array());
  115.         } else {
  116.             $method = new ReflectionMethod($this, $methodName);
  117.             if ($method->isPublic() && !$method->isStatic()) {
  118.                 $this->{$methodName}();
  119.             } else {
  120.                 throw new Zend_Controller_Action_Exception('Illegal action called.');
  121.             }
  122.         }
• Zend_Controller_Action->run [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Controller/Dispatcher.php, line 185]
  ? Args

  Arg	Name	Value
  0	$dispatcher	Zend_Controller_Dispatcher::__set_state(array(    '_directory' => '/var/www/paperhouse/medicicards.co.uk/live/app/controllers', ))
  1	$action	Zend_Controller_Dispatcher_Token::__set_state(array(    '_controller' => 'personalise',    '_action' => 'view',    '_params' =>    array (     'id' => '44',     'controller' => 'personalise',     'action' => 'view',   ), ))

  ? Src
  180.          * Call the action of the Zend_Controller_Action.  It will return either null or a
  181.          * new Zend_Controller_Dispatcher_Token object.  If a Zend_Controller_Dispatcher_Token object is returned, this will be returned
  182.          * back to ZFrontController, which will call $this again to forward to
  183.          * another action.
  184.          */
  185.         $nextAction = $controller->run($this, $action);
  187.         // Destroy the page controller instance
  188.         $controller = null;
  190.         // Return either null (finished) or a Zend_Controller_Dispatcher_Token object (forward to another action).
• Zend_Controller_Dispatcher->_dispatch [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Controller/Dispatcher.php, line 136]
  ? Args

  Arg	Name	Value
  0	$action	Zend_Controller_Dispatcher_Token::__set_state(array(    '_controller' => 'personalise',    '_action' => 'view',    '_params' =>    array (     'id' => '44',     'controller' => 'personalise',     'action' => 'view',   ), ))
  1	$performDispatch	true

  ? Src
  131.      * @param Zend_Controller_Dispatcher_Token $action
  132.      * @return boolean|Zend_Controller_Dispatcher_Token
  133.      */
  134.     public function dispatch(Zend_Controller_Dispatcher_Token $action)
  135.     {
  136.         return $this->_dispatch($action, true);
  137.     }
  140.     /**
  141.      * If $performDispatch is FALSE, this method will check if a controller
• Zend_Controller_Dispatcher->dispatch [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Controller/Front.php, line 254]
  ? Args

  Arg	Name	Value
  0	$action	Zend_Controller_Dispatcher_Token::__set_state(array(    '_controller' => 'personalise',    '_action' => 'view',    '_params' =>    array (     'id' => '44',     'controller' => 'personalise',     'action' => 'view',   ), ))

  ? Src
  249.              */
  250.             while ($action instanceof Zend_Controller_Dispatcher_Token) {
  251.                 // notify plugins that a dispatch is about to occur
  252.                 $action = $this->_plugins->preDispatch($action);
  253.                 
  254.                 $action = $this->getDispatcher()->dispatch($action);
  255.                 
  256.                 // notify plugins that the dispatch has finish
  257.                 $action = $this->_plugins->postDispatch($action);
  258.             }
• Zend_Controller_Front->dispatch [/var/www/paperhouse/medicicards.co.uk/live/lib/Zend/Controller/Front.php, line 106]
  ? Src
  101.      */
  102.     static public function run($controllerDirectory)
  103.     {
  104.         self::getInstance()
  105.                     ->setControllerDirectory($controllerDirectory)
  106.                     ->dispatch();
  107.     }
  110.     /**
  111.      * Convenience method, passthru to Zend_Controller_Dispatcher::setControllerDirectory()
• Zend_Controller_Front::run [/var/www/paperhouse/medicicards.co.uk/live/web/cards/index.php, line 92]
  ? Args

  Arg	Name	Value
  0	$controllerDirectory	'/var/www/paperhouse/medicicards.co.uk/live/app/controllers'

  ? Src
  87. $router->addRoute('cards', ':controller/:action/:id', array('id' => null), array('id' => '\d+'));
  88. $controller = Zend_Controller_Front::getInstance();
  89. $controller->setRouter($router);
  91. $controller->registerPlugin(new S24_Controller_Plugin_Layout());
  92. $controller->run($config->path->controllers);
  94. //$controller->dispatch();

Request ?

Response ?