peterpigman
09-02-2007, 11:13 AM
When I try to check an IP through the admin panel users/ search ip addresses I keep getting this error. Any Ideas what is wrong?
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT DISTINCT user.userid, user.username, post.ipaddress
FROM post AS post,
user AS user
WHERE user.userid = post.userid AND
post.ipaddress = 'xx.xx.xxx.xx' AND
post.ipaddress <> '' AND
user.userid <> 0
ORDER BY user.username;
MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, September 2nd 2007 @ 08:07:10 AM
Script : http://forum.uncoverreality.com/admincp/usertools.php?do=doips
Referrer : http://forum.uncoverreality.com/admincp/usertools.php?do=doips
IP Address : XXX.XXX.XXX.XXX
Username : Peterpigman
Classname : vb_database
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT DISTINCT user.userid, user.username, post.ipaddress
FROM post AS post,
user AS user
WHERE user.userid = post.userid AND
post.ipaddress = 'xx.xx.xxx.xx' AND
post.ipaddress <> '' AND
user.userid <> 0
ORDER BY user.username;
MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, September 2nd 2007 @ 08:07:10 AM
Script : http://forum.uncoverreality.com/admincp/usertools.php?do=doips
Referrer : http://forum.uncoverreality.com/admincp/usertools.php?do=doips
IP Address : XXX.XXX.XXX.XXX
Username : Peterpigman
Classname : vb_database