upgrading error

[al-anwar]

Hello,
I am facing the following errors in my forum, after upgrading it from 3.0.7, please assist me.
the error i get is as follows:
========================================
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT announcementid, startdate, enddate, announcement.title, pagetext, allowhtml, allowbbcode, allowsmilies, views,
user.*, userfield.*, usertextfield.*,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline
, level
FROM announcement AS announcement
LEFT JOIN user AS user ON(user.userid=announcement.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=announcement.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid=user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid=announcement.userid)
LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid)

WHERE startdate <= 1131393866
AND enddate >= 1131393866
AND announcement.forumid IN (76,74,-1)
ORDER BY startdate DESC

mysql error: Unknown column 'customavatar.avatardata' in 'field list'
mysql error number: 1054
============================================
I appreciate your help in advance

[Marco van Herwaarden]

avatardata is not a column used in default vBulletin 3.5.

This column was used in vB3.0.x but now got replaced by filedata. Are you trying to use a vB 3.0 hack on vB3.5?

[al-anwar]

No, I get this error when i try to view threads. I tried to upgrade vBindex but I am not sure if this is related to this error.

[Steve Machol]

This means that you either did not upgrade problerly, or the error is caused by hacked files. To troubleshoot this, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.