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 ord ASC, id DESC' at line 1. The SQL statement executed was: SELECT * FROM `type` `t` WHERE active = 1 AND parent = ORDER BY ord ASC, 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(270): CActiveRecord->findAll(array("condition" => "active = 1 AND parent = ", "order" => "ord ASC, id DESC"))
265     public function getTypeByParent($pare)
266     {
267         return self::model()->findAll(array(
268         'condition' => 'active = 1 AND parent = ' . $pare,
269         'order' => 'ord ASC, id DESC'
270         ));
271     }
272 
273 }
#4
+
 /home/thegioigiaytheth/public_html/protected/controllers/SiteController.php(506): Type->getTypeByParent(null)
501             $this->navigation_bar = $this->navigation_bar . '<i class="fa fa-angle-double-right"></i>' . CHtml::link($pare->name, Yii::app()->urlManager->createUrl('site/ListProductByType', array('id' => $pare->id, 'name' => $pare->url)));
502         }
503         $this->navigation_bar = $this->navigation_bar . '<i class="fa fa-angle-double-right"></i>' . CHtml::link($type->name, Yii::app()->urlManager->createUrl('site/ListProductByType', array('id' => $type->id, 'name' => $type->url)));
504         //navigation_bar
505 
506         $subtype = Type::getTypeByParent($type->id);
507         if (!empty($subtype)) {
508             foreach ($subtype as $row) {
509                 $arr_type[] = $row->id;
510             }
511         }
#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-19 08:51:23 LiteSpeed Yii Framework/1.1.17