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

Powiązane posty	Odpowiedzi	Widoki
Project module or fields field	0 lut 25	2310
extra checkout step field	0 sty 25	1999
Field service upgrade Rozwiązane field	1 gru 24	2581
creation of company Rozwiązane company	1 paź 24	13328
Not able to create new company in live database in version 15 company	0 paź 22	3069

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!