Bug Admin Strikes and Login Strikes Viewer

[Nirjonadda]

What Do You Mean by Admin Strikes and Login Strikes Viewer ? Please give me some more info about that, Also I have some bug on the logger , please check the ScreenShot.

Unknown language or User name:



User name not found:



User ID : 0 , Does vB have user id 0 ?

 

[Fillip H.]

It will revert to displaying "user id: x" if the user has been deleted. If the record can't be looked up, it'll display 0 as a last resort.

What collation is the username column on the dbtech_vbsecurity_loginstrikes table set to? Is it the same as the rest of your database?

 

[Nirjonadda]

What Do You Mean by Admin Strikes and Login Strikes Viewer ?

I'm sorry, I didn't understand what are you asking ?

 

[Fillip H.]

Can you click "Structure" on that list and show me a screenshot of the resulting page?

 

[Nirjonadda]

Server: localhost »Database: user_data »Table: vbdbtech_vbsecurity_loginstrikes

 

[Fillip H.]

Is that username column the same collation as your username column in the user table?

 

[Nirjonadda]

Please can you take some time and check on this issue on my site, You have now cPanel details.

 

[Fillip H.]

This should now be resolved on your site; all users are selectable

 

[Nirjonadda]

I have get datebase error via email.

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT username
FROM vbdbtech_vbsecurity_loginstrikes AS loginstrikes
FROM vbdbtech_vbsecurity_loginstrikes AS loginstrikes
ORDER BY username;

MySQL Error : 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 'FROM vbdbtech_vbsecurity_loginstrikes AS loginstrikes
ORDER BY username' at line 3
Error Number : 1064
Request Date : Sunday, February 9th 2014 @ 07:52:57 PM
Error Date : Sunday, February 9th 2014 @ 07:52:58 PM
Script : /admincp/vbsecurity.php?do=loginstrikes
Referrer : /admincp/index.php?do=nav
IP Address : 90.221.161.xx
Username : Nirjon
Classname : vB_Database_MySQLi
MySQL Version : 5.5.35-cll

 

[Fillip H.]

That was while I was editing the code on your site.