Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
d.*, gm.*, user.*,
gm.ipaddress AS itemipaddress, d.lastpost AS lastpost, d.lastpostid AS lastpostid ,deletionlog.userid AS del_userid, deletionlog.username AS del_username,
deletionlog.reason AS del_reason ,IF(d.lastpost <= discussionread.readtime,1,0) AS is_read, discussionread.readtime AS readtime ,subscribediscussion.emailupdate
FROM discussion AS d
INNER JOIN groupmessage AS gm
ON (gm.gmid = d.firstpostid)
LEFT JOIN user AS user ON (gm.postuserid = user.userid) LEFT JOIN discussionread AS discussionread
ON (discussionread.discussionid = d.discussionid
AND discussionread.userid = 1) INNER JOIN subscribediscussion AS subscribediscussion
ON (subscribediscussion.discussionid = d.discussionid
AND subscribediscussion.userid = 1) LEFT JOIN deletionlog AS deletionlog
ON (gm.gmid = deletionlog.primaryid AND deletionlog.type = 'groupmessage')
WHERE 1=1 AND ((gm.postuserid = 1 AND state = 'moderation') OR gm.state IN ('visible','deleted'))
ORDER BY d.lastpost ASC;
MySQL Error : Table 'xxx_site.discussionread' doesn't exist
Error Number : 1146
Request Date : Friday, October 23rd 2009 @ 06:53:06 PM
Error Date : Friday, October 23rd 2009 @ 06:53:06 PM
Script : http://www.gladyo.info/usercp.php
Referrer : http://www.gladyo.info/index.php
IP Address : 85.110.199.146
Username : MuTLaK
Classname : vB_Database
MySQL Version : 5.0.81-community vB yardım DB hatası
1
●263
- 23-10-2009, 19:02:37Kimlik doğrulama veya yönetimden onay bekliyor.Usercp ye girince bu hatayı alıyorum
- 23-10-2009, 23:26:49şu sorguyu çalıştırırmısın
CREATE TABLE IF NOT EXISTS `discussionread` ( `userid` int(10) unsigned NOT NULL, `discussionid` int(10) unsigned NOT NULL, `readtime` int(10) unsigned NOT NULL, PRIMARY KEY (`userid`,`discussionid`), KEY `readtime` (`readtime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;