c2c-oerpscenario team mailing list archive

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

Hi Saz,

Very strange.

This morning I deleted the server directory content and did a "bzr
revert" in order to resynchronise the server branch but I still have
that bug...

Furthermore, I do not use any custom server config file (I am using the
default config file and at least in the DB with demo data I didn't
create any new data).

Note I am using Ubuntu 10.10.04

-- 
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.