- Posts: 112
- Thank you received: 0
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
- Topic Author
- Offline
- Premium Member
Less
More
9 years 9 months ago #110698
by stevelegare
Resume later problem when clicking email link was created 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:
\LimeSurvey\framework\db\CDbCommand.php(543)
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'
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13668
- Thank you received: 2496
9 years 9 months ago #110710
by DenisChenu
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.
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
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
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 112
- Thank you received: 0
9 years 9 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
I think is the same issue here bugs.limesurvey.org/view.php?id=9134
Thanks for your reply
The topic has been locked.
- stbc
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 1
9 years 9 months ago #110805
by stbc
Replied by stbc on topic Resume later problem when clicking email link
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.
- stbc
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 1
9 years 9 months ago #110806
by stbc
Replied by stbc on topic Resume later problem when clicking email link
Yep, the stated above fix does work!
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13668
- Thank you received: 2496
9 years 9 months ago #110808
by DenisChenu
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.
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.
- stbc
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 1
9 years 9 months ago #110810
by stbc
Replied by stbc on topic Resume later problem when clicking email link
Only tested it with MySQL. Sorry, no MSSQL available
The topic has been locked.