View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05531 | Bug reports | Other | public | 2011-10-26 12:02 | 2012-03-11 16:32 |
| Reporter | mot | Assigned To | |||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00a1 | ||||
| Fixed in Version | 2.00a2 | ||||
| Summary | 05531: Database error / SELECT statement on Create/Edit Users | ||||
| Description | An SQL error is being reported: Error executing query in db_execute_assoc: SELECT from limeci_users where uid in ( SELECT uid from limeci_user_in_groups where ugid in ( SELECT ugid from limeci_user_in_groups where uid=2 ) ) UNION SELECT from limeci_users where users.parent_id=2 | ||||
| Steps To Reproduce | Created a new user, allowed for participants panel (only), logged in with the new user and then clicked on the key button (Create/Edit Users). | ||||
| Additional Information | I would say that the button should not be displayed at all because the user doesn't have the proper rights. However this SQL error might show an underlying defect as well. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 11267 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | Mysql 5 Family | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | Apache 2.2 | ||||
| PHP Version | 5.3.8 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-10-26 12:02 | mot | New Issue | |
| 2011-10-26 18:30 | c_schmitz | Assigned To | => magiclko |
| 2011-10-26 18:30 | c_schmitz | Status | new => assigned |
| 2012-01-23 17:00 | c_schmitz | Status | assigned => resolved |
| 2012-01-23 17:00 | c_schmitz | Fixed in Version | => 2.00a2 |
| 2012-01-23 17:00 | c_schmitz | Resolution | open => fixed |
| 2012-03-11 16:32 | c_schmitz | Note Added: 17872 | |
| 2012-03-11 16:32 | c_schmitz | Status | resolved => closed |