- Posts: 121
- Thank you received: 2
Ask the community, share ideas, and connect with other LimeSurvey users!
SELECT * FROM ls_saved_control INNER JOIN ls_survey_428666 ON ls_saved_control.srid = ls_survey_428666.id WHERE ls_saved_control.sid=428666 AND ls_saved_control.scid=6 AND ls_saved_control.identifier = ''steve'' AND ls_saved_control.access_code = '699f711b1f712a154182e0f81bcb96aa'
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);
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 '[name]'' AND lime_saved_control.access_code = '827ccb0eea8a706c4c34a16' at line 4. The SQL statement executed was: SELECT * FROM lime_saved_control INNER JOIN lime_survey_98915 ON lime_saved_control.srid = lime_survey_98915.id WHERE lime_saved_control.sid=98915 AND lime_saved_control.identifier = ''[name]'' AND lime_saved_control.access_code = '827ccb0eea8a706c4c34a16891f84e7b'