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

Publicaciones relacionadas	Respuestas	Vistas
Project module or fields field	0 feb 25	2295
extra checkout step field	0 ene 25	1997
Field service upgrade Resuelto field	1 dic 24	2557
creation of company Resuelto company	1 oct 24	13323
Not able to create new company in live database in version 15 company	0 oct 22	3060

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!