I've recently upgraded mybb from 1.4.3 to 1.4.4 and now I can't login to my site without getting the below error
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'loginattempts' in 'field list'
Query:
SELECT loginattempts FROM mybb_users WHERE LOWER(username)='megaboost' LIMIT 1
Please contact the MyBB Group for support.
Could someone please help me as i've never had any issues like this before and everything was working fine until I upgraded and now I'm stumped.
p.s. I can login to my Admin if I input URL/admin but that's all i can do, the main site will not let me in
You have to run the upgrade script.
./install/upgrade.php and choose old version from the list.
Also search as this has been said so many times and also read announcements as this was said twice in the announcement.
Also make a database backup first.
./install/upgrade.php <--- Did that
I've searched and can't find a thing, sorry!
I'm still getting the same SQL Error
So you uploaded the 1.4.4 files, went to ./install/upgrade.php, chose 1.4.2/1.4.3 from the list, and ran it?? This is the exact error people get when they upload the 1.4.4 files but don't run the upgrader....
Does this happen when you login with the link in the welcomeblock or with a sidebox plugin??
I had the same problem. I ran the following in phpMyAdmin and all seems to be working now.
DROP TABLE IF EXISTS `mybb_sessions`;
CREATE TABLE `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=utf8;
(2008-12-13, 07:33 PM)Pilo Wrote: [ -> ]I had the same problem. I ran the following in phpMyAdmin and all seems to be working now.
DROP TABLE IF EXISTS `mybb_sessions`;
CREATE TABLE `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=utf8;
And you are now vulnerable to brute force attacks.
(2008-12-14, 11:15 AM)Pilo Wrote: [ -> ] (2008-12-14, 07:05 AM)Ryan Gordon Wrote: [ -> ]And you are now vulnerable to brute force attacks.
What should I do?
Run the upgrade procedures properly.
Sorry but that doesn't help. I believe I did run the upgrade procedures properly, otherwise I wouldn't have asked for help. I'm reluctant to go through it again without any plan to do it differently.
Well, the upgrade script will do everything to the database that needs doing... Ryan writes this stuff, chances are anything he says is what needs to be done.