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

Discussion in 'ISPConfig 3 Priority Support' started by sascha92, Jun 6, 2020.

  1. sascha92

    sascha92 New Member HowtoForge Supporter

    when I try to export a csv from ispconfig within the billing module, the export throws the message
    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?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That's probably an issue with the MariaDB version and SQL strict mode. Please send me an email to info at ispconfig dot org with your system setup details incl. php version and mariadb version details and I'll check how to fix that.
    sascha92 likes this.
  3. sascha92

    sascha92 New Member HowtoForge Supporter

    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
    mysql -u root -p
    For the CSV Export Tab
    USE dbispconfig;
    ALTER TABLE invoice_csv_export MODIFY invoice_csv_export_id BIGINT auto_increment;
    For the CSV Export Definition Tab:
    ALTER TABLE invoice_csv_export_definition MODIFY invoice_csv_export_definition_id INT auto_increment;
    till likes this.

Share This Page