c2c-oerpscenario team mailing list archive

["Bernard Renier \(NODALIA\)" <689382@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
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:
  New

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.