CDbException

CDbCommand فشل في تنفيذ بيان SQL: 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 productId desc LIMIT 15' at line 1. The SQL statement executed was: SELECT * FROM `hts_products` `t` WHERE userId = ORDER BY productId desc LIMIT 15

/var/www/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
+
 /var/www/html/protected/controllers/UserController.php(1032): CActiveRecord->findAll(CDbCriteria)
1027         $criteria->limit = $limit;
1028         if(isset($offset)) {
1029             $criteria->offset = $offset;
1030         }
1031         //$action = 'profiles';
1032         $products = Products::model()->findAll($criteria);
1033         if(Yii::app()->controller->action->id == 'review') {
1034             $this->renderPartial('review',compact('reviews'));
1035         }else if(Yii::app()->request->isAjaxRequest) {
1036             $this->renderPartial('loadresults',compact('products','limit','offset','count','follower','followerIds'));
1037         } else {
#13
+
 /var/www/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();
2024-03-28 11:10:31 Apache/2.4.18 (Ubuntu) Yii Framework/1.1.16-dev