View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 16
IDProjectCategoryView StatusDate SubmittedLast Update
06672Bug reportsSurvey editingpublic2012-10-09 20:282012-10-13 08:03
Reporterarnaudbore Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06672: Error when a user without admin access try to visualise a survey
Description

When a user wants to visualise a survey which is created by the admin, here is the error message :

Error executing query in dbExecuteAssoc: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 ''3' at line 3

TagsNo tags attached.
Attached Files
Recoverable error.pdf (144,185 bytes)
Bug heat16
Complete LimeSurvey version number (& build)121006
I will donate to the project if issue is resolvedNo
Browser
Database type & versionVer 14.14 Distrib 5.5.25
Server OS (if known)Open Suse
Webserver software & version (if known)apache
PHP VersionPHP5.3.8

Relationships

Relationship GraphDependency Graph
has duplicate 06676 closedc_schmitz Users can not use preview function 

Users monitoring this issue

reneneee

Activities

c_schmitz

c_schmitz

2012-10-10 14:02

administrator   ~21170

Can you please elaborate?
What is a 'user' ? If it is another administrator what permissions does that account have exactly?
arnaudbore

arnaudbore

2012-10-10 14:14

reporter   ~21172

Usually I gave all statistic permissions and just view, export responses. But to be sure that it didn't come from permission I gave all permissions and it was the same error. The survey was created by the admin and it's not activated. The user just wanted to see the survey. Thank you for your help.
reneneee

reneneee

2012-10-10 15:55

reporter   ~21177

Last edited: 2012-10-10 15:57

I get the same error. In contrast to the description, the error also occurs when some wants to preview his/her own survey. Only admin user can preview the surveys, no other users.

I filed the same bug report as 06676, because I had not seen this one. It also occurs on the newest build:

Limesurvey build number: 121009
Browser: FF15 and all others
Database & DB-Version: MySQL 5.1.63
Operating System (Server): Debian Squeeze (64bit)
Webserver software & version: Apache 2.0
PHP Version: 5.3.3
c_schmitz

c_schmitz

2012-10-11 14:18

administrator   ~21217

Can you both please update to the latest build and check if the error persists?
Thank you.
arnaudbore

arnaudbore

2012-10-11 14:36

reporter   ~21222

I still have the same error :

Error executing query in dbExecuteAssoc: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 ''5' at line 3
c_schmitz

c_schmitz

2012-10-11 14:49

administrator   ~21225

Last edited: 2012-10-11 14:49

Open /application/config/config.php and set debug to 2.
See if you get more error information, if yes please attach the HTML page.
arnaudbore

arnaudbore

2012-10-11 15:05

reporter   ~21230

This is the debug message: The SQL statement executed was: SELECT uid FROM lime_survey_permissions WHERE sid = 262863 AND uid = '5
c_schmitz

c_schmitz

2012-10-11 15:18

administrator   ~21231

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9735
c_schmitz

c_schmitz

2012-10-11 15:19

administrator   ~21232

Please try the fix in the changeset below and let me know if that worked.
arnaudbore

arnaudbore

2012-10-11 15:26

reporter   ~21235

I attached a file with the new "error"
c_schmitz

c_schmitz

2012-10-11 15:30

administrator   ~21236

Last edited: 2012-10-11 15:31

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9736

Try again, please.
reneneee

reneneee

2012-10-11 16:14

reporter   ~21239

With build 121011 the bug still appeared. With the fix http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9736 it works perfectly now. Thanks!
arnaudbore

arnaudbore

2012-10-11 16:14

reporter   ~21240

Great it works now ! Thank you !
c_schmitz

c_schmitz

2012-10-13 08:03

administrator   ~21288

2.00+ Build 121013 released. Please update.

Related Changesets

LimeSurvey: master b127972e

2012-10-11 06:18:33

c_schmitz

Details Diff 		Fixed issue 06672: Error when a user without admin access try to visualise a survey Affected Issues
06672
mod - application/controllers/survey/index.php Diff File

LimeSurvey: master eb8b5e36

2012-10-11 06:30:04

c_schmitz

Details Diff 		Fixed issue 06672: Error when a user without admin access try to visualise a survey Affected Issues
06672
mod - application/controllers/survey/index.php Diff File

Issue History

Date Modified Username Field Change
2012-10-09 20:28 arnaudbore New Issue
2012-10-10 14:02 c_schmitz Note Added: 21170
2012-10-10 14:02 c_schmitz Assigned To => c_schmitz
2012-10-10 14:02 c_schmitz Status new => feedback
2012-10-10 14:14 arnaudbore Note Added: 21172
2012-10-10 14:14 arnaudbore Status feedback => assigned
2012-10-10 15:50 reneneee Issue Monitored: reneneee
2012-10-10 15:55 reneneee Note Added: 21177
2012-10-10 15:57 reneneee Note Edited: 21177
2012-10-10 16:07 c_schmitz Relationship added has duplicate 06676
2012-10-11 14:18 c_schmitz Note Added: 21217
2012-10-11 14:19 c_schmitz Status assigned => feedback
2012-10-11 14:36 arnaudbore Note Added: 21222
2012-10-11 14:36 arnaudbore Status feedback => assigned
2012-10-11 14:49 c_schmitz Note Added: 21225
2012-10-11 14:49 c_schmitz Note Edited: 21225
2012-10-11 14:50 c_schmitz Status assigned => feedback
2012-10-11 15:05 arnaudbore Note Added: 21230
2012-10-11 15:05 arnaudbore Status feedback => assigned
2012-10-11 15:18 c_schmitz Changeset attached => LimeSurvey master b127972e
2012-10-11 15:18 c_schmitz Note Added: 21231
2012-10-11 15:18 c_schmitz Resolution open => fixed
2012-10-11 15:19 c_schmitz Note Added: 21232
2012-10-11 15:19 c_schmitz Status assigned => resolved
2012-10-11 15:19 c_schmitz Fixed in Version => 2.00+
2012-10-11 15:26 arnaudbore Note Added: 21235
2012-10-11 15:26 arnaudbore File Added: Recoverable error.pdf
2012-10-11 15:30 c_schmitz Changeset attached => LimeSurvey master eb8b5e36
2012-10-11 15:30 c_schmitz Note Added: 21236
2012-10-11 15:31 c_schmitz Note Edited: 21236
2012-10-11 16:14 reneneee Note Added: 21239
2012-10-11 16:14 arnaudbore Note Added: 21240
2012-10-13 08:03 c_schmitz Note Added: 21288
2012-10-13 08:03 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing
2021-08-03 15:36 guest Bug heat 12 => 16