Forum Recreating the vb_customprofilepic table for vb4?

محروم.كوم · #1 07-08-2010, 04:10 AM

Due to a small server glitch, i was forced to exclude the table - vb_customprofilepic during the server transfer. The table was forcing a "maximum packets" error that wouldnt let the forum restore take place.

So i dropped the table, the forum backup restored successfully.

I am now presented with the following error when attempting to either edit a user with the AdminCP, or access any user profiles.

Quote:
Database error in vBulletin 4.0.4:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions, IF(userlist1.friend = 'yes', 1, 0) AS isfriend, IF (userlist1.friend = 'pending' OR userlist1.friend = 'denied', 1, 0) AS ispendingfriend, IF(userlist1.userid IS NOT NULL, 1, 0) AS u_iscontact_of_bbuser, IF (userlist2.friend = 'pending', 1, 0) AS requestedfriend, IF(userlist2.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user

FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb_sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN vb_usercsscache AS usercsscache ON (user.userid = usercsscache.userid)LEFT JOIN vb_userlist AS userlist1 ON (userlist1.relationid = user.userid AND userlist1.type = 'buddy' AND userlist1.userid = 2)LEFT JOIN vb_userlist AS userlist2 ON (userlist2.userid = user.userid AND userlist2.type = 'buddy' AND userlist2.relationid = 2)

WHERE user.userid = 9;
MySQL Error : Table 'thestar_latest.vb_customprofilepic' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 7th 2010 @ 0616 PM
Error Date : Wednesday, July 7th 2010 @ 0616 PM
Script : forum/member.php?9-Brandon-Rhea
Referrer : forum/forum.php
IP Address :
Username : Lucien
Classname : vB_Database
MySQL Version : 5.0.91-community

If it helps i pulled the following from the mysql-schema file

Quote:
CREATE TABLE vb_customprofilepic

userid INT UNSIGNED NOT NULL DEFAULT '0',
filedata MEDIUMBLOB,
dateline INT UNSIGNED NOT NULL DEFAULT '0',
filename VARCHAR(100) NOT NULL DEFAULT '',
visible SMALLINT NOT NULL DEFAULT '1',
filesize INT UNSIGNED NOT NULL DEFAULT '0',
width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (userid) __DEFINE_LIKE_SHARE__