+- MyBBKursu.Com - MyBB Türkçe Destek Sitesi (https://www.mybbkursu.com)
+-- Forum: MyBB Dersleri (https://www.mybbkursu.com/forumdisplay.php?fid=6)
+--- Forum: Mybb Kullanımı - İpuçu (https://www.mybbkursu.com/forumdisplay.php?fid=11)
+--- Konu: İpuçu: 1054 - Unknown column 'loginattempts' in 'field list' Hatası Çözümü (/showthread.php?tid=31)
1054 - Unknown column 'loginattempts' in 'field list' Hatası Çözümü - **SaBRoZa** - 04-19-2026
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;