Added new client limit error

Discussion in 'General' started by vk3heg, Aug 8, 2020.

  1. vk3heg

    vk3heg Member

    Hi Guys,
    Late last year I used the migration tool to migrate to a new Debain10 install. Everything worked as it should.

    I have now added a new client, and when attempting to set account limits I get this error
    "Field 'account' doesn't have a default value".

    They are also not showing up as a client in the billing module.
    What do I need to look for to fix the issue? I have done a "Client Database config"resync from the tools menu.

    Last edited: Aug 8, 2020
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The migration tool is not related to your problem. The reason for the problem Is that the Billing Module version that you have installed is not compatible with the installed mariaDb version or in other words, the MariaDB version is too new for the installed billing version. You can work around that issue by running this command in the dbispconfig database with phpmyadmin:

    ALTER TABLE `invoice_client_settings` CHANGE `account` `account` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
    vk3heg likes this.
  3. vk3heg

    vk3heg Member

    Thanks Till, as always your advice is spot on!
    What is the current Billing Module version?

  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  5. vk3heg

    vk3heg Member

    That blog is a bit outdated. I have an archive of 2.0.5 with dates on the files being August 14th 2018. The installed files from the billing module also match those dates. When I go to the setting in the billing module it reports REV-35.
  6. till

    till Super Moderator Staff Member ISPConfig Developer


Share This Page