The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Cannot view user profile
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 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|