c2c-oerpscenario team mailing list archive

["Saz\(OpenERP\)" <689382@xxxxxxxxxxxxxxxxxx>]

Hello,

I have checked the issue with the latest code on my end. Fortunately it
works fine. Would you please check this with the latest code. If you
have customized anything in server then let us know about it.

Thanks.

** Changed in: openobject-server
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/689382

Title:
  [6.Trunk] Access to configuration of res.partner.category leads to an error

Status in OpenObject Server:
  Incomplete

Bug description:
  Hi,

Last revision: 3099.

I have put this in server branch as res.partner.category is in base module.

When trying to access the configuration of res.partner.category via Sales> Configuration > Address book > Partner categories, the following error message appears:


[2010-12-12 20:30:10,920][rausch_1] ERROR:db.cursor:Programming error: column "parent_left" does not exist
LINE 1: ... (res_partner_category.active = E'True') ORDER BY parent_lef...
                                                             ^
, in query SELECT "res_partner_category".id FROM "res_partner_category" WHERE (res_partner_category.active = %s) ORDER BY parent_left  limit 100
[2010-12-12 20:30:10,921][rausch_1] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/bernard/openerp/trunk/server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/bernard/openerp/trunk/server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/bernard/openerp/trunk/server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/bernard/openerp/trunk/server/bin/osv/orm.py", line 1861, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/bernard/openerp/trunk/server/bin/osv/orm.py", line 4086, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/bernard/openerp/trunk/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/bernard/openerp/trunk/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "parent_left" does not exist
LINE 1: ... (res_partner_category.active = E'True') ORDER BY parent_lef...
                                                             ^

This error has been occurs in DBs with and without demo data.