• 23-10-2009, 19:02:37
    #1
    Kimlik doğrulama veya yönetimden onay bekliyor.
    Usercp ye girince bu hatayı alıyorum

    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
  • 23-10-2009, 23:26:49
    #2
    ş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;