Resume later problem when clicking email link

More
2 years 8 months ago #110698 by stevelegare
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:
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)
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);

Please Log in to join the conversation.

More
2 years 8 months ago #110710 by DenisChenu
Hi,

What is you LS version andbuild number?
If it's the last version and build, please report this bug with DB information.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
2 years 8 months ago #110711 by stevelegare
It is the latest version and stable build.

I think is the same issue here bugs.limesurvey.org/view.php?id=9134

Thanks for your reply

Please Log in to join the conversation.

More
2 years 8 months ago #110805 by stbc
Same here, updated to latest yesterday.
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'

Please Log in to join the conversation.

More
2 years 8 months ago #110806 by stbc
Yep, the stated above fix does work!

Please Log in to join the conversation.

More
2 years 8 months ago #110808 by DenisChenu
I make the fix, but if someone have a mssql DB .... it can be great to test it.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
The following user(s) said Thank You: stbc

Please Log in to join the conversation.

More
2 years 8 months ago #110810 by stbc
Only tested it with MySQL. Sorry, no MSSQL available

Please Log in to join the conversation.