[storm] Query using count

akira nhytro-python at web.de
Thu Aug 9 11:10:19 BST 2007


Here I am again, you guys must be tired of this now. I installed the 
latest Storm version and I still get a traceback:

Traceback (most recent call last):
  File "D:\Projects\Pylons_projects\tests\my_tests\stom_test_5.py", line 
67, in ?
    test= store.execute(expr)
  File 
"C:\Python24\Lib\site-packages\storm-0.10-py2.4.egg\storm\store.py", 
line 90, in execute
  File 
"C:\Python24\Lib\site-packages\storm-0.10-py2.4.egg\storm\database.py", 
line 182, in execute
  File 
"C:\Python24\Lib\site-packages\storm-0.10-py2.4.egg\storm\databases\postgres.py", 
line 149, in raw_execute
  File 
"C:\Python24\Lib\site-packages\storm-0.10-py2.4.egg\storm\database.py", 
line 247, in raw_execute
psycopg2.ProgrammingError: column "_4.link" must appear in the GROUP BY 
clause or be used in an aggregate function


Any ideas?

Thanks

Gustavo Niemeyer wrote:
> Hi again Akira,
>
>   
>> psycopg2.ProgrammingError: syntax error at or near "GROUP"
>> LINE 1: ...ft >= _4.lft AND _5.lft <= _4.rgt ORDER BY _5.lft GROUP BY _...
>>     
>
> This is a bug fixed in 0.10, which will be released today.  Apologies.
>
>   




More information about the storm mailing list