ProgrammingError: (1111, 'Invalid use of group function') HELP

[Ali Kusnadi]

hi ...
i'm a trouble with cnprog .. i use django 1.1 and a problem with reputation

/users/2/adi?sort=reputation

aught an exception while rendering: (1111, 'Invalid use of group function')

Original Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/django/template/debug.py",
line 71, in render_node
result = node.render(context)
File "/usr/lib/python2.5/site-packages/django/template/defaulttags.py",
line 126, in render
len_values = len(values)
File "/usr/lib/python2.5/site-packages/django/db/models/query.py",
line 81, in __len__
self._result_cache = list(self.iterator())
File "/usr/lib/python2.5/site-packages/django/db/models/query.py",
line 756, in iterator
for row in self.query.results_iter():
File "/usr/lib/python2.5/site-packages/django/db/models/sql/query.py",
line 287, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/lib/python2.5/site-packages/django/db/models/sql/query.py",
line 2369, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/python2.5/site-packages/django/db/backends/util.py",
line 19, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python2.5/site-packages/django/db/backends/mysql/base.py",
line 84, in execute
return self.cursor.execute(query, args)
File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line
166, in execute
self.errorhandler(self, exc, value)
File "/var/lib/python-support/python2.5/MySQLdb/connections.py",
line 35, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1111, 'Invalid use of group function')

and template eror in templates/user_reputation.html, error at line 28

{% for rep in reputation %}

please help me

best regards
ali kusnadi

[Mike Chen]

Ali,

Have you checked to pull latest version from master repository?

It seems we fixed this at:

http://github.com/cnprog/CNPROG/commit/cdc9a8d21ab06416fb65d7b991144bbb23c0fa18

Regards,
-Mike

[Ali Kusnadi]

On 9/6/09, Mike Chen <cha...@gmail.com> wrote:
> Ali,
> Have you checked to pull latest version from master repository?
> It seems we fixed this at:
> http://github.com/cnprog/CNPROG/commit/cdc9a8d21ab06416fb65d7b991144bbb23c0fa18
>
> Regards,
> -Mike

hi.. mike

many tanks for you respons ..

i can try it

thanks

regards
ali kusnadi

> >
>