[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:
Code
- 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]