View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
08828Bug reportsOtherpublic2014-03-18 15:38
Reportermarkg Assigned Toc_schmitz  
PriorityimmediateSeveritypartial_block 
Status closedResolutionnot fixable 
Product Version2.05+ 
Summary08828: Weird Issue with creating surveys/questions/token tables
Description

If I create a user in SQL Server that has db_datareader and db_datawriter privledges on the database for Lime, I am able to create surveys and questions perfectly, but not token tables. Then, I give that same user db_owner as well, and then I can do everything properly. However, that seems to be reversed by some action in Lime, since eventually everything breaks down and I cannot create questions or surveys. IF I DO THIS OUT OF ORDER, and create a user who has db_writer, db_reader, and db_owner privledges all at the same time when I create the user, the user cannot create surveys or questions - when trying to create questions Limesurvey simply does nothing, and when trying to create surveys I get a basic error message saying: Survey could not be created. I've tried enabling debugging in Lime, but it isn't throwing any errors at all at me. The weirdest part is that after awhile (not sure if something in Lime is causing this), I encounter a problem with the user account I originally created for lime and permissioned in two steps who was working. After some unknown course of actions, I assume, this user is no longer able to create surveys/questions again. We reverted back to an earlier build of Lime (14012), and then the problem only happened with being able to create surveys - we were able to create questions.

Steps To Reproduce

See above

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)140132
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionMicrosoft SQL Server 2008 w/ FreeTDS
Server OS (if known)Red Had Enterprise Linux
Webserver software & version (if known)Apache 2.2.15
PHP Version5.3.8
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-03-18 15:38

administrator   ~29343

I am sorry but this is not a LimeSurvey bug but rather a problem with your setup. Please use the forums instead. Thank you.

Issue History

Date Modified Username Field Change
2014-03-07 21:03 markg New Issue
2014-03-18 15:38 c_schmitz Note Added: 29343
2014-03-18 15:38 c_schmitz Status new => closed
2014-03-18 15:38 c_schmitz Assigned To => c_schmitz
2014-03-18 15:38 c_schmitz Resolution open => not fixable