View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
05531Bug reportsOtherpublic2011-10-26 12:022012-03-11 16:32
Reportermot Assigned Tomagiclko 
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00a1 
Target Version2.00a2Fixed in Version2.00a2 
Summary05531: 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.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)11267
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql 5 Family
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.2
PHP Version5.3.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-03-11 16:32

administrator   ~17872

2.00alpha 2 Build 120212 released

Issue History

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-01-23 17:00 c_schmitz Target Version 2.00a1 => 2.00a2
2012-03-11 16:32 c_schmitz Note Added: 17872
2012-03-11 16:32 c_schmitz Status resolved => closed