Skip to Content
Menu
This question has been flagged
3 Replies
835 Views

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?

Avatar
Discard
Best 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: 

Avatar
Discard
Best Answer

Restart with "-u all" :)

Avatar
Discard
Best 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


Avatar
Discard
Related Posts Replies Views Activity
0
Feb 25
714
0
Jan 25
604
1
Dec 24
869
1
Oct 24
11931
0
Oct 22
1749