Skip to Content
This question has been flagged
3 Replies
2148 Views
Avatar
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.

Avatar
Discard
Ermin Trevisan

Please use a meaningful title to your question.

Avatar
Thomas G
Author Best Answer

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.

Avatar
Discard
Avatar
Ermin Trevisan
Best Answer

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.

Avatar
Discard