-
-
Notifications
You must be signed in to change notification settings - Fork 2.7k
Closed
Labels
BugFor errors / faults / flaws / inconsistencies etc.For errors / faults / flaws / inconsistencies etc.
Milestone
Description
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (u.login LIKE '%user%' OR u.email LIKE '%user%') GROUP BY u.lo' at line 4
Can't filter for username and role at the same time if role Write
is selected.
Steps to reproduce:
- matomo version 3.6.0
- php version 7.0.7
- open "Manage Users"
- type
user
in the "User search" field - select
Write
in the Filter by access field
Expected:
- no error is displayed and the all users with name containing
user
and roleWrite
are displayed
Actual:
- Error
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (u.login LIKE '%user%' OR u.email LIKE '%user%') GROUP BY u.lo' at line 4
is displayed.
Metadata
Metadata
Assignees
Labels
BugFor errors / faults / flaws / inconsistencies etc.For errors / faults / flaws / inconsistencies etc.