BIlling module, with blank items.

Discussion in 'Plugins/Modules/Addons' started by vk3heg, Mar 19, 2018.

  1. vk3heg

    vk3heg Member

    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'

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  3. vk3heg

    vk3heg Member

    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?
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.

Share This Page