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. Thanks, Stephen
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: Code: ALTER TABLE `invoice_client_settings` CHANGE `account` `account` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
Thanks Till, as always your advice is spot on! What is the current Billing Module version? Thanks, Stephen
This seems to be the latest release note in ISPConfig blog: https://www.ispconfig.org/blog/ispconfig-billing-module-2-0-4-released/
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.
