Status
Not open for further replies.

gabrielt

Customer
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:

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.
 
I'm unable to replicate this issue. Can you please try re-downloading the modification from DBTech here: vBSecurity and see if that works for you?
 
Hi. Thanks for the prompt reply. I've re-installed the mod and the problem is now solved. Go figure. Maybe I forgot to overwrite the old product XML when I upgrade last? Anyway, it was a problem with my installation that is now fixed. Thank you once again for the prompt reply and terrific work.
 
It's possible that I fixed this in a hotfix at some point as well - I don't recall. Glad it's working for you now :)
 
Status
Not open for further replies.

Legacy vBSecurity

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
810
Customer rating
0.00 star(s) 0 ratings
Back
Top