CDbException

CDbCommand không thể thi hành 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, name ASC' at line 1. The SQL statement executed was: SELECT * FROM `province` `t` WHERE active = 1 AND parent = ORDER BY ord ASC, name ASC

/home/muabantau/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/muabantau/public_html/protected/models/Province.php(155): CActiveRecord->findAll(array("condition" => "active = 1 AND parent = ", "order" => "ord ASC, name ASC"))
150     public function getDistrict($province_id)
151     {
152         return self::model()->findAll(array(
153         'condition' => 'active = 1 AND parent = ' . $province_id,
154         'order' => 'ord ASC, name ASC'
155         ));
156     }
157 
158     public function getDefault()
159     {
160         return self::model()->find(array(
#4
+
 /home/muabantau/public_html/protected/views/site/pages/list_land_by_price.php(21): Province->getDistrict(null)
16                 </p>
17 
18                 <div class="box_search_list">
19                     <?php
20                     $now_province = Province::getDefault();
21                     $now_district = Province::getDistrict($now_province->id);
22                     $search = $_SESSION['search_smart'];
23                     if (!empty($now_district))
24                     {
25                         ?>
26                         <dl class="dist_search">
#9
+
 /home/muabantau/public_html/protected/controllers/SiteController.php(1127): CController->render("pages/list_land_by_price", array("model" => array(), "pages" => CPagination, "count" => "0", "price_area_home" => PriceArea))
1122         $this->render('pages/list_land_by_price', array(
1123             'model'=>$model,
1124             'pages' => $pages,
1125             'count' => $count,
1126             'price_area_home' => $price_area
1127         ));
1128     }
1129 
1130 
1131     /*
1132      * TIM KIEM THONG MINH
2024-03-29 00:32:08 LiteSpeed Yii Framework/1.1.16