[billing] CSV: Field 'invoice_csv_export_id' doesn't have a default value

Hi,
when I try to export a csv from ispconfig within the billing module, the export throws the message

Code:

invoice_csv_export_id' doesn't have a default value

Same error goes for the "CSV-Export-Definition".



The ispconfig_billing_2_manual_de (released 09-16-2016) doesn't have any entries for the CSV-Export function.

Is there anyone with a similiar problem or a solution?

 

After some debugging from Till, we've found the error which was related to two failed columns which has to be auto increment but they weren't.

If someone is facing the same problem just update your tables:

Login to mysql

Code:

mysql -u root -p

For the CSV Export Tab

Code:

USE dbispconfig;
ALTER TABLE invoice_csv_export MODIFY invoice_csv_export_id BIGINT auto_increment;

For the CSV Export Definition Tab:

Code:

ALTER TABLE invoice_csv_export_definition MODIFY invoice_csv_export_definition_id INT auto_increment;