|
[F] [MyBB 1.4.1] SQL error before upgrade
|
|
08-19-2008, 06:32 AM
Post: #1
|
|||
|
|||
|
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 )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. |
|||
|
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?
|
|||
|
08-19-2008, 09:33 AM
Post: #3
|
|||
|
|||
| RE: [MyBB 1.4.1] SQL error before upgrade | |||
|
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? Can you give a screenshot? What version options do you have? Dennis Tsang :: MyBB Developer Follow me on Twitter: @dennistt |
|||
|
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 ![]() (08-19-2008 11:23 PM)DennisTT Wrote: What version options do you have?Excuse me? Versions options? ------------------------------------------------------- Many thanks |
|||
|
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 |
|||
|
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") :| |
|||
|
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 |
|||
|
08-22-2008, 11:33 AM
Post: #9
|
|||
|
|||
| RE: [MyBB 1.4.1] SQL error before upgrade | |||
|
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. -Joe +Secure Dragon LLC. - Secure your data with a dragon! +MyHosting - cPanel Plugin |
|||
|
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 3 Guest(s)
Search
Member List
Calendar
Help

)

