Comment 15 for bug 150649

Revision history for this message
Daevid Vincent (dae51d) wrote :

SOLVED:

THIS IS STUPID!! The Where clause requires that YOU put an additional "AND" in there.

 Auth_MySQL_Where " AND type = 'Admin' AND enabled = 1 "

So the auth_mysql code must be making a "SELECT * FROM user WHERE username = 'foo' AND password = 'bar' WHERE 1" or some other completely retarded logic, when it should simply be putting a "WHERE " (with the intentional trailing space) and the string you gave it in the directive. UGH!