[Geisthund99]

Originally Posted by Krusty1231

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT U.username as username,
U.userid as userid,
MM.lat as lat,
MM.lon as lon,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,
U.avatarrevision,
AV.avatarpath,
NOT ISNULL(CAV.userid) AS hascustomavatar,
CAV.dateline AS avatardateline,
CAV.width AS avwidth,
CAV.height AS avheight,
U.lastactivity

FROM _vbdc_membermap AS MM
LEFT JOIN _vbuser AS U ON U.userid = MM.userid
LEFT JOIN _vbavatar AS AV ON (AV.avatarid = U.avatarid)
LEFT JOIN _vbcustomavatar AS CAV ON (CAV.userid = U.userid);

MySQL Error : Table 'jerry_forum._vbdc_membermap' doesn't exist
Error Number : 1146
Request Date : Thursday, July 12th 2012 @ 05:59:39 PM
Error Date : Thursday, July 12th 2012 @ 05:59:40 PM
Script : http://www.XXXXXX/forum/dcMembermap.php
Referrer : http://www.XXXXXX/forum/forum.php
IP Address : XX.XX.XX.XXX
Username : Jerry
Classname : vB_Database
MySQL Version : 5.5.23-55

I just downloaded zip file and got the same error.
Also same error when I downloaded updated file!!
No vbulletin.vb_dc_membermap created.
Cheers
Gareth