I have updated from the previous ispconfig billing module, 2.0.2p1 to the current one on ISPconfig 3.1.11, Billing module 2.0.3 During the install I get this error: ERROR 1062 (23000) at line 166: Duplicate entry '1' for key 'PRIMARY' ISPConfig Billing module has been installed. Generated invoices have blank items contents. The invoice isn't listed in the invoice list, but in the draft section. They have a total amount of $0, marked as paid, clicking on the item list produces this error: Unknown column 'commission' in 'field list' Thanks Stephen
I guess you run the install.php script instead of the update.php script to update your installation. That's not a big issue as the install.php does not harm, it just does not do the update so your database scheme has not been updated yet. Please redo the update and use update.php instead to install it.
Thanks Till, that has solved the unknown column and install error. The invoice is still stuck in the draft section though with the total at $0. Can you offer the best way to remove it?
Drafts always have a total of 0$ as the total gets calculated when an invoice gets finalized. Either finalize the invoice by pressing on save & Finalize button or delete the invoice by pressing on the delete button in the invoice draft list.
