Topic: Admin login shows SQL error
I get a nasty error on my screen including the password hash:
Databasefout : could not get validate user login for admin
error code : 1146
error message : Table 'db1.1_users' doesn't exist
sql that failed was : SELECT * FROM 1_users WHERE user_id = 'admin' AND password='rf8b354e1fb8cc2fb87c9cf6b27f6b14'
I also managed to correct, but still not sure about the root cause.
I have two companies setup. One on db1 with prefix 0_ and one on db2 with prefix 1_. Now I have the root admin account durint setup and I made an admin account for the new company. I also changed the default login to be the new company. And I also changed the passwords for both admin accounts.
When I login with admin for the first company THEN I get the error. While the error tries to open db1.1_user it should have opened db1.0_user.
Now when I open the table db2.1_user and rename the admin account into admin2 then I don't get this nasty error anymore when trying to login. So if I don't see other side effects then I will leave it like this. Only 1 admin for the whole application.