السلام عليكم
كلما اريد اضافة اعلان في المنتديات ، تظهر الرسالة التالية والتي تفيد وجود خطأ في الداتا بيس ، ارجو المساعدة في ايجاد حل لها
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT announcement.announcement id, announcement.announcement id AS
postid, startdate, enddate, announcement.title, pagetext,
announcementoptions, views,
user.*, userfield.*, usertextfield.*,
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
,avatar.avatarpath, NOT ISNULL(customavatar.useri d) AS
hascustomavatar, customavatar.dateline AS avatardateline,customavat ar.width AS
avwidth,customavatar.heig ht AS avheight
FROM announcement AS announcement
LEFT JOIN user AS user ON(user.userid=announceme nt.userid)
LEFT JOIN userfield AS userfield
ON(userfield.userid=annou ncement.userid)
LEFT JOIN usertextfield AS usertextfield
ON(usertextfield.userid=a nnouncement.userid)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = announcement.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid=user.a vatarid)
LEFT JOIN customavatar AS customavatar
ON(customavatar.userid=an nouncement.userid)
WHERE startdate <= 1175079193
AND enddate >= 1175079193
AND announcement.forumid IN (1,-1)
ORDER BY startdate DESC, announcementid DESC;
MySQL Error : Unknown column 'announcementoptions' in 'field list'
Error Number : 1054
Date : Wednesday, March 28th 2007 @ 05:53:13 AM
Script : http://www.alaws2006.com/vb/announcement.php?f=1
Referrer :
IP Address : 213.6.197.10
Username : غير مسجل
Classname : vb_database
مواقع النشر (المفضلة)