View Issue Details

This bug affects 1 person(s).
 254
IDProjectCategoryView StatusLast Update
07147Bug reportsSecuritypublic2013-01-15 09:14
Reportersamarta Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed 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 Reproduce

User with no Super-Administrator privileges creates a survey
This user tries to set survey permissions
Error occurs

Additional Information

With 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.
Attached Files
CDbException.webarchive (23,618 bytes)
Bug heat254
Complete LimeSurvey version number (& build)130103
I will donate to the project if issue is resolvedNo
BrowserSafari, Firefox
Database type & versionmysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 5.1
Server OS (if known)Fedora release 16
Webserver software & version (if known)Apache/2.2.22
PHP VersionPHP 5.3.18

Users monitoring this issue

samarta

Activities

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 Affected Issues
07147
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 Affected Issues
07147
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 11:28 samarta Issue Monitored: samarta
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
2021-08-03 03:25 guest Bug heat 252 => 254