[Dave]

Originally Posted by Bluemax712

When purging the log it doesn't show much even with debugging enabled
=========================================

Database error in vBulletin 4.2.0:

Invalid SQL:
;

MySQL Error :
Error Number : 0
Script : http://.../admincp/loginlog.php?do=purgenow
Referrer : http://.../admincp/loginlog.php?do=purge

Classname : vB_Database
MySQL Version :

Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/admincp/loginlog.php on line 41

=========================================
=========================================

Though when filtering on the blank userid it does give this for an error:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user b ON a.userid = b.userid WHERE a.userid = ORDER BY a.id DESC LIMIT 0,25;

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 'ORDER BY a.id DESC LIMIT 0,25' at line 1
Error Number : 1064

Script : http://.../admincp/loginlog.php?do=&value=&type=1
Referrer : http://.../admincp/loginlog.php?do=&value=192&type=1

Classname : vB_Database
MySQL Version : 5.0.95-log

Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 459
#2 vB_Database->query_read() called in [path]/admincp/loginlog.php on line 83

============================================

EDIT:
noticed all the other blank queries work but they use "LIKE" instead of "=":

SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user b ON a.userid = b.userid WHERE b.username LIKE '%%' ORDER BY a.id DESC LIMIT 0,25

SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user b ON a.userid = b.userid WHERE a.ip LIKE '%%' ORDER BY a.id DESC LIMIT 0,25

SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user
b ON a.userid = b.userid WHERE a.loginstamp LIKE '%%' ORDER BY a.id DESC LIMIT 0,25

SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user
b ON a.userid = b.userid WHERE a.isp LIKE '%%' ORDER BY a.id DESC LIMIT 0,25

SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user
b ON a.userid = b.userid WHERE a.country LIKE '%%' ORDER BY a.id DESC LIMIT 0,25

SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user
b ON a.userid = b.userid WHERE a.browser LIKE '%%' ORDER BY a.id DESC LIMIT 0,25

=====================
EDIT2:
When filling in the userid filter with a number it does work though :
SELECT a.userid, b.username, a.loginstamp, a.ip, a.isp, a.country, a.browser FROM vb_loginlog a INNER JOIN vb_user
b ON a.userid = b.userid WHERE a.userid = 1 ORDER BY a.id DESC LIMIT 0,25

Does your MySQL user have access to the TRUNCATE function?
The query itself is correct to truncate the table.

I will fix the other error if you search for nothing, although it doesn't have any priority.

Originally Posted by EvoDarrenshan

Hello, Cloudflare... Is a problem. If i use cloudflare it will display cloudflare IP's. Can you fix this?

Please refer to https://support.cloudflare.com/hc/en...ith-vBulletin-