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

관련 게시물	답글	화면
Exception: bus.Bus unavailable Odoo 13 Community error log Odoo13.0	1 8월 23	3163
During handling of the above exception, another exception occurred: Traceback (most recent call last): error log Odoo13.0	0 8월 23	2579
Error in log Odoo 13 Community error log Odoo13.0	1 8월 23	1723
Module produces blank screen but log doesn't show anything error log blankpage Odoo13.0	2 7월 24	1411
Error in the log odoo 13 community error log base Odoo13.0	1 8월 23	2422

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!