Cannot view user profile

[jadel]

We recently moved our forums to a new server and since then we haven't been able to view the user's profile in the forums or the admincp. The error we receive is

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 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)
WHERE user.userid = 4

mysql error: Table 'hpd.customprofilepic' doesn't exist

mysql error number: 1146

Date: Wednesday 23rd of February 2005 05:49:57 PM
Script: http://www.houstonperformancedriving...astposter&f=57
Referer: http://www.houstonperformancedriving...ums/index.php?
Username: HPDTEAM
IP Address: 216.166.36.170

I ran:

Go into your AdminCP and down to Utilities. Select Run SQL query. then type:

show columns from customprofilepic;

If that works, the issue is that you have a prefix (of "hpd.") on your SQL query that you need to remove. (I believe prefixes are set in CONFIG.PHP, but don't remember for sure.) If it DOESN'T work, try:

show columns from hpd.customprofilepic;

and both returned the following:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'hpd.customprofilepic' doesn't exist

Does anyone know of a fix for this?

Thanks in Advance

Ja