Ticket #1057 (No default value for column domain.external_mail_dns_ids - new customers ...) created

  • [feedquote='Trac','http://trac.i-mscp.net/ticket/1057']

    How to repeat:
    Create any new customer.

    How to fix (for me):
    alter table domain alter column external_mail_dns_ids set default ;

    Bug report summary:
    An exception with the following message has been thrown in file /var/www/imscp/gui/library/shared-functions.php (Line: 2551):

    SQLSTATE[HY000]: General error: 1364 Field 'external_mail_dns_ids' doesn't have a default value

    Query was:

    INSERT INTO domain ( domain_name, domain_admin_id, domain_created, domain_expires, domain_mailacc_limit, domain_ftpacc_limit, domain_traffic_limit, domain_sqld_limit, domain_sqlu_limit, domain_status, domain_alias_limit, domain_subd_limit, domain_ip_id, domain_disk_limit, domain_disk_usage, domain_php, domain_cgi, allowbackup, domain_dns, domain_software_allowed, phpini_perm_system, phpini_perm_allow_url_fopen, phpini_perm_display_errors, phpini_perm_disable_functions, domain_external_mail, web_folder_protection, mail_quota ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

    [/feedquote]