Bug Compromised Log Viewer

[Nirjonadda]

Compromised Log Viewer are Database error.


Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT COUNT(*) AS total
FROM vbdbtech_vbsecurity_compromisedlog AS compromisedlog
LEFT JOIN vbuser AS user USING(userid)


LIMIT 1;

MySQL Error : Table 'user_fdate.vbdbtech_vbsecurity_compromisedlog' doesn't exist
Error Number : 1146
Request Date : Tuesday, November 17th 2015 @ 01:26:20 PM
Error Date : Tuesday, November 17th 2015 @ 01:26:21 PM
Script :/vbsecurity.php?do=compromisedlog
Referrer :/vbsecurity.php?do=compromisedlog
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.5.46-cll

 

[Fillip H.]

I can't replicate this. Please try resetting your version to 1.9.9 in the Product Manager, then re-import the XML file.

 

[Nirjonadda]

Now getting this when try to re-import the XML file

Database error in vBulletin 4.2.3:

Invalid SQL:
ALTER TABLE `vbdbtech_vbsecurity_loginstrikes` ADD `validuser` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1';

MySQL Error : Duplicate column name 'validuser'
Error Number : 1060
Request Date : Tuesday, November 17th 2015 @ 01:32:12 PM
Error Date : Tuesday, November 17th 2015 @ 01:32:15 PM
Script : /plugin.php?do=productimport
Referrer : /plugin.php?do=productadd

 

[Fillip H.]

That's fine to ignore, change the version back, the table should have been created now.

 

[Fillip H.]

Hello Nirjonadda,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!