Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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?
Know anyone!
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".
Cameron,
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
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Many thank Pawan - I think your spot on.
It appears 100s of records have been lost.
We have decided to bite the bullet and re-enter a lot of data into our last backup :( A lot of midnight oil for me :(
thats nice.. atleast you got u save some of ur data!! your "midnight oil" got worth ;)