Error after server move

[peterpigman]

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/admi...s.php?do=doips
Referrer : http://forum.uncoverreality.com/admi...s.php?do=doips
IP Address : XXX.XXX.XXX.XXX
Username : Peterpigman
Classname : vb_database

[Dismounted]

This is an issue with your MySQL setup, so contact your host.

[peterpigman]

Originally Posted by Dismounted

This is an issue with your MySQL setup, so contact your host.

ok thanks.