jadel
02-23-2005, 10:06 PM
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.com/forums/member.php?find=lastposter&f=57
Referer: http://www.houstonperformancedriving.com/forums/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
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.com/forums/member.php?find=lastposter&f=57
Referer: http://www.houstonperformancedriving.com/forums/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