CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sort' in 'order clause'. The SQL statement executed was: SELECT * FROM `pg_faq` `t` ORDER BY sort ASC

/home/ptbmicom/yii/framework/db/CDbCommand.php(528)

516             return $result;
517         }
518         catch(Exception $e)
519         {
520             if($this->_connection->enableProfiling)
521                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
522             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
523             $message = $e->getMessage();
524             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
525                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
526             if(YII_DEBUG)
527                 $message .= '. The SQL statement executed was: '.$this->getText().$par;
528             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
529                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
530         }
531     }
532 
533     /**
534      * Builds a SQL SELECT statement from the given query specification.
535      * @param array $query the query specification in name-value pairs. The following
536      * query options are supported: {@link select}, {@link distinct}, {@link from},
537      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
538      * {@link limit}, {@link offset} and {@link union}.
539      * @return string the SQL statement
540      * @since 1.1.6

Stack Trace

#3
+
 /home/ptbmicom/public_html/protected/views/about/faq.php(7): CActiveRecord->findAll(CDbCriteria)
02     <h4>SERTIFIKASI</h4>
03     <p>&nbsp;</p>
04     <?php 
05     $criteria_faq = new CDbCriteria();
06     $criteria_faq->order = "sort ASC";
07     $model_faq = Faq::model()->findAll($criteria_faq);
08     ?>
09     <div class="panel-group" id="accordion" role="tablist" aria-multiselectable="true">
10     <?php
11     $i = 1;
12     foreach ($model_faq as $key => $value): ?>
#7
+
 /home/ptbmicom/public_html/protected/views/about/index.php(54): CController->renderPartial("//about/faq", array())
49             </div>
50             <div id="sertifikasi" data-id="3" class="tab-pane fade" role="tabpanel">
51               <?php echo $this->renderPartial("//about/sertifikasi", array()); ?>
52             </div>
53             <div id="faq" data-id="4" class="tab-pane fade" role="tabpanel">
54               <?php echo $this->renderPartial("//about/faq", array()); ?>
55             </div>
56             <div id="testimoni" data-id="5" class="tab-pane fade" role="tabpanel">
57               <?php echo $this->renderPartial("//about/testimoni", array()); ?>
58             </div>
59             <div class="clear"></div>
#12
+
 /home/ptbmicom/public_html/protected/controllers/AboutController.php(18): CController->render("index", array("data" => array("title" => null, "content" => null)))
13             'content'=>$this->setting['about_whoweare_content'],
14             );
15 
16         $this->render('index', array(    
17             'data' => $data,
18         ));
19     }
20 
21     public function actionWho_we_are()
22     {
23         $this->pageTitle = 'About Us - '.$this->pageTitle;
2024-03-29 14:49:08 Apache Yii Framework/1.1.12