Help me please with fixing this mod

[Chris8]

I need some help fixing this small problem.

Here is the mod I'm testing -> https://vborg.vbsupport.ru/showthread.php?t=124907

Here is an additional modification of the mod -> https://vborg.vbsupport.ru/showpost.php?p=1283430&postcount=87 and here is the problem. It works well when typing existing username and wrong password but there is an issue when typing non-existing username.



Database error in vBulletin 3.8.111:

Invalid SQL:
INSERT INTO vb_logins (userid, username, ipaddress, phpdate, logintype) VALUES (, '', '11.111.11.1', 1355514465, 'FAILED ATTEMPT');

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 ' '', '11.111.11.1', 1355514465, 'FAILED ATTEMPT')' at line 1
Error Number : 1064
Request Date : Friday, December 14th 2012 @ 02:47:45 PM
Error Date : Friday, December 14th 2012 @ 02:47:45 PM
Script : http://www.xxx.xxx/forums/login.php?do=login
Referrer : http://www.xxx.xxx/forums/index.php
IP Address : 11.111.11.1
Username :
Classname : vB_Database
MySQL Version :
-->


Is it because of the lack userid or username? What is the best way to fix it? I was thinking about some user related conditionals, I'm not sure though which one would work here and if it's best way to do it anyway. Any help will be greatly appreciated.

[ForceHSS]

For a start you need to post this in the mod for support 2nd a link to your forums will help 3rd the problem could be the version you are using is not the same version as your forums and could be causing some of the problems

[kh99]

As mentioned above, questions/problem with mods must be addressed in the mod thread and not in the general discussion forums.

I've responded to your question here: https://vborg.vbsupport.ru/showpost.php?p=2390867&postcount=125

[Chris8]

For a start you need to post this in the mod for support 2nd a link to your forums will help 3rd the problem could be the version you are using is not the same version as your forums and could be causing some of the problems

Thank you for your suggestions. ;)


As mentioned above, questions/problem with mods must be addressed in the mod thread and not in the general discussion forums.

I've responded to your question here: https://vborg.vbsupport.ru/showpost.php?p=2390867&postcount=125

Thank you. Your solution works like a charm! :)

I'm sorry I have not posted it in the original thread. I've just though it would be quicker to get some help this way as some mod developers do not show here very often anymore. Nonetheless next time I will try post in a mod thread first.