Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I'm in a right pickle! Following a Base upgrade.
Following a base upgrade - database has been corrupted, then to make things worse, the database backups have been missed
Anyone any ideas where to go,
Where to start?
Is their a tool to check your db?
IntegrityError: insert or update on table "wkf_workitem" violates foreign key constraint "wkf_workitem_inst_id_fkey" DETAIL: Key (inst_id)=(11789) is not present in table "wkf_instance".
suppose "inst_id" is primary key in XYZ table.
what has happend is, the records from your XYZ table( whose foriegn key is "inst_id") has been deleted which is leading to inconsistency of data,
For the easyness you can go with new DB, but as u want to stick with current ,so 2 possible things what u can do is:
1) create records with the id showing in error (in this case 11789) in table XYZ
2) delete the records where inst_id is the id showing in error(in this case 11789) using "delete from wkf_instance where inst_id = 11789"
This issue will keep on coming until u remove all the inconsistent data
Hope this help!!
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 8/10/16, 6:24 AM|
|Seen: 220 times|
|Last updated: 1/18/17, 6:42 AM|