Skip to Content
This question has been flagged
odoo8.0
4 Respostes
13820 Vistes
Avatar
Tazan

I have a model

class fbv_use_carrier(models.TransientModel):

pickings = fields.Many2many('stock.picking', 'fbv_use_carrier_line', 'fbv_id', 'picking_id', 'Picking List') 
 class fbv_use_carrier_line(models.TransientModel):
 _name='fbv.use.carrier.line'


 picking_id = fields.Many2one('stock.picking', string='List Piking')
 fbv_id = fields.Many2one('fbv.use.carrier', string='FBV Use Carrier ID'

But i have error!

 ProgrammingError: column "id" does not exist
LINE 1: SELECT id FROM fbv_use_carrier_line WHERE COALESCE(write_dat...

Hoping for some feedback!

Thanks

Avatar
Descartar
Emipro Technologies Pvt. Ltd.

Did you defined name for your class ? like _name = 'fbv.use.carrier'

Avatar
Emipro Technologies Pvt. Ltd.
Best Answer

Hello,

Your problem is "very very" simple,

Solution : 

Just modify the name of table in M2M field definition. Like as below, ( I have marked as bold + italic + underline )

pickings = fields.Many2many('stock.picking', 'fbv_use_carrier_line', 'fbv_id', 'picking_id', 'Picking List')

Reason of Error :

When you define many2many field, 2nd argument creates the table. Now you have given the same name of the table which you have used while defining following class, ( I have marked bold + italic + underline )

class fbv_use_carrier_line(models.TransientModel):
_name='fbv.use.carrier.line'
picking_id = fields.Many2one('stock.picking', string='List Piking')
fbv_id = fields.Many2one('fbv.use.carrier', string='FBV Use Carrier ID'

By adding same name of new M2M table, system overrides new table definition and of course "ID" column will be removed. ( FYI : M2M table stores only 2 columns ). That is why when system evaluates following line,

fbv_id = fields.Many2one('fbv.use.carrier', string='FBV Use Carrier ID'

it shows you error. ( ProgrammingError: column "id" does not exist )

Hope this answer will lead to exact solution of your problem !

Avatar
Descartar
Avatar
DWARKANATH BARI
Best Answer

Hello I have issue above error while installing ecommerce module.

psycopg2.ProgrammingError: column s.warehouse_id does not exist
LINE 34:         , s.website_id as website_id, s.warehouse_id as ware...


Avatar
Descartar
Avatar
Serpent Consulting Services Pvt. Ltd.
Best Answer

Tazan,

You probably have misunderstood the concept of Many2Many. Its used when you are linking an existing records of another model.

What I read from your code is, you are trying to establish the one2many relation to lines, but you miss it. One2many is used to link multiple lines on dynamism.

If you have written the one2many field, the reference field should be named as fbv_id which is defined as Many2one in carrier lines.

carrier_line_ids = fields.One2many('fbv.use.carrier.line','flv_id', 'Lines').

Hope this helps.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
how to implement joint piece in odoo 8 in one view
odoo8.0
Avatar
0
d’abr. 24
2765
what is the reason behind extra move? in stock
odoo8.0
Avatar
Avatar
Avatar
Avatar
4
de nov. 23
6940
How to solve fields.function issue in odoo 8
odoo8.0
Avatar
0
d’oct. 23
2775
how to restrict create and delete access in one2many field tree view
odoo8.0
Avatar
0
de des. 22
3513
odoo8 How to pass parameters in the URL ? Solved
odoo8.0
Avatar
Avatar
Avatar
2
de des. 23
20976