Table name is too long odoo 13

Question

I am getting this error after adding a binary filed I remover the filed but getting the same error

Table name 'n_hesaby_subscription_manager_subscription_manager_res_users_rel' is too long

odoo.exceptions.ValidationError: ("Table name 'n_hesaby_subscription_manager_subscription_manager_res_users_rel' is too long", None) - - -

does anyone know what it means, I can't find it

@sn thank you for replying does that mean that I need to shorten `_name` — Moaz Mabrok, Jun 30 '20 at 18:17

Charif DZ · Accepted Answer · 2020-06-30T22:46:35.463

From the look of the table name it's created from a many2many field between n_hesaby_subscription_manager_subscription_manager and res.users when you don't provide a name for the relation table Odoo will generate it for you model_1_name_model_2_name_rel.

So in your many2many definition specify a shorter name

    m2m_field_name = fields.Many2many(comodel_name='res.users', 
           relation='put_nice_table_name_here',  
           column1='put_nice_and_short_field_name_here_to', 
           column2='user_id', 
           string='You field label')

I'm using my phone sorry for my short answer I hope you get the idea, you can check Odoo standard modules you will find planty of examples. Always specify the name of the relation in your many2many field is a good practice prevent unexpected behavior.

No you don't need to specify them, odoo will choose there names if you don't specify them. The only required argument is comodel_name — Charif DZ, Jul 02 '20 at 06:32

Table name is too long odoo 13

1 Answers1