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?

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 · 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

Gerelateerde posts	Antwoorden	Weergaven
Project module or fields field	0 feb. 25	2580
extra checkout step field	0 jan. 25	2221
Field service upgrade Opgelost field	1 dec. 24	2830
creation of company Opgelost company	1 okt. 24	13590
Not able to create new company in live database in version 15 company	0 okt. 22	3251

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!