Yii Framework Forum: Error Implementing Forum With Postgres - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Error Implementing Forum With Postgres column «t.is_sticky» must appears in a GROUP BY clause in POSTGRES Rate Topic: -----

#1 User is offline   Douglas Lopez 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 09-July 12

Posted 26 November 2012 - 02:43 PM

Attached File  forum.htm (23.13K)
Number of downloads: 0Thanks for your forum module. I am trying to run this extension with Postgres 8.4.

I did the conversion.

However, I have the following error:

column «t.is_sticky» must appears in a GROUP BY clause.

I tried to fix it using pgadmin only, as follows:

SELECT forum_id AS c, COUNT(*) AS s FROM thread t WHERE (t.forum_id=2) GROUP BY forum_id, is_sticky, t.created, t.subject ORDER BY is_sticky DESC, created DESC, subject

And in pgadmin, it worked.

I did the module generation of the 4 tables you use, very careful (only copying the differences in rules and relations - just adding them, leaving yours).

May be the error is accepted in Mysql but not in Postgres.

Question:

In what part of your module can I include the rest of group by fields? All of the following fields: GROUP BY forum_id, is_sticky, t.created, t.subject

Maybe you have a better idea how to fix this error.

Please find attached the corresponding html tracelog.

Please your help is needed.

Best Regards,

Douglas
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users