Ticket #1020 (SQL Error /S earch Domain) created

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

    I want to search for a domain like "cläffer" but it ends in an SQL error:

    Dear admin,

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

    SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
    error in your SQL syntax; check the manual that corresponds to your
    MySQL server version for the right syntax to use near '--'%cl%'-eua
    ESCAPE ''' at line 7

    Query was:

    SELECT COUNT(*) AS cnt FROM domain AS t1 INNER JOIN

    admin AS t2 ON(t2.admin_id = t1.domain_admin_id) WHERE
    t1.domain_name LIKE xn--'%cl%'-eua ESCAPE '!'

    Debug backtrace:


    File:
    /var/www/imscp/gui/library/iMSCP/View/Helpers/Functions/Admin.php
    (Line: 304)
    Function: exec_query()
    File:
    /var/www/imscp/gui/library/iMSCP/View/Helpers/Functions/Admin.php
    (Line: 544)
    Function: gen_user_list()
    File: /var/www/imscp/gui/public/admin/manage_users.php (Line: 123)
    Function: get_admin_manage_users()
    [/feedquote]