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 recommend desc,id desc LIMIT 5' at line 1. The SQL statement executed was: SELECT * FROM `project` `t` WHERE id != ORDER BY recommend desc,id desc LIMIT 5

/www/users/HA522758/WEB/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
+
 /www/users/HA522758/WEB/protected/controllers/ProjectController.php(122): CActiveRecord->findAll(CDbCriteria)
117          $criteria2 = new CDbCriteria(array(
118             'order' => 'recommend desc,id desc',
119         ));
120         $criteria2->addSearchCondition('title', $model->keywords);
121         $criteria2->addCondition('id != '.$model->id);
122         $clist=Project::model()->limit(5)->findAll($criteria2);
123         $data = array(
124             'model' => $model,
125             'clist' => $clist,
126         );
127          if($this->cate->viewtpl=="view"){
#11
+
 /www/users/HA522758/WEB/common.php(13): CApplication->run()
08 // specify how many levels of call stack should be shown in each log message
09 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL', 5);
10 require_once($yii);
11 $app = Yii::createWebApplication($config);
12 require_once($globals);
13 $app->run();
#12
+
 /www/users/HA522758/WEB/index.php(14): require_once("/www/users/HA522758/WEB/common.php")
09 }else{
10     $config=dirname(__FILE__).'/protected/config/main.php';
11 }
12 
13 $globals = dirname(__FILE__) . '/protected/globals.php';
14 require_once('./common.php');
2024-03-28 23:09:28 Apache Yii Framework/1.1.16-dev