search

nextcloud / user_sql

🔒 App for authenticating Nextcloud users using SQL
GNU Affero General Public License v3.0
66 stars 33 forks source link

Error in your SQL syntax when logging in after enabling User and Groups SQL Backend #154

Open rbeason opened 3 years ago

rbeason commented 3 years ago

Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'SELECT u.user_login AS uid, u.user_login AS username, u.user_login AS name, null AS email, null AS quota, null AS home, true AS active, false AS avatar, null AS salt, u.user_pass AS password FROM wp_users u WHERE u.user_login = :username OR u. = :email ' with params ["myusername", "myusername"]: 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 '= 'myusername'' at line 1

I have connected successfully to the database. I have the following settings set for each column:

Users Table Name: wp_users UID: user_login Username: user_login Password: user_pass

Hash algorithm: Unix (Crypt)

mlojewski-me commented 3 years ago

SELECT u.user_login AS uid, u.user_login AS username, u.user_login AS name, null AS email, null AS quota, null AS home, true AS active, false AS avatar, null AS salt, u.user_pass AS password FROM wp_users u WHERE u.user_login = :username OR u. = :email ' There's something wrong with email column I will check it later