cannot save a newly added product

Asked by Pravitha V

hello everyone,
i just added a new custom field in x_mpq2 in product object.
when i saved it.the custom field automatically changed to base field.
then when i try to add a new product and save it it shows the following error:

Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 489, in dispatch
result = ExportService.getService(service_name).dispatch(method, auth, params)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3651, in create
cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
res = self._obj.execute(query, params)
ProgrammingError: column "x_mpq2" of relation "product_product" does not exist
LINE 1: ...efault_code","variants","track_incoming","x_mpq1","x_mpq2","...

please help its urgent.................................

_________________
Regards,
Nightfury

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
Pravitha V
Solved:
Last query:
Last reply:

This question was reopened

Revision history for this message
Pravitha V (pravithavarghese1) said :
#1

hey my problem got solved.
its because the field x_mpq2 was not added to the database. i added it to database and my problem got solved.

_________________
Regards,
Nightfury

Revision history for this message
Pravitha V (pravithavarghese1) said :
#2

but still anyone know why a custom field automatically changes to base field

Revision history for this message
Pravitha V (pravithavarghese1) said :
#3

thanks my prob got solved a custom field changes to base field when columns are defined in the .py file........