CDbException

CDbCommand failed to execute the SQL statement: 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 ''{{tokens_61265}}' SET token= 'ppqscsy9wbi56h9' WHERE tid='3'' at line 1. The SQL statement executed was: UPDATE :tablename SET token= :newtoken WHERE tid=:tid

/Users/fred/Dropbox/MAMP/htdocs/LimeSurvey/framework/db/CDbCommand.php(354)

342 return $n;
343 }
344 catch(Exception $e)
345 {
346 if($this->_connection->enableProfiling)
347 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().')','system.db.CDbCommand.execute');
348 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
349 $message = $e->getMessage();
350 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
351 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
352 if(YII_DEBUG)
353 $message .= '. The SQL statement executed was: '.$this->getText().$par;
354 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
355 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
356 }
357 }
358
359 /*
360 Executes the SQL statement and returns query result.
361 This method is for executing an SQL query that returns result set.
362 @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
363 to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
364 them in this way can improve the performance. Note that if you pass parameters in this way,
365 you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
366 binding methods and the input parameters this way can improve the performance.
Stack Trace
#0
– /Users/fred/Dropbox/MAMP/htdocs/LimeSurvey/application/models/Tokens_dynamic.php(141): CDbCommand->execute()
136 {
137 return Yii::app()->db->createCommand('UPDATE :tablename SET token= :newtoken WHERE tid=:tid')
138 ->bindParam(":newtoken", $newtoken, PDO::PARAM_STR)
139 ->bindParam(":tid", $tid, PDO::PARAM_INT)
140 ->bindParam(":tablename", $this->tableName(), PDO::PARAMSTR)
141 ->execute();
142 }
143 function selectEmptyTokens($iSurveyID)
144 {
145 return Yii::app()->db->createCommand("SELECT tid FROM {{tokens{$iSurveyID}}} WHERE token IS NULL OR token=''")->queryAll();
146 }
#1
– /Users/fred/Dropbox/MAMP/htdocs/LimeSurvey/application/models/Tokens_dynamic.php(180): Tokens_dynamic->updateToken("3", "ppqscsy9wbi56h9")
175 if (!in_array($newtoken, $existingtokens)) {
176 $existingtokens[] = $newtoken;
177 $bIsValidToken = true;
178 }
179 }
180 $itresult = $this->updateToken($tkrow['tid'], $newtoken);
181 $newtokencount++;
182 }
183 return $newtokencount;
184
185 }