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

Post Terkait	Replies	Tampilan
Exception: bus.Bus unavailable Odoo 13 Community error log Odoo13.0	1 Agu 23	3098
During handling of the above exception, another exception occurred: Traceback (most recent call last): error log Odoo13.0	0 Agu 23	2535
Error in log Odoo 13 Community error log Odoo13.0	1 Agu 23	1700
Module produces blank screen but log doesn't show anything error log blankpage Odoo13.0	2 Jul 24	1354
Error in the log odoo 13 community error log base Odoo13.0	1 Agu 23	2383

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!