View Issue Details

IDProjectCategoryView StatusLast Update
07147Bug reports[All Projects] Securitypublic2013-01-15 09:14
ReportersamartaAssigned Toc_schmitz 
PrioritynormalSeveritymajor 
Status closedResolutionfixed 
Product Version2.00+ 
Target VersionFixed in Version2.00+ 
Summary07147: Unable to set survey permissions for non-admin users
Description
Hi,

When a non-admin user (this
user is the owner of the survey) tries to set survey permissions for a survey we get the following message:

"Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Steps To ReproduceUser with no Super-Administrator privileges creates a survey
This user tries to set survey permissions
Error occurs
Additional InformationWith debug set to 2 The messahe is:
CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined. The SQL statement executed was: SELECT * FROM `lime_surveys` `t` WHERE sid = :surveyid AND owner_id != :postuserid AND owner_id = :owner_id LIMIT 1

I also tried with versions:
Version 2.00+ Build 121024

and
Version 2.00+ Build 121209
TagsNo tags attached.
Complete LimeSurvey version number (& build)130103
I will donate to the project if issue is resolvedNo
BrowserSafari, Firefox
Database & DB-Versionmysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 5.1
Operating System (Server)Fedora release 16
Webserver software & versionApache/2.2.22
PHP VersionPHP 5.3.18

Activities

samarta

samarta

2013-01-07 11:27

reporter  

CDbException.webarchive (23,618 bytes)
c_schmitz

c_schmitz

2013-01-09 15:27

administrator   ~23584

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

c_schmitz

2013-01-09 21:45

administrator   ~23597

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

c_schmitz

2013-01-15 09:14

administrator   ~23671

2.00+ Build 130115 released

Related Changesets

LimeSurvey: master 0ac1e38d

2013-01-09 14:27:26

c_schmitz

Details Diff
Fixed issue 07147: Unable to set survey permissions for non-admin users
mod - application/controllers/admin/surveypermission.php Diff File

LimeSurvey: 2.1 b26da2ab

2013-01-09 14:27:26

c_schmitz

Details Diff
Fixed issue 07147: Unable to set survey permissions for non-admin users
mod - application/controllers/admin/surveypermission.php Diff File

Issue History

Date Modified Username Field Change
2013-01-07 11:27 samarta New Issue
2013-01-07 11:27 samarta File Added: CDbException.webarchive
2013-01-07 12:01 c_schmitz Assigned To => c_schmitz
2013-01-07 12:01 c_schmitz Status new => assigned
2013-01-09 15:27 c_schmitz Changeset attached => LimeSurvey master 0ac1e38d
2013-01-09 15:27 c_schmitz Note Added: 23584
2013-01-09 15:27 c_schmitz Resolution open => fixed
2013-01-09 15:28 c_schmitz Status assigned => resolved
2013-01-09 15:28 c_schmitz Fixed in Version => 2.00+
2013-01-09 21:45 c_schmitz Changeset attached => LimeSurvey 2.1 b26da2ab
2013-01-09 21:45 c_schmitz Note Added: 23597
2013-01-15 09:14 c_schmitz Note Added: 23671
2013-01-15 09:14 c_schmitz Status resolved => closed