a dat base error!

[fariborz khan]

hi:
any idea for this data base error,

if i must create Table 'myforum_f.sigpic' please say me step by step(how & where create this table )

Database error in vBulletin 3.7.0 Beta 3:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
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, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,blog_user.entries
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 spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 8 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 8 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = post.userid)
WHERE post.postid IN (0,735)
ORDER BY post.dateline;
MySQL Error : Table 'myforum_f.sigpic' doesn't exist
Error Number : 1146
Date : Monday, January 14th 2008 @ 07:18:32 PM
Script : http://xxxxxxxxxxx/forum/showthread.php?t=580
Referrer :
IP Address : my ip
Username : fa
Classname : vB_Database
MySQL Version : 5.0.45-community

[Steve Machol]

MySQL Error : Table 'myforum_f.sigpic' doesn't exist

It looks like you missed a step in the upgrade process. Run this query to add that table:

CREATE TABLE sigpic (
userid int(10) unsigned NOT NULL default '0',
filedata mediumblob,
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
visible smallint(6) NOT NULL default '1',
filesize int(10) unsigned NOT NULL default '0',
width smallint(5) unsigned NOT NULL default '0',
height smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid)
);