product_product order by name error

[Ferdinand]

trying to sort the product list by name (which is inherited from product_templates )
creates a servside sort
"order by name ASC" which can't work.....

Traceback (most recent call last):
  File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 61, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 120, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 112, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/terp/OpenERP/branch/server/5.0/bin/osv/orm.py", line 2928, in search
    cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_by+limit_str+offset_str, qu2)
  File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 120, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "name" does not exist
LINE 1: ..." where (product_product.active = E'True') order by name ASC

[Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan)]

A Dilluns, 9 de novembre de 2009, Ferdinand @ ChriCar va escriure:
> Public bug reported:
>
> trying to sort the product list by name (which is inherited from
> product_templates ) creates a servside sort
> "order by name ASC" which can't work.....
>
> Traceback (most recent call last):
> File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 61, in
> wrapper return f(self, dbname, *args, **kwargs)
> File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 120, in
> execute res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
> File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 112, in
> execute_cr return getattr(object, method)(cr, uid, *args, **kw)
> File "/home/terp/OpenERP/branch/server/5.0/bin/osv/orm.py", line 2928, in
> search cr.execute('select %s.id from ' % self._table + ','.join(tables)
> +qu1+' order by '+order_by+limit_str+offset_str, qu2) File
> "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 76, in wrapper
> return f(self, *args, **kwargs)
> File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 120, in
> execute res = self._obj.execute(query, params)
> ProgrammingError: column "name" does not exist
> LINE 1: ..." where (product_product.active = E'True') order by name ASC

But it doesn't crash Koo does it? Koo already handles those cases and it knows
that in some circumstances it won't be able to sort.

>
> ** Affects: openobject-client-kde
> Importance: Undecided
> Status: New
>

--
Albert Cervera i Areny
http://www.NaN-tic.com
Mòbil: [phone]

[Ferdinand (office-chricar)]

Hmm - it crashes the server
I have to restart the server !!!

[Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan)]

A Dimarts, 10 de novembre de 2009, Ferdinand @ ChriCar va escriure:
> Hmm - it crashes the server
> I have to restart the server !!!
>

I doesn't sort in my here, either, but I don't have to restart the server at
all. Can you please ensure you can't work with it after trying to sort by that
field?

--
Albert Cervera i Areny
http://www.NaN-tic.com
Mòbil: [phone]

[Ferdinand (office-chricar)]

I reinstalled koo.zip - apparently I didn't do that for all databases
do you see a possibility to integrate the revision number into the zip.file so it's possible to see it in OpenERP module list?
it's a pain to keep track in which db which modules are installed

get the error in log file.
but do not have to restart.