Hello girls, guys, I'm very surprised with this and I don't know how get rid of it.
Migrating the partner contacts from 6.1 to 7 (OCB version), I exported, modified and imported the base. Everything went find , everything looked good when I was on the webpage Sales/Customers but when I clicked on one of the contact I get the following error :
2013-06-05 22:19:29,911 16463 ERROR dataup openerp.sql_db: Programming error: column res_partner_bank.active does not exist
LINE 1: ..._partner_bank".id FROM "res_partner_bank" WHERE (("res_partn...
^
, in query SELECT "res_partner_bank".id FROM "res_partner_bank" WHERE (("res_partner_bank"."active" = %s) AND ("res_partner_bank"."partner_id" in (%s))) ORDER BY "res_partner_bank"."sequence"
2013-06-05 22:19:29,911 16463 ERROR dataup openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/server/openerp/osv/orm.py", line 3605, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/opt/openerp/server/openerp/osv/orm.py", line 3725, in _read_flat
res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
File "/opt/openerp/server/openerp/osv/fields.py", line 536, in get
ids2 = obj.pool.get(self._obj).search(cr, user, domain + [(self._fields_id, 'in', ids)], limit=self._limit, context=context)
File "/opt/openerp/server/openerp/osv/orm.py", line 2354, in search
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/opt/openerp/server/openerp/osv/orm.py", line 4859, in _search
cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
res = self._obj.execute(query, params)
ProgrammingError: column res_partner_bank.active does not exist
LINE 1: ..._partner_bank".id FROM "res_partner_bank" WHERE (("res_partn...
^
2013-06-05 22:19:29,912 16463 ERROR dataup openerp.netsvc: column res_partner_bank.active does not exist
LINE 1: ..._partner_bank".id FROM "res_partner_bank" WHERE (("res_partn...
^
Traceback (most recent call last):
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/server/openerp/osv/orm.py", line 3605, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/opt/openerp/server/openerp/osv/orm.py", line 3725, in _read_flat
res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
File "/opt/openerp/server/openerp/osv/fields.py", line 536, in get
ids2 = obj.pool.get(self._obj).search(cr, user, domain + [(self._fields_id, 'in', ids)], limit=self._limit, context=context)
File "/opt/openerp/server/openerp/osv/orm.py", line 2354, in search
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/opt/openerp/server/openerp/osv/orm.py", line 4859, in _search
cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
res = self._obj.execute(query, params)
ProgrammingError: column res_partner_bank.active does not exist
LINE 1: ..._partner_bank".id FROM "res_partner_bank" WHERE (("res_partn...
I'd like to understand what happened. How may the import created that ? I tested he same import on another install of openerp 7 (official bazaar version) but the problem didn't happen. I had a try on a fresh database on v7-OCB (same install as the one used first) but same problem happened again.
Thanks