Error psycopg2

Question

psycopg2.errors.UndefinedColumn: column res_company.branch_id does not exist LINE 1: ...ry_color", "res_company"."email_secondary_color", "res_compa..

I want to add a new field, after adding it an error appears as above. why and how to overcome it?

Bigscal, Mukesh Gehlot · Accepted Answer

A Simple Solution for it:
Whenever you add a custom field and get an error like this, do "*-u all*" in your localhost or service file. It will update all the modules.
Hope you like it:

Bit Level Code, Bit Level Code · Answer

Restart with "-u all" :)

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

If you encounter this error after adding a new field, first upgrade the custom module where the new field was defined.
If
the issue still persists even after upgrading, you can manually add the
missing column by connecting to your database and running the following
SQL command:

ALTER TABLE res_company ADD COLUMN branch_id integer;

Hope it helps

Related Posts	Replies	डेटा देखने का तरीका
Project module or fields field	0 फ़र॰ 25	2719
extra checkout step field	0 जन॰ 25	2342
Field service upgrade Solved field	1 दिस॰ 24	2977
creation of company Solved company	1 अक्तू॰ 24	13708
Not able to create new company in live database in version 15 company	0 अक्तू॰ 22	3293

This question has been flagged

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