MyBB Community Forums
[F] [MyBB 1.4.1] SQL error before upgrade - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: Archived Bug Reports (https://community.mybb.com/forum-74.html)
+------ Forum: MyBB 1.4.1 (https://community.mybb.com/forum-93.html)
+------ Thread: [F] [MyBB 1.4.1] SQL error before upgrade (/thread-36186.html)

Pages: 1 2


[F] [MyBB 1.4.1] SQL error before upgrade - NoRules - 2008-08-19

Hi all!.

I'm gonna ask you to help me with this error that didn't allow me to upgrade my forum. Here it comes the data:

1) What version of MyBB you are upgrading from: 1.1.8
2) Plugins are deactivated but i didn't deleted from the inc/plugins directory.
3) Exact error received:
Fatal error: [SQL] [1054] Unknown column 'loginattempts' in 'field list'
UPDATE mybb_sessions SET uid='2', loginattempts='1' WHERE sid='wh0car3s4t4ll98e206c89d83fd6c1d0y4' in http://myserver.com/forum/inc/db_mysql.php on line 544

(sid & URL are no real Wink)
4) The page you were trying to access:
When you type the admin user and his password (first page of the upgrade), and presses the button, then appears that.

When I saw this error I went to the phpMyAdmin and looked for the mybb_sessions table and there for the loginattempts field but I only have those fileds:
sid
uid
ip
time
location
useragent
anonymous
nopermission
location1
location2

---------------------
Many Thanks.


RE: [MyBB 1.4.1] SQL error before upgrade - DCR - 2008-08-19

And just to make sure, you are selecting 1.1.8 when prompted for the version you are upgrading from?


RE: [MyBB 1.4.1] SQL error before upgrade - NoRules - 2008-08-19

(2008-08-19, 06:37 AM)DCR Wrote: And just to make sure, you are selecting 1.1.8 when prompted for the version you are upgrading from?

I can't select any version (this is the second web that appears and I can't reach it)


RE: [MyBB 1.4.1] SQL error before upgrade - Dennis Tsang - 2008-08-19

(2008-08-19, 09:33 AM)NoRules Wrote:
(2008-08-19, 06:37 AM)DCR Wrote: And just to make sure, you are selecting 1.1.8 when prompted for the version you are upgrading from?

I can't select any version (this is the second web that appears and I can't reach it)

Can you give a screenshot? What version options do you have?


RE: [MyBB 1.4.1] SQL error before upgrade - NoRules - 2008-08-22

(2008-08-19, 11:23 PM)DennisTT Wrote: Can you give a screenshot?
Here they are:
   
Firts page of the upgrade. I insert my admin user and its password. Then I press the "Login" button, and...
   
The White Screen of Dead appears Undecided

(2008-08-19, 11:23 PM)DennisTT Wrote: What version options do you have?
Excuse me? Versions options?

-------------------------------------------------------

Many thanks


RE: [MyBB 1.4.1] SQL error before upgrade - Matt - 2008-08-22

Yes, when you log in to the upgrader you will have to choose which version you are upgrading from, i.e. 1.1.8


RE: [MyBB 1.4.1] SQL error before upgrade - NoRules - 2008-08-22

Ah! Thanks Matt_

But as you could see on the screenshots, i can't login (when I try to it "crashes")

:|


RE: [MyBB 1.4.1] SQL error before upgrade - Matt - 2008-08-22

Did you upload a backup before this?? Because you would need to log in with your usual login.


RE: [MyBB 1.4.1] SQL error before upgrade - NoRules - 2008-08-22

(2008-08-22, 11:23 AM)Matt_ Wrote: Did you upload a backup before this??
Yes I upload a 1.1.8 backup before the ugrade.

(2008-08-22, 11:23 AM)Matt_ Wrote: Because you would need to log in with your usual login.
I try to login with my Admin user (as is said on the Upgrade Wiki)


RE: [MyBB 1.4.1] SQL error before upgrade - KuJoe - 2008-08-22

You seem to be missing the following in the mybb_sessions table:

loginattempts
failedlogin

EDIT: Attached pics of their default settings in phpMyAdmin.