Error column doesn't exist on custom module Odoo

Question

I'm working on a custom module and i need to add field to res.partner model. I've add some field to this model but since 1 week, when i try to add a new one i got this error :

ERROR: column res_partner.my_field does not exist

Other field works good but not this one :

my_field = fields.Boolean(default=False)

I really don't unterstand why i have this issue. I've try to add 'contacts' dependencies to my module, it have work on my local version but not on my online verison

If somone has any idea it could be really nice

Thanks for your help

Edit res.partner classe

from odoo import api, fields, models
    
class ResPartner(models.Model):
    _inherit = 'res.partner'
    
    badge_ids = fields.One2many('mymodule.badge','client_i
    sub_ids = fields.One2many('mymodule.subs','client_id')
    #field that doesn't work
    my_field = fields.Boolean(default=False)

Manifest dependencies

'depends': ['base', 'sale', 'website', 'calendar','contacts', 'point_of_sale', 'base_automation'],

Try to update the `base` module, or your own module with the update button from the interface (module form) — ChesuCR, Jun 01 '18 at 09:51
thak for you'r answer it's working but i really don't understand why this is happening — Martin Allimonier, Jun 05 '18 at 13:30
One tip, you do not need to add so many dependencies to your manifest file. Add only the leaf modules of the dependencies tree — ChesuCR, Jun 05 '18 at 13:43

kholioeg · Accepted Answer · 2018-07-25T21:53:18.390

6

Looks like a bug. Here's possible workaround:

Add 'res' to dependencies as well as 'base', then restart odoo instance.

after confirming fields updated; remove 'res' from dependencies then upgrade module.

This behavior exist on Odoo versions above 8.0

edited Jul 25 '18 at 21:53

answered Jul 25 '18 at 20:30

kholioeg

326
3
5

thanks @kholioeg this was useful to install, but i think it may have interfered with the uninstall, now when i uninstall it the columns may not have been deleted, is this possible? – bermick Jan 28 '21 at 20:51

score 5 · Answer 2 · answered Jun 01 '18 at 13:12

5

class Partner(models.Model):
    _inherit = "res.partner"

   my_field = fields.Boolean()

Note: Give 'base' as dependencies in manifest of your custom module.

answered Jun 01 '18 at 13:12

Bhoomi Vaishnani

718
4
19

Thanks for your answer, i've already put base as dependencies (he is by default i think) and i've inherit the res.partner model. I don t understand why 1 field is not working – Martin Allimonier Jun 04 '18 at 12:10
Can you put more code here so i can give you solution. – Bhoomi Vaishnani Jun 04 '18 at 13:02
i've had some code, updating base module looks working but i really don't understand why this is happening – Martin Allimonier Jun 05 '18 at 13:29

score 0 · Answer 3 · answered Feb 14 '19 at 04:55

I did this to solve it

Comment your custom fields in xml file
Add depands "base", "res" in your manifest
Restart odoo
Remove "res", "base"
Upgrade your custom module
Make sure new field added in the model that you want to inherit
Uncomment your field in xml file
Upgrade your custom module

Odoo 10

kholioeg · Answer 4 · 2019-11-02T13:00:36.103

0

UPDATE:

A good solution for that is to inherit the model as a new model and I assume this is the official solution as well:

Class ResPartner(models.model):
    _name = 'res.partner'
    _inherit = 'res.partner'

    my_field = fields.Char()

edited Nov 02 '19 at 13:00

answered Nov 02 '19 at 12:19

kholioeg

326
3
5

Error column doesn't exist on custom module Odoo

4 Answers4

Linked