Programming error: column product_product.valuation does not exist

Bug #1290471 reported by Stephan Levenhagen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Serv. Baeza OpenERP addons
Invalid
Undecided
Unassigned

Bug Description

I have Installed module and get error when attempting to select product on Recurring order lines:

 Programming error: column product_product.valuation does not exist

full trace back

2014-03-10 17:37:09,560 23879 ERROR 7_0_multi_comp openerp.sql_db: Programming error: column product_product.valuation does not exist
LINE 1: ...oduct."active",product_product."track_production",product_pr...
                                                             ^
, in query SELECT product_product."ean13",product_product."color",product_product."price_extra",product_product."default_code",product_product."name_template",product_product."track_outgoing",product_product."product_tmpl_id",product_product."project_id",product_product."price_margin",product_product."track_incoming",product_product."variants",product_product."active",product_product."track_production",product_product."valuation",product_product."product_tmpl_id",product_product.id FROM "product_product" WHERE product_product.id IN %s ORDER BY default_code,name_template
2014-03-10 17:37:09,562 23879 ERROR 7_0_multi_comp openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/7.0/addons/product/product.py", line 689, in name_search
    result = self.name_get(cr, user, ids, context=context)
  File "/opt/openerp/7.0/addons/product/product.py", line 657, in name_get
    'name': product.name,
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 497, in __getattr__
    return self[name]
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 405, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 3674, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 3726, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/opt/openerp/7.0/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/7.0/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column product_product.valuation does not exist
LINE 1: ...oduct."active",product_product."track_production",product_pr...
                                                             ^

2014-03-10 17:37:09,568 23879 ERROR 7_0_multi_comp openerp.netsvc: column product_product.valuation does not exist
LINE 1: ...oduct."active",product_product."track_production",product_pr...
                                                             ^
Traceback (most recent call last):
  File "/opt/openerp/7.0/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/7.0/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/7.0/addons/product/product.py", line 689, in name_search
    result = self.name_get(cr, user, ids, context=context)
  File "/opt/openerp/7.0/addons/product/product.py", line 657, in name_get
    'name': product.name,
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 497, in __getattr__
    return self[name]
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 405, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 3674, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 3726, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/opt/openerp/7.0/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/7.0/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column product_product.valuation does not exist
LINE 1: ...oduct."active",product_product."track_production",product_pr...

Revision history for this message
Stephan Levenhagen (slevenhagen) wrote :

I Believe this is solved, seems to be corupted DB . I retested in a fresh database with demo data this works without error.

thanks

Changed in serviciosbaeza-openerp-addons:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.