New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Manage Users: SQL Error for role write #13384

Closed
Legion2 opened this Issue Sep 4, 2018 · 1 comment

Comments

Projects
None yet
5 participants
@Legion2

Legion2 commented Sep 4, 2018

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 role Write 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.
@fdellwing

This comment has been minimized.

Contributor

fdellwing commented Sep 4, 2018

Can confirm this error.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment