View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
05056Bug reportsOtherpublic2011-04-04 11:57
Reporteruser13004Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionduplicate 
Product Version1.91RC5 
Summary05056: 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.

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)9872
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 8.4
Server OS (if known)Debian squeeze
Webserver software & version (if known)apache 2.2.16 with fcgid
PHP Version5.3.3-7+squeeze1

Relationships

duplicate of 05047 closedc_schmitz GSOC: Survey permissions 

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2011-03-25 19:02 user13004 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