Ticket #1056 (Incorrect value '_no_' in SQL query on create default email-accounts.) created

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

    reseller-functions.php in strings: 793, 803, 812 try to insetring value '_no_' into tinyint(1) field mail_users.mail_auto_respond

    How to repeat:

    1. Enable option "Create default email addresses" in "Email settings"
    2. Create new customer.

    Bug report summary:

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

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

    SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '_no_'
    for column 'mail_auto_respond' at row 1

    Query was:

    INSERT INTO mail_users ( mail_acc, mail_pass,

    mail_forward,domain_id, mail_type, sub_id, status,
    mail_auto_respond,quota, mail_addr ) VALUES ( ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ? )
    =================================================================

    Debug backtrace:


    File: /var/www/imscp/gui/library/reseller-functions.php (Line: 796)
    Function: exec_query()
    File: /var/www/imscp/gui/public/reseller/user_add3.php (Line: 296)
    Function: client_mail_add_default_accounts()
    File: /var/www/imscp/gui/public/reseller/user_add3.php (Line: 351)
    Function: reseller_addCustomer()
    [/feedquote]