How to avoid "Field does not exist in model" error when deleting a field

Question

So my problem is that i sometimes get the error "field does not exist in model" when i delete a field in both the python file and the view. I checked that there is no remaining reference to this field and the error i get says somewhere inside the view where i deleted the field. It seems that somehow the old view gets used while the new python file is used to start my odoo server.

I usually solve this error by creating a new database where everything runs fine but i want to solve it without crea

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
If the database is accessible, you can navigate to the views folder and see if the field existing in any of the views of the corresponding model.
While searching in views, ensure to search inside View Architecture, if you find any views having the field, delete the usage of the field from the view.
If the above doesn't solve the case, consider upgrading module from command line.

Thanks

Jainesh Shah(Aktiv Software) · Answer

Hello Fr4sha,

When deleting a field , you may notice that some data still remains, which can lead to errors.

To resolve this error, you can run the following command in the terminal:

psql your_database_name

After that, enter the following command:

ALTER TABLE table_name DROP COLUMN IF EXISTS column_name;

In this command, please replace table_name with the name of your model (remember to replace any periods with underscores) and column_name with the name of the field you want to delete.

André Canilho · Answer

Make sure you removed the field from all templates, and functions or methods where you referenced it.
A simple search could help you identify all the locations you've used your field.
As a rule of thumb, make sure you are correctly updating the files you changed, when running the server. use "-u all" (update all)  just to be sure

Powiązane posty	Odpowiedzi	Widoki
delete fields from database without uninstall? Rozwiązane fields database	4 gru 24	32317
Iterate over batch of dynamic fields in openerp Rozwiązane views fields	1 mar 15	6157
Why does the server need to restart after creation of new DB? server database	0 mar 15	4538
When should Database be separated on Separate Server. Rozwiązane server database postgresql	1 lip 25	4481
Why in Selection Field Only Key is Store in Database Not the Value ? Rozwiązane fields database selection	1 gru 24	2488

To pytanie dostało ostrzeżenie

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