Welcome, Guest
Username: Password: Remember me

TOPIC: Resume later problem when clicking email link

Resume later problem when clicking email link 2 months 1 week ago #110698

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);
The administrator has disabled public write access.

Resume later problem when clicking email link 2 months 1 week ago #110710

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6331
  • Thank you received: 817
  • Karma: 243
Hi,

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

Denis
The administrator has disabled public write access.

Resume later problem when clicking email link 2 months 1 week ago #110711

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 administrator has disabled public write access.

Resume later problem when clicking email link 2 months 1 week ago #110805

  • stbc
  • stbc's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
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'
The administrator has disabled public write access.

Resume later problem when clicking email link 2 months 1 week ago #110806

  • stbc
  • stbc's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Yep, the stated above fix does work!
The administrator has disabled public write access.

Resume later problem when clicking email link 2 months 1 week ago #110808

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6331
  • Thank you received: 817
  • Karma: 243
I make the fix, but if someone have a mssql DB .... it can be great to test it.
The administrator has disabled public write access.
The following user(s) said Thank You: stbc

Resume later problem when clicking email link 2 months 1 week ago #110810

  • stbc
  • stbc's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Only tested it with MySQL. Sorry, no MSSQL available
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.215 seconds
Donation Image