Table sigpaRsed doesn't exist

محروم.كوم · #1 09-02-2009, 03:20 AM

I recently started to get the above error messages

Quote:
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,

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
, '' AS field6
,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 editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2)
LEFT JOIN sigpaRsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 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,122268,122271,122272,122380,122425,122508,12258 3,122584,122601,122604,122616,122700,122738,122742 ,122756,122762,122782)
ORDER BY post.dateline;
MySQL Error : Table 'sigpaRsed' doesn't exist
Error Number : 1146
Request Date : Tuesday, September 1st 2009 @ 07:23:04 PM

Error Date : Tuesday, September 1st 2009 @ 07:23:04 PM
Script : http://my_site.com/forum/showthread.php?p=122742
Referrer :
Username : unregistered
MySQL Version :

I highlighted by red for some reason capitalized letter R, where I think the problem is, but what happend? Haven't change/upgrade for more then 2 month and just started to get those messages after a crush/full restore about a week ago....
Any ideas? __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Table Datastore Does Not Exist?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	11-01-2009 11:00 PM
Table Datastore Does Not Exist?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	11-01-2009 10:50 PM
Table Datastore Does Not Exist?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	11-01-2009 10:20 PM
Table Datastore Does Not Exist?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	11-01-2009 10:10 PM
Notices Table Doesn't Exist?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-02-2009 11:50 PM