Hi.
Go to the adminCP, vbSecurity, Login Strikes Viewer and then list all users with login strikes. If you click on any of the users listed, you will get an error such as:
The reason why is that the query should wrap the username with quotes, i.e.:
I'd really appreciate if you guys could fix this, as I couldn't find where to fix.
Thanks,
Gabriel.
Go to the adminCP, vbSecurity, Login Strikes Viewer and then list all users with login strikes. If you click on any of the users listed, you will get an error such as:
Code:
Database error in vBulletin 3.8.7:
Invalid SQL:
SELECT COUNT(*) AS total
FROM dbtech_vbsecurity_loginstrikes
WHERE username = cip
LIMIT 1;
MySQL Error : Unknown column 'cip' in 'where clause'
Error Number : 1054
Request Date : Tuesday, May 7th 2013 @ 05:00:42 PM
Error Date : Tuesday, May 7th 2013 @ 05:00:43 PM
Script : *********************
Referrer : *********************
IP Address : *********************
Username : Gabriel Torres
Classname : vB_Database
MySQL Version : 5.6.11
The reason why is that the query should wrap the username with quotes, i.e.:
Code:
SELECT COUNT(*) AS total
FROM dbtech_vbsecurity_loginstrikes
WHERE username = 'cip'
LIMIT 1;
I'd really appreciate if you guys could fix this, as I couldn't find where to fix.
Thanks,
Gabriel.