Resume later problem when clicking email link

More
2 years 9 months ago #110698 by stevelegare
stevelegare created the topic: Resume later problem when clicking email link
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 9 months ago #110710 by DenisChenu
DenisChenu replied the topic: Resume later problem when clicking email link
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).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
2 years 9 months ago #110711 by stevelegare
stevelegare replied the topic: Resume later problem when clicking email link
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 9 months ago #110805 by stbc
stbc replied the topic: Resume later problem when clicking email link
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 9 months ago #110806 by stbc
stbc replied the topic: Resume later problem when clicking email link
Yep, the stated above fix does work!

Please Log in to join the conversation.

More
2 years 9 months ago #110808 by DenisChenu
DenisChenu replied the topic: Resume later problem when clicking email link
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).
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: stbc

Please Log in to join the conversation.

More
2 years 9 months ago #110810 by stbc
stbc replied the topic: Resume later problem when clicking email link
Only tested it with MySQL. Sorry, no MSSQL available

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now