مشكله في قاعده البيانات Database error in vBulletin 3.7.3
السلام عليكم هذه المشكله موجوده بعد التحديث
لا يوجد اي هاك متركب
لا يوجد استايلات غير متوافقه
عملت اصلاح للجداول
والمشكله كما هيا
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passwordda te) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.useri d) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thu mb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermiss ions AS cssbuildpermissions, IF(userlist1.friend = 'yes', 1, 0) AS isfriend, IF (userlist1.friend = 'pending' OR userlist1.friend = 'denied', 1, 0) AS ispendingfriend, IF(userlist1.userid IS NOT NULL, 1, 0) AS u_iscontact_of_bbuser, IF (userlist2.friend = 'pending', 1, 0) AS requestedfriend, IF(userlist2.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)LEFT JOIN userlist AS userlist1 ON (userlist1.relationid = user.userid AND userlist1.type = 'buddy' AND userlist1.userid = 41)LEFT JOIN userlist AS userlist2 ON (userlist2.userid = user.userid AND userlist2.type = 'buddy' AND userlist2.relationid = 41)
WHERE user.userid = 763;
MySQL Error : Table 'xxxxx_vb3.userlist' doesn't exist
Error Number : 1146
Request Date : Monday, October 6th 2008 @ 08:40:19 PM
Error Date : Monday, October 6th 2008 @ 08:40:19 PM
Script : http://xxxxxx.com/vb/member.php?u=763
Referrer : http://xxxxxxxxcom/vb/index.php?styleid=1
IP Address : xx.xx.xx.xx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.51a-community
وايضا عند الدخول لاي موضوع
Database error in vBulletin 3.7.3:
Invalid SQL:
(SELECT permissions, permissions2, FIND_IN_SET(forumid, '4,94,-1') AS pos, forumid
FROM moderator
WHERE userid = 41 AND forumid IN (4,94,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 41 AND forumid = -1
);
MySQL Error : Unknown column 'permissions2' in 'field list'
Error Number : 1054
Request Date : Monday, October 6th 2008 @ 09:19:29 PM
Error Date : Monday, October 6th 2008 @ 09:19:29 PM
Script : http://xxxxxxx.com/vb/showthread.php?t=7209
Referrer : http://xxxxcom/vb/forumdisplay.php?f=4
IP Address : xx.xxx.xxx.xx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.51a-community
رد مع اقتباس
مواقع النشر (المفضلة)