View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05056 | Bug reports | Other | public | 2011-03-25 19:02 | 2011-04-04 11:57 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | duplicate | ||
Product Version | 1.91RC5 | ||||
Summary | 05056: GSOC: Postgres incompatibility in /admin/admin.php?action=surveysecurity | ||||
Description | /admin/admin.php?action=surveysecurity yields: ERROR: column reference "uid" is ambiguous LINE 3: group by uid, users_name, full_name ^:SELECT p.*, u.users_name, u.full_name FROM "lime_survey_permissions" AS p INNER JOIN "lime_users" AS u ON p.uid = u.uid WHERE p.sid = 15648 AND u.uid != 3 group by uid, users_name, full_name ORDER BY u.users_name Postgresql requires any returned fields to appear in the GROUP BY statement or be used in an aggregate function (ie. min(), max(), etc), and also requires an unambiguous column reference even when columns are equal. The easiest solution would probably be to just drop the group by statement around line 1727 in admin/html.php (I'm not sure if that will cause duplicates). | ||||
Steps To Reproduce | Edit survey permissions while using a postgresql database. | ||||
Tags | No tags attached. | ||||
Bug heat | 0 | ||||
Complete LimeSurvey version number (& build) | 9872 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Postgresql 8.4 | ||||
Server OS (if known) | Debian squeeze | ||||
Webserver software & version (if known) | apache 2.2.16 with fcgid | ||||
PHP Version | 5.3.3-7+squeeze1 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2011-03-25 19:02 |
|
New Issue | |
2011-03-26 11:54 | c_schmitz | Assigned To | => c_schmitz |
2011-03-26 11:54 | c_schmitz | Status | new => assigned |
2011-03-26 17:41 | Mazi | Summary | Postgres incompatibility in /admin/admin.php?action=surveysecurity => GSOC: Postgres incompatibility in /admin/admin.php?action=surveysecurity |
2011-04-04 11:57 | c_schmitz | Relationship added | duplicate of 05047 |
2011-04-04 11:57 | c_schmitz | Status | assigned => closed |
2011-04-04 11:57 | c_schmitz | Resolution | open => duplicate |