Forum Error when clicking on member name and selecting view profile
 

Can anyone tell me what to do or look at with this error? We get it when you click on a members name and select view profile.



Database error in vBulletin 4.2.0:

Invalid SQL: SELECT entry.*, user.username, user.usergroupid, user.membergroupids, user.infractiongroupid, user.displaygroupid, receiveduser.username AS receivedusername, receiveduser.usergroupid AS receivedusergroupid, receiveduser.membergroupids AS receivedmembergroupids, receiveduser.infractiongroupid AS receivedinfractiongroupid, receiveduser.displaygroupid AS receiveddisplaygroupid FROM ( () ) AS entry

LEFT JOIN user AS user ON(user.userid = entry.userid)
LEFT JOIN user AS receiveduser ON(receiveduser.userid = entry.receiveduserid) ORDER BY entryid DESC LIMIT 20; 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 ') ) AS entry LEFT JOIN user AS user ON(user.userid = entry.userid) LEFT' at line 15 Error Number : 1064 Request Date : Thursday, October 4th 2012 @ 05:45:43 PM Error Date : Thursday, October 4th 2012 @ 05:45:44 PM Script : http://xxxx.xxx/forum/members/5-xxxxx-nurse/ Referrer : http://xxxx.xxx/forum/f17/ IP Address : xxxxxx Username : xxxx Classname : vB_Database MySQL Version : 5.1.65-cll

We just switched hosts for our dedicated server and this is the last error to go.

Thanks!