CDbException

CDbCommand không thể thi hành câu truy vấn SQL: CDbCommand không thể chuẩn bị câu truy vấn SQL: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.kind ASC, t.ord ASC, t.id DESC' at line 1. The SQL statement executed was: SELECT * FROM `type` `t` WHERE t.active = 1 AND cat_id = ORDER BY t.kind ASC, t.ord ASC, t.id DESC

/home/thegioigiaytheth/public_html/framework/db/CDbCommand.php(543)

531         {
532             if($this->_connection->enableProfiling)
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534 
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536             $message=$e->getMessage();
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539 
540             if(YII_DEBUG)
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;
542 
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545         }
546     }
547 
548     /**
549      * Builds a SQL SELECT statement from the given query specification.
550      * @param array $query the query specification in name-value pairs. The following
551      * query options are supported: {@link select}, {@link distinct}, {@link from},
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553      * {@link limit}, {@link offset} and {@link union}.
554      * @throws CDbException if "from" key is not present in given query parameter
555      * @return string the SQL statement

Stack Trace

#3
+
 /home/thegioigiaytheth/public_html/protected/models/Type.php(190): CActiveRecord->findAll(array("condition" => "t.active = 1 AND cat_id = ", "order" => "t.kind ASC, t.ord ASC, t.id DESC"))
185     public function getAllTypeByCat($cat_id)
186     {
187         return self::model()->findAll(array(
188         'condition' => 't.active = 1 AND cat_id = ' . $cat_id,
189         'order' => 't.kind ASC, t.ord ASC, t.id DESC',
190         ));
191     }
192 
193     //lay ra danh muc cha
194     public function getHome($cat_id)
195     {
#4
+
 /home/thegioigiaytheth/public_html/protected/controllers/SiteController.php(410): Type->getAllTypeByCat(null)
405 
406         //navigation_bar
407         $this->navigation_bar = $this->navigation_bar . '<i class="fa fa-angle-double-right"></i>' . CHtml::link($cat->name, Yii::app()->urlManager->createUrl('site/ListProduct', array('id' => $cat->id, 'name' => $cat->url)));
408         //navigation_bar
409 
410         $type = Type::getAllTypeByCat($cat->id);
411         if (!empty($type)) {
412             foreach ($type as $row) {
413                 $arr_type[] = $row->id;
414             }
415 
#14
+
 /home/thegioigiaytheth/public_html/index.php(13): CApplication->run()
08 defined('YII_DEBUG') or define('YII_DEBUG',true);
09 // specify how many levels of call stack should be shown in each log message
10 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3);
11 
12 require_once($yii);
13 Yii::createWebApplication($config)->run();
14 error_reporting(E_NONE);
2024-03-28 22:45:09 LiteSpeed Yii Framework/1.1.17