مشكلة في قاعدة البيانات
السلام عليكم ورحمه الله وبركاته
لقد قمت بترقية الموقع بس بنجاح لما ادش الى اقسام المنتديات تظهر عندي هالمشكلة ارجو منكم حلها بأسرع وقت
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT
announcement.announcement id, startdate, title, announcement.views,
user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, NOT ISNULL(announcementread.a nnouncementid) AS readannounce
FROM announcement AS announcement
LEFT JOIN announcementread AS announcementread ON (announcementread.announc ementid = announcement.announcement id AND announcementread.userid = 7)
LEFT JOIN user AS user ON(user.userid = announcement.userid)
WHERE startdate <= 1248338238
AND enddate >= 1248338238
AND forumid IN (28,27,-1)
ORDER BY startdate DESC, announcement.announcement id DESC;
MySQL Error : Column 'title' in field list is ambiguous
Error Number : 1052
Request Date : Thursday, July 23rd 2009 @ 03:37:18 AM
Error Date : Thursday, July 23rd 2009 @ 03:37:18 AM
Script : http://www.noorleema.com/vb/forumdisplay.php?f=28
Referrer : http://www.noorleema.com/vb/index.php
IP Address : 62.61.164.176
Username : القيصر
Classname : vB_Database
MySQL Version : 5.0.81-community
رد مع اقتباس
مواقع النشر (المفضلة)