Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Resume later problem when clicking email link

  • stevelegare
  • stevelegare's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
9 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:
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);
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 8 months ago #110710 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • stevelegare
  • stevelegare's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
9 years 8 months ago #110711 by stevelegare
Replied by stevelegare on 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
The topic has been locked.
More
9 years 8 months ago #110805 by stbc
Same here, updated to latest yesterday.
Code:
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'
The topic has been locked.
More
9 years 8 months ago #110806 by stbc
Yep, the stated above fix does work!
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 8 months ago #110808 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The following user(s) said Thank You: stbc
The topic has been locked.
More
9 years 8 months ago #110810 by stbc
Only tested it with MySQL. Sorry, no MSSQL available
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose