An unexpected error occurred (adding new user)

  • I have installed imscp 1.2.14 in a new clean and updated Debian jessie 8.3 64bits.
    After adding a reseller account, I tried to add a new user, but in last step I got this message:


    An unexpected error occurred. Please contact your administrator.



    After pressing "back" an alert show me this:
    "Data were altered. Please try again."


    Also, I have received an email with this message:


    An exception has been thrown in file
    /var/www/imscp/gui/library/Functions/Shared.php at line 2719:

    =================================================================

    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,
    phpini_perm_mail_function, domain_external_mail,
    web_folder_protection, mail_quota ) VALUES (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ? )

    =================================================================

    Debug backtrace:
    ---------------

    File: /var/www/imscp/gui/public/reseller/user_add3.php at line 206
    Function: exec_query()
    File: /var/www/imscp/gui/public/reseller/user_add3.php at line 284
    Function: addCustomer()



    When I installed imscp I got an error importing 5072E1F5 key from pgp.mit.edu (to install mysql 5.6), so I have added it using this command:
    gpg --keyserver pgp.mit.edu --recv-keys 5072E1F5


    I don't know if there is any problen using MySQL 5.6, but now, I don't know how to reinstall imscp using version 5.5 to test if this error is related to mysql version.


    Any clue?

  • @skeptic


    I'll do a fresh install with mysql 5.6 on jessie to see the behavior.


    EDIT


    @skeptic


    Bug about external_mail_dns_ids confirmed. I think that mysql 5.6 is more strict than mysql 5.5, explaining the exeception.
    I'll fix it and after, investigate about GPG key problem.


    EDIT


    @skeptic


    Bug about external_mail_dns_ids should be fixed. See https://github.com/i-MSCP/imsc…45758f0229...cfe28dd1d0c1


    EDIT


    I cannot confirm the problem about GPG key. This was surely a temporarly failure due to a network congestion.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @skeptic


    Please try to upgrade using this archive: https://github.com/i-MSCP/imsc…0652604752ed1ef6c90f6.zip

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206