Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
hi . i create a model named x_customer it has two field x_custprice and x_custproduct and creating the form view,tree view for this. while entering values to this field an error message is shown like this.
ProgrammingError: column "x_custprice" of relation "x_customer" does not exist LINE 1: insert into "x_customer" (id,"x_custprice","x_custproduct",c...
please help me to find the problem
create the module like this,
{
'name': 'Inheritance Error Solving',
'version': '1.1',
'category': 'Generic Modules',
'description': """
Product master two field adding
""",
'author': 'Sridhar',
'depends': ['base','product'],
'update_xml': ['product_inheritance_view.xml'],
'installable': True,
'active': False,
}
save this file __openerp__.py
import time
from datetime import datetime, timedelta
from openerp.osv import fields, osv
from tools.translate import _
class product_inheritance(osv.osv):
_inherit = 'product.product'
_columns = {
'x_custproduct':fields.char('Product',size=8),
'x_custprice':fields.integer('Price'),
}
product_inheritance()
save this file as product_inheritace.py
<?xml version="1.0"?>
<openerp>
<data>
<record model="ir.ui.view" id="product_order_formss">
<field name="name">product.product.form</field>
<field name="model">product.product</field>
<field name="type">form</field>
<field name="inherit_id" ref="product.product_normal_form_view"/>
<field name="arch" type="xml">
<field name="name" position="after">
<group>
<field name="x_custproduct"></field>
<field name="x_custprice"></field>
</group>
</field>
</field>
</record>
</data>
</openerp>
save this file as product_inheritance_view.xml it will work
finally __init__.py in this py file add the line
import product_inheritance
dont do base file if do base file means it make error so inherit the file and do ur customization.
thanks....
vote me for my future reference...
sir i need another help.
do you help me in my new question
ask me... answer correct means put right mark.
ok. question is posted.
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
update ur code here or clear error message show me.
OpenERP Server Error Client Traceback (most recent call last): File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server\openerp\addons\web\http.py", line 204, in dispatch File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server\openerp\addons\web\controllers\main.py", line 1129, in call_kw File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server\openerp\addons\web\controllers\main.py", line 1121, in _call_kw File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server\openerp\addons\web\session.py", line 43, in proxy File "C:\Program Files\OpenERP 7.0-2013
Server Traceback (most recent call last): File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server\openerp\addons\web\session.py", line 90, in send File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server.\openerp\netsvc.py", line 293, in dispatch_rpc File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server.\openerp\service\web_services.py", line 626, in dispatch File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server.\openerp\osv\osv.py", line 188, in execute_kw File "C:\Program Files\OpenERP 7.0-20130509-231040\Server\server.\openerp\osv\osv.py"
ProgrammingError: column "x_custprice" of relation "x_customer" does not exist LINE 1: insert into "x_customer" (id,"x_custprice","x_custproduct",c... ^
send ur xml file and py file
Tree view. <?xml version="1.0"?> <tree string="Purchase Order" version="7.0">
Form view. <?xml version="1.0"?> <form string="Purchase Order" version="7.0"> <group> <field name="x_custproduct"/> <field name="x_custprice" /> </group> </form>
i did n't have the py file.
dont having py means how it will work
i just create a new model, then create 2 fields then add it under to a menu. Edited the corresponding views and add the field names to it ( above mentioned form view and tree view).
in purchase order which place do u want this fields...
i dont want these in purchase order. I just created it as a new module..
that means no inheritance correct.
here no relation with inheritance. just created a UI for adding product, price , it will be displayed , product will be listed under the product. But cant able to save. At that time the above mentioned error will be displayed
i think concept is wrong u didn't inherit means how it will work... u doing a which module, product or purchase...
products..