View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
11288Bug reportsCentral participant databasepublic2016-05-27 16:332016-05-30 14:18
Reporterradhwaw Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary11288: Cannot Edit/Update Participants' Information Unless Having Superadministrator Permission
Description

I tried to edit/update participants' information of certain participant i have created in central participant database but it shows code error as follows:
"PHP Error [500]
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 'oOR share_uid = 0)' at line 3".

The above error is shown even if I have "Participant Panel" Permission. The error doesn't show when I give superadministrator permission to the administrator/user.

Steps To Reproduce

1) Create Certain Administrator with "Participan Panel" permission but without "superadministrator" permission;
2) Login as the created Administrator in step 1);
3) Create a new participant in Central Participant Database
4) Try to edit/update participant information and save/enter (you cannot, it shows error message)

TagsNo tags attached.
Attached Files
setpermissionparticipant.png (78,674 bytes)   
setpermissionparticipant.png (78,674 bytes)   
erroredit.png (51,175 bytes)   
erroredit.png (51,175 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)160526
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionMS SQL Server
Server OS (if known)Windows 7
Webserver software & version (if known)Apache 2.2.21
PHP Version5.3.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-05-27 20:47

administrator   ~38979

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=19229
c_schmitz

c_schmitz

2016-05-30 14:18

administrator   ~39011

Version 2.50+ Build 160529 released

Related Changesets

LimeSurvey: master abefd776

2016-05-27 18:47:13

c_schmitz

Details Diff 		Fixed issue 11288: Cannot edit/update oarticipants unless having superadministrator permission Affected Issues
11288
mod - application/models/Participant.php Diff File

Issue History

Date Modified Username Field Change
2016-05-27 16:33 radhwaw New Issue
2016-05-27 16:33 radhwaw File Added: setpermissionparticipant.png
2016-05-27 16:34 radhwaw File Added: erroredit.png
2016-05-27 20:47 c_schmitz Changeset attached => LimeSurvey master abefd776
2016-05-27 20:47 c_schmitz Note Added: 38979
2016-05-27 20:47 c_schmitz Assigned To => c_schmitz
2016-05-27 20:47 c_schmitz Resolution open => fixed
2016-05-27 20:47 c_schmitz Status new => resolved
2016-05-27 20:47 c_schmitz Fixed in Version => 2.5
2016-05-30 14:18 c_schmitz Note Added: 39011
2016-05-30 14:18 c_schmitz Status resolved => closed