DB corruption after a directly copy of the DB files

Support
1

Hi everyone,

I had version 1.5.9 running on a docker environment, but had a problem not related with InvoicePlane. The thing is that I didn’t have a backup of the DB, and finally I could copy the files of the DB directly from the directory (/var/lib/mysql/my_db).

Now I have same version runing on a normall installation. An I can access to the app and see the values of DB, but when I try to access to the links (invoices and clients), I had this error:

db_error_invoiceplane
db_error_invoiceplane1823×778 79.8 KB

Can you help to fix it, any idea?

2

There is two tables that “doesn’t” exists in engine:

  • ip_invoice_custom
  • ip_client_custom

And both tables have they’re .frm and .idb file on the directory of the DB.