İpuçu: 1054 - Unknown column 'loginattempts' in 'field list' Hatası Çözümü

MyBB 1054 - Unknown column 'loginattempts' in 'field list' Çözümü

Kod:

MyBB SQL Error MyBB has experienced an internal SQL error and cannot continue. SQL Error: 1054 - Unknown column 'loginattempts' in 'field list' Query: UPDATE mybb_sessions SET `uid`='1', `loginattempts`='1' WHERE sid='' Please contact the MyBB Group for support.

Çözümü :

Phpmyadmine girin "mybb_sessions" tablosunu kaldırın

ardından aşağıdaki sql sorgusunu SQL bölümünden yazıp sorgulatın

Kod:

CREATE TABLE IF NOT EXISTS `mybb_sessions` (   `sid` varchar(32) NOT NULL default '',   `uid` int(10) unsigned NOT NULL default '0',   `ip` varchar(40) NOT NULL default '',   `time` bigint(30) NOT NULL default '0',   `location` varchar(150) NOT NULL default '',   `useragent` varchar(100) NOT NULL default '',   `anonymous` int(1) NOT NULL default '0',   `nopermission` int(1) NOT NULL default '0',   `location1` int(10) NOT NULL default '0',   `location2` int(10) NOT NULL default '0',   `loginattempts` tinyint(2) NOT NULL default '1',   `failedlogin` bigint(30) NOT NULL default '0',   PRIMARY KEY  (`sid`),   KEY `location1` (`location1`),   KEY `location2` (`location2`),   KEY `time` (`time`),   KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;