After I deleted a validated invoice, I can validate an invoice again

Hello,
I deleted a validated invoice then I have created another one and tried to validate it but Dolibarr throw this error

Duplicate entry 'facture/AAA-0004-AAA-0004_invoice.odt-1' for key 'uk_ecm_files'

keep in mind that the DMS / ECM module was deactivated.
I’m stuck and I can’t validate invoices anymore. Please help! :confused:

Thank you in advance,
Olga

How did you delete your invoice ? From interface ? Which Dolibarr version ?

Hi ,
Version 10.0.2

Yes i deleted from the interface

So, I solved it.

Open my database, found the table ecm_files and then manually deleted the entries with the number that my invoice was stuck(there was two entries). So everything is working now. :slight_smile:

How did you do that?