How can I prevent this error message: Table 'crm_lead': unable to set NOT NULL on column 'partner_id'

Question

When I update the modules I get this error message:
Table 'crm_lead': unable to set NOT NULL on column 'partner_id'
What should I do to prevent it?
Thank you in advance! :)

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Probably you have some records in the database, which violates this constrains, ie, there will be few records in db that doesn't have a partner set in it.
If you need to remove this message from log, update existing leads in the db by setting a partner to it. Or move the required attribute you have added in the model level or to the view level.

Thanks

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi*,*
There is no required or NOT NULL on crm.lead's
partner_id field in Odoo default code. So you probably have custom
modules changing that.
Hope it helps

Related Posts	Odgovori	Prikazi
Exception: bus.Bus unavailable Odoo 13 Community error log Odoo13.0	1 avg. 23	3109
During handling of the above exception, another exception occurred: Traceback (most recent call last): error log Odoo13.0	0 avg. 23	2551
Error in log Odoo 13 Community error log Odoo13.0	1 avg. 23	1708
Module produces blank screen but log doesn't show anything error log blankpage Odoo13.0	2 jul. 24	1386
Error in the log odoo 13 community error log base Odoo13.0	1 avg. 23	2388

This question has been flagged

Enjoying the discussion? Don't just read, join in!