View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06810 | Bug reports | Security | public | 2012-10-30 22:11 | 2012-11-02 11:18 |
Reporter | jtate | Assigned To | c_schmitz | ||
Priority | normal | Severity | block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06810: When you add a group to a survey's permissions list and set the permissions you get a SQL error on the permissions page. | ||||
Description | After I added a group to my survey, I started getting the following traceback: CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "2 OR ugid=1" This stems from code in admin/surveypermission.php | ||||
Steps To Reproduce | Create a survey Load the survey permissions page again. | ||||
Additional Information | This patch fixed it for me: diff --git a/application/controllers/admin/surveypermission.php b/application/controllers/admin/surveypermission.php
| ||||
Tags | No tags attached. | ||||
Bug heat | 252 | ||||
Complete LimeSurvey version number (& build) | 121024 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Postgresql | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache 2.2 | ||||
PHP Version | 5.3.17 | ||||
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10086 |
|
Thank you very much! |
|
2.00+ build 201101 released. Please update. |
|
Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10106 |
|
LimeSurvey: master 48b888be 2012-11-01 08:26:21 Details Diff |
Fixed issue 06810: When you add a group to a survey's permissions list and set the permissions you get a SQL error on the permissions page - patch by jtate |
Affected Issues 06810 |
|
mod - application/controllers/admin/surveypermission.php | Diff File | ||
LimeSurvey: 2.1 fcd11dbe 2012-11-01 08:26:21 Details Diff |
Fixed issue 06810: When you add a group to a survey's permissions list and set the permissions you get a SQL error on the permissions page - patch by jtate |
Affected Issues 06810 |
|
mod - application/controllers/admin/surveypermission.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-10-30 22:11 | jtate | New Issue | |
2012-11-01 00:12 | c_schmitz | Assigned To | => c_schmitz |
2012-11-01 00:12 | c_schmitz | Status | new => assigned |
2012-11-01 09:26 | c_schmitz | Changeset attached | => LimeSurvey master 48b888be |
2012-11-01 09:26 | c_schmitz | Note Added: 21851 | |
2012-11-01 09:26 | c_schmitz | Resolution | open => fixed |
2012-11-01 09:26 | c_schmitz | Note Added: 21852 | |
2012-11-01 09:26 | c_schmitz | Status | assigned => resolved |
2012-11-01 09:26 | c_schmitz | Fixed in Version | => 2.00+ |
2012-11-01 13:13 | c_schmitz | Note Added: 21864 | |
2012-11-01 13:13 | c_schmitz | Status | resolved => closed |
2012-11-02 11:18 | c_schmitz | Changeset attached | => LimeSurvey 2.1 fcd11dbe |
2012-11-02 11:18 | c_schmitz | Note Added: 21899 |