Hi,
I have a DB error when cliking the link for the resume later option.
I think the problem is the double quote with the saved username (steve).
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 'steve'' AND ls_diti_saved_control.access_code = '699f711b1f712a154182e0f81bcb96a' at line 5.
The SQL statement executed was:
Code:
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'
\LimeSurvey\framework\db\CDbCommand.php(543)
Code:
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);