Hi I've installed the Billing Module following the manual and it is loaded and available ok in the interface, but I can't get it to display my existing clients. I have also tried re-saving all the clients, but that hasn't helped. Is there anything else I should try do? Cheers Steve
Run Tools > Resync for the clients in ISPConfig to import the old client data into the Billing module.
Thanks Till, but I tried that. Was wondering I had to put my license key anywhere or something like that?
That's not necessary. We send the key just because there will be a new update function in future inside the billing module which will then require the key to authenticate the update download. The existing clients show up in the normal client module but not in the Billing module client list and also not in the client select fields in form in the billing module, right? This normally means that the invoice_client_settings table does not contain entries for the old clients yet which can be fixed by using the resync tool. May you please have a look in the invoice_client_settings table in the dbispconfig database if it contains all clients or if the old ones are missing there.
@concept21: I haven't got that far yet, but it will be PayPal. @till: The invoice_client_settingstable table is empty.
Please try this: Run the following sql query with phpmyadmin in the dbispconfig database: Code: ALTER TABLE `invoice_client_settings` CHANGE `account` `account` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; Then use Tools > resync again to resync the clients.
May I ask you which OS and MySQL/MariaDB version do you use? I don't have that issue here on my test systems, I guess it's caused by a newer database version.