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 @ 0543 PM Error Date : Thursday, October 4th 2012 @ 0544 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.