Affiliate module error in database.pgsql.inc
| Project: | Affiliate |
| Version: | 6.x-1.3 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
When I go to my affiliate module section in Site Configuration, I seee the error msg:
warning: pg_query() [function.pg-query]: Query failed: ERROR: column "ad.enabled" must appear in the GROUP BY clause or be used in an aggregate function in /usr/local/www/beta.hub.org/www/includes/database.pgsql.inc on line 139.
user warning: query: SELECT ad.aid, ad.enabled, u1.name, count(au.uid) as referred FROM affiliate_details as ad LEFT JOIN users as u1 on ad.aid = u1.uid LEFT JOIN affiliate_users as au on ad.aid = au.aid GROUP BY ad.aid ORDER BY referred DESC LIMIT 50 OFFSET 0 in /usr/local/www/beta.hub.org/www/modules/affiliate/affiliate.module on line 329.
What should I do to fix this?adding ad.enabled in the group by clause of affiliate.module did not help...
Thanks
Dee