Current time: 05-24-2012, 06:24 AM Hello There, Guest! (LoginRegister)


 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] [MyBB 1.4.1] SQL error before upgrade
08-19-2008, 06:32 AM
Post: #1
Exclamation [F] [MyBB 1.4.1] SQL error before upgrade
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.
Find all posts by this user
08-19-2008, 06:37 AM
Post: #2
RE: [MyBB 1.4.1] SQL error before upgrade
And just to make sure, you are selecting 1.1.8 when prompted for the version you are upgrading from?

Visit this user's website Find all posts by this user
08-19-2008, 09:33 AM
Post: #3
RE: [MyBB 1.4.1] SQL error before upgrade
(08-19-2008 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)
Find all posts by this user
08-19-2008, 11:23 PM
Post: #4
RE: [MyBB 1.4.1] SQL error before upgrade
(08-19-2008 09:33 AM)NoRules Wrote:  
(08-19-2008 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?

Dennis Tsang :: MyBB Developer
Follow me on Twitter: @dennistt
Visit this user's website Find all posts by this user
08-22-2008, 06:13 AM
Post: #5
RE: [MyBB 1.4.1] SQL error before upgrade
(08-19-2008 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

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

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

Many thanks
Find all posts by this user
08-22-2008, 10:36 AM
Post: #6
RE: [MyBB 1.4.1] SQL error before upgrade
Yes, when you log in to the upgrader you will have to choose which version you are upgrading from, i.e. 1.1.8

Download My Plugins
My Personal Site - Twitter
[Image: eX4bjF]
Visit this user's website Find all posts by this user
08-22-2008, 11:22 AM
Post: #7
RE: [MyBB 1.4.1] SQL error before upgrade
Ah! Thanks Matt_

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

:|
Find all posts by this user
08-22-2008, 11:23 AM
Post: #8
RE: [MyBB 1.4.1] SQL error before upgrade
Did you upload a backup before this?? Because you would need to log in with your usual login.

Download My Plugins
My Personal Site - Twitter
[Image: eX4bjF]
Visit this user's website Find all posts by this user
08-22-2008, 11:33 AM
Post: #9
RE: [MyBB 1.4.1] SQL error before upgrade
(08-22-2008 11:23 AM)Matt_ Wrote:  Did you upload a backup before this??
Yes I upload a 1.1.8 backup before the ugrade.

(08-22-2008 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)
Find all posts by this user
08-22-2008, 12:15 PM (This post was last modified: 08-22-2008 12:21 PM by KuJoe.)
Post: #10
RE: [MyBB 1.4.1] SQL error before upgrade
You seem to be missing the following in the mybb_sessions table:

loginattempts
failedlogin

EDIT: Attached pics of their default settings in phpMyAdmin.


Attached File(s) Thumbnail(s)
   

-Joe
+Secure Dragon LLC. - Secure your data with a dragon!
+MyHosting - cPanel Plugin
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 3 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication