[tareqbd]

Originally Posted by Dave

Yes, I uploaded a new one which should work.

Thanks Dave. But it is taking the cloudflare masks. How do I get the real IP.

[Dave]

Originally Posted by tareqbd

Thanks Dave. But it is taking the cloudflare masks. How do I get the real IP.

In the "Plugin Manager", find the plugin for this product and change $_SERVER['REMOTE_ADDR'] to $_SERVER['HTTP_CF_CONNECTING_IP'] or IPADDRESS.

[tareqbd]

Originally Posted by Dave

In the "Plugin Manager", find the plugin for this product and change $_SERVER['REMOTE_ADDR'] to $_SERVER['HTTP_CF_CONNECTING_IP'] or IPADDRESS.

Thanks. While checking the functions, I have faced some problems as below.

Warning: Missing argument 2 for vB_Database::execute_query(), called in ..../admincp/loginlog.php on line 41 and defined in ..../includes/class_core.php on line 412

Warning: mysql_query() expects parameter 2 to be resource, null given in ..../includes/class_core.php on line 417

And sql error:

Database error in vBulletin 4.2.2:

Invalid SQL:
;

MySQL Error :
Error Number : 0
Request Date : Sunday, January 17th 2016 @ 02:20:47 PM
Error Date : Sunday, January 17th 2016 @ 02:20:47 PM
Script : http://www.domain.com/admincp/loginlog.php?do=purgenow
Referrer : http://www.domain.com/admincp/loginlog.php?do=purge
IP Address : xxx.xxx.xx.xx
Username : pps
Classname : vB_Database
MySQL Version :

[Dave]

Did you change anything in the code? That error is never supposed to happen.

[tareqbd]

Originally Posted by Dave

Did you change anything in the code? That error is never supposed to happen.

Not really. I just changed the plugin code as you mentioned for bypassing the cloudflare.

[Dave]

Could you paste the whole code? You probably made a typo somewhere.

[tareqbd]

Originally Posted by Dave

Could you paste the whole code? You probably made a typo somewhere.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[Dave]

That looks fine and works on my local test forum.
The error happens because the MySQL connection resource isn't set, which is really odd.

[tareqbd]

So, what to do now. I actually wanted to remove the logs taken with cf ips.

[Iari]

Perfect! Exactly what I needed.
Thank you so much.

[Coder2016]

I have the same error. Fix ?

Database error in vBulletin 4.2.2:

Invalid SQL:
;

MySQL Error :
Error Number : 0
Request Date : Sunday, January 14th 2017 @ 02:20:47 PM
Error Date : Sunday, January 14th 2017 @ 02:20:47 PM
Script : http://www.domain.com/admincp/loginlog.php?do=purgenow
Referrer : http://www.domain.com/admincp/loginlog.php?do=purge
IP Address : xxx.xxx.xx.xx
Username : pps
Classname : vB_Database
MySQL Version :

[Alice]

I'm having the same issue, anyone with a fix?

[edgeless]

Same error for me (upon purge attempts):

Database error in vBulletin 4.2.2:

Invalid SQL:
;

MySQL Error :
Error Number : 0
Request Date : Sunday, December 15th 2019 @ 03:28:12 PM
Error Date : Sunday, December 15th 2019 @ 03:28:12 PM
Script : http://www.domain.com/dirname/adminc...hp?do=purgenow
Referrer : https://www.domain.com/dirname/admin...g.php?do=purge
IP Address : xxx.xxx.xxx.xxx
Username : username
Classname : vB_Database_MySQLi
MySQL Version :

Has anyone discovered a solution yet?

[edgeless]

OK, I believe I've fixed this. Here is what I did...

I changed (line 41) of the purgenow script:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

to this:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Basically all you should need to do is change execute_query to query and add a space before and after TRUNCATE TABLE, after which the purges should start working correctly. In any case, this fix seems to work perfectly here. Now every time I execute a purge, the message "The login log has been purged" is properly displayed and all login entries are gone.