Running 3.8.3 but getting a 3.7.2 error message
 

Hi,
I had vBulletin 3.7.2 running on a test site and impexed a forum from DC Scripts. Everything worked out great.

I then impexed in a forum from PhBB3.

I associated the users and ran most of the counters. All the forums, posts, and users are showing in the forum itself but the clicking on memberlist gives the following error:

Can anyone please shed some light on what I did wrong or how to repair this? Also, why am I getting a 3.7.2 error if I'm running 3.8.3?

Thanks in advance

Quote:


On edit: I just looked at the database table user and all my old users are gone. Only the new ones are showing.
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
,IF((NOT(options & 1024) AND (user.usergroupid IN (-1,14,6) OR FIND_IN_SET('14', membergroupids) OR FIND_IN_SET('6', membergroupids))), 0, reputation) AS reputationscore
,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
, pp_profilepic.requirement AS profilepicrequirement, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
, lastactivity AS lastvisittime



FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputati onlevelid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
LEFT JOIN profileblockprivacy AS pp_profilepic ON
(pp_profilepic.userid = user.userid AND pp_profilepic.blockid = 'profile_picture')


WHERE 1=1 AND posts >= 1
AND (user.usergroupid IN (-1,14,6,12,7,9,2,5))

ORDER BY user.username asc
LIMIT 0, 100;
MySQL Error : Table 'vbulletin_forum.profileblockprivacy' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 29th 2009 @ 10:43:15 AM
Error Date : Wednesday, July 29th 2009 @ 10:43:15 AM
Script : http://www.xxxx.virtual.vps-host.net...memberlist.php
Referrer : http://www.xxxx.virtual.vps-host.net/forums/
IP Address : (edited out/that's me)
Username : (edited out/that's me)
Classname : vB_Database_MySQLi
MySQL Version : 5.0.27-standard-log