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 09:26 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 09:26 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 |