Hi all,
I want to add new field (many2one) in form view of res.partner but i got ERROR DataError: invalid input syntax for integer: "default" LINE 1: ...om.id FROM "travel_room" WHERE travel_room.id IN ('default')... :
in my model i create partner.py :
from osv import osv,fields
class partner(osv.osv):
_inherit = 'res.partner'
_columns = {
'hotel' : fields.boolean('Hotel'),
'type' : fields.many2one('travel.room', 'type de la chambre', change_default=True, select=True, track_visibility='always', ondelete="cascade"),
}
partner()
and my partner_view.xml :
<openerp> <data> <record model="ir.ui.view" id="partner_hotel_form_view">
<field name="name">partner.hotel.name</field>
<field name="model">res.partner</field>
<field name="inherit_id" ref="base.view_partner_form" />
<field name="arch" type="xml">
<data>
<field name="supplier" position="after">
<field name="hotel" />
</field>
<field name="customer" position="after">
<field name="type" />
</field>
</data>
</field>
</record>
</data> </openerp>
and here my class travel_room :
class travel_room(osv.osv):
_name = 'travel.room'
_columns = {
'product_id' : fields.many2one('product.product', 'Type de la chambre', required=True, change_default=True, select=True, track_visibility='always', ondelete="cascade"),
'name' : fields.related('product_id', 'name', type='char', size=128, string='Product Name'),
'room_desc' : fields.many2one('product.category', 'Descripcion', required=True, ondelete='cascade'),
'cost_price' : fields.float('Prix de revient', digits=(6,3), help="Prix de revient"),
'sale_price' : fields.float('Prix d\'achat', digits=(6,3), help="Prix d'achat"),
}
_defaults = {
}
travel_room()
any one can help me Please! Thank you
Any reason for the blank _defaults dictionary? What version are you running? You could run the server with the command line option --log-sql to expand on what that full statement is.
Hi Brett, i'm using version 7 of openerp , I removed the blank _defaults dictionary and I got same error : 2013-05-16 09:14:46,340 6896 ERROR test openerp.sql_db: bad query: SELECT travel_room."product_id",travel_room."sale_price",travel_room."cost_price",travel_room."room_desc",travel_room.id FROM "travel_room" WHERE travel_room.id IN ('default') ORDER BY id Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20130331_231656-py2.7.egg/openerp/sql_db.py", line 22