database error when entering into a post

محروم.كوم · #1 11-18-2009, 08:40 PM

this is the error

Database error in vBulletin 4.0.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

FROM vBpost AS post

LEFT JOIN vBuser AS user ON(user.userid = post.userid)
LEFT JOIN vBuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vBusertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vBicon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vBavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vBcustomavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vBspamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN vBdeletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN vBeditlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vBpostparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 11 AND postparsed.languageid = 1)
LEFT JOIN vBsigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 11 AND sigparsed.languageid = 1)
LEFT JOIN vBsigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN ()
ORDER BY post.dateline;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY post.dateline' at line 29
Error Number : 1064
Request Date : Wednesday* November 18th 2009 @ 09:05:04 AM
Error Date : Wednesday* November 18th 2009 @ 09:05:06 AM
Script : http://www.gsmteam.net/ForoV4/showth...os-de-usuarios
Referrer : http://www.gsmteam.net/ForoV4/forumd...cion-del-STAFF
IP Address : 187.90.118.114
Username : gerlandog
Classname : vB_Database
MySQL Version : 5.0.81-community-log

can anyone tell me what did i wrong?

thanks
GG __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
CMS Tried to promote post to article and recieved database error	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-12-2010 02:00 PM
Forum Database error when editing existing post	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	02-21-2010 03:31 PM
Forum New Installation: Error after entering customer number on install	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	02-03-2010 11:40 PM
Forum Post icons not showing up in editor/before entering thread (but works when in thread)	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	12-25-2009 05:48 AM
Database Error when Creating Thread / Reply Post	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-25-2009 03:40 AM