View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06676Bug reportsAccessibilitypublic2012-10-10 16:07
Reporterreneneee Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionduplicate 
Product Version2.00+ 
Summary06676: Users can not use preview function
Description

When trying to preview a questionnaire or single question, the following error occurs:

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 ''2' at line 3

This error only happens when a user different to 'admin' is trying to see the preview.

Steps To Reproduce

Login as a user != admin. Create a questionnaire and try to preview the questionnaire or one question of the questionnaire.

Additional Information

This is probably the same bug as 06667. Bug 06667 was marked as resolved, but I do not have permissions to re-open it. LimeSurvey build 121009 in which bug 06667 is supposed to be fixed still gives me the same error.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)121009
I will donate to the project if issue is resolvedNo
Browserall
Database type & versionMySQL 5.1.63
Server OS (if known)Debian Squeeze (64bit)
Webserver software & version (if known)Apache 2.0
PHP Version5.3.3

Relationships

duplicate of 06672 closedc_schmitz Error when a user without admin access try to visualise a survey 

Users monitoring this issue

reneneee

Activities

reneneee

reneneee

2012-10-10 15:53

reporter   ~21175

duplicate of 06672, sorry about that

Issue History

Date Modified Username Field Change
2012-10-10 15:48 reneneee New Issue
2012-10-10 15:50 reneneee Issue Monitored: reneneee
2012-10-10 15:53 reneneee Note Added: 21175
2012-10-10 16:07 c_schmitz Relationship added duplicate of 06672
2012-10-10 16:07 c_schmitz Status new => closed
2012-10-10 16:07 c_schmitz Assigned To => c_schmitz
2012-10-10 16:07 c_schmitz Resolution open => duplicate
2021-08-03 15:36 guest Bug heat 2 => 4