View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 08828 | Bug reports | Other | public | 2014-03-07 21:03 | 2014-03-18 15:38 |
| Reporter | markg | Assigned To | c_schmitz | ||
| Priority | immediate | Severity | partial_block | ||
| Status | closed | Resolution | not fixable | ||
| Product Version | 2.05+ | ||||
| Summary | 08828: 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 | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 140132 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | All | ||||
| Database type & version | Microsoft SQL Server 2008 w/ FreeTDS | ||||
| Server OS (if known) | Red Had Enterprise Linux | ||||
| Webserver software & version (if known) | Apache 2.2.15 | ||||
| PHP Version | 5.3.8 | ||||
| Git branch / Pull Request URL | |||||