Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
3 Odpowiedzi
2603 Widoki
Awatar
Thomas G

HI,

I have deleted some products that was added by the system. And now whenever try to enter the settings panel, it does not work and throws the error: Missing record.

The questions I have is:

1. How to find out which are these missing records (people are having the same problem with deleting the down payment product) 

2. Where can I change the setting for down payment product id (maybe I can add a product with name downpayment and then change the product_id). I have looked at the database, and I see res_config_settings is suppose to hold the configuration settings?  


I see this is a common error people are having in this forum but, can not find any exact answer in the forum on how to actually fix it, apart from reinstalling the whole database, which is not really the solution I am looking for. I want to just reenter the missing records, or be able to change the setting so that it does not completely break the settings page for every app.


Any help is appreciated.

Awatar
Odrzuć
Ermin Trevisan

Please use a meaningful title to your question.

Awatar
Thomas G
Autor Najlepsza odpowiedź

If it is going to break the whole system why have the option to delete it anyway, at least it should reset the configuration before deleting it, or throw some warning at least, then it does not end up breaking the whole application so easily.

Awatar
Odrzuć
Awatar
Ermin Trevisan
Najlepsza odpowiedź

For this kind of objects it is important to have the proper Record-ID in the database (such as with the user admin for example, which must be the user with Record-ID 1). I would try the following:

1. Create a new database

2. Manually create a copy of the corresponding products in the old database

3. In the Postgres-Database try to change the ID of the new records in the old database to the IDs found in the new database. I did not test that, but it should give you the idea. Maybe you would also have to update some foreign keys.

To avoid such issues in the future please keep in mind that with ERP-Systems it is not recommended to delete any objects because of the manifold interdependencies in the data model. Instead of deleting, do deactivate/archive.

Awatar
Odrzuć