search

yii2mod / yii2-comments

Comments module for Yii2
MIT License
158 stars 63 forks source link

Database Exception #45

Closed carlosgarcia8 closed 7 years ago

carlosgarcia8 commented 7 years ago

I've been trying to work with this extension but when I try to see comments/index it says "SQLSTATE[42803]: Grouping error: 7 ERROR: column "a.username" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "c"."createdBy", "a"."username" FROM "comment" "c" LE..." getAuthors()

I'm using Postgresql and I don't know if that's the problem. Thanks for the help.

morontt commented 7 years ago

@carlosgarcia8 Thanks for your feedback. Work in progress

morontt commented 7 years ago

@carlosgarcia8 Fixed