tjpeople
01-02-2007, 09:58 PM
Right hope somebody can help.
Also note i have little experance with vb. The forum in question was hosted on somebody elses server, then it was hacked and now im gunna host it and obviously we want all the posts and users back so we used a saved mysql database. (it may be curropted? i wouldnt know if it was or wasnt) so i used the same version of vb as it had previous 3.5.0. And it seemed to work ok, but i cant view threads/posts/user profiles without getting the error below.
**********************************
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,20436,20443,20445,20447)
ORDER BY dateline
mysql error: Unknown column 'customavatar.avatardata' in 'field list'
mysql error number: 1054
Date: Tuesday 02nd of January 2007 11:50:22 PM
Script: http://www.mitmforum.tjpeople.com/showthread.php?p=20447
Referer: http://www.mitmforum.tjpeople.com/index.php?
Username: ****
IP Address: *******
**************************************
Ive googled my problem but the only advice i come across was reupload the vb files which i have done, but it makes no differance.
any ideas would be great.
Regards
Also note i have little experance with vb. The forum in question was hosted on somebody elses server, then it was hacked and now im gunna host it and obviously we want all the posts and users back so we used a saved mysql database. (it may be curropted? i wouldnt know if it was or wasnt) so i used the same version of vb as it had previous 3.5.0. And it seemed to work ok, but i cant view threads/posts/user profiles without getting the error below.
**********************************
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,20436,20443,20445,20447)
ORDER BY dateline
mysql error: Unknown column 'customavatar.avatardata' in 'field list'
mysql error number: 1054
Date: Tuesday 02nd of January 2007 11:50:22 PM
Script: http://www.mitmforum.tjpeople.com/showthread.php?p=20447
Referer: http://www.mitmforum.tjpeople.com/index.php?
Username: ****
IP Address: *******
**************************************
Ive googled my problem but the only advice i come across was reupload the vb files which i have done, but it makes no differance.
any ideas would be great.
Regards
