cannot login after upgrad from 2.0 Beta 3.1 to Beta 4

Started by zeroandone, September 18, 2008, 02:45:30 PM

Previous topic - Next topic

zeroandone

I upgraded my forumn from SMF 2.0 Beta 3.1 to Beta 4 today. The upgrade went through without any error, but after the upgrade, I cannot login. It keeps giving me this error:
Database Error
Please try again. If you come back to this error screen, report the error to an administrator. 

I have tried to use both the Smalll Update and the Large Upgrade, but no difference.

The error log in database shows this: "Database Error: Unknown column 'passwd_flood' in 'field list'"

Please help.
ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

zeroandone

ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

zeroandone

ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

0413

I am having this problem as well, not sure what to do.

zeroandone

So I am not alone. Can someone tell us what to do? My site has been down for several hours :'( :'( :'(
ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

RoarinRow

I'm having the same problem   :o  I even tried the Settings Repair Tool and that didn't help.

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

0413

I made the mistake of logging out to try and login.  No I can't even get in to access the admin.  I wonder if there is something in there.

zeroandone

I even tried to manually run upgrade_2-0_mysql.sql in PhpMyAdmin to upgrade my database, but it gives me error complaining some invalid string at some line.

So is it a bug in the upgrade? What should I do now? Please advice, my site has been down for a full day now. :'( :'( :'( :'( :'(
ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

metallica48423

I understand that you're between a rock and a hard place, however, please don't bump a topic unless 24 hours have passed with no reply or PM team members requesting help.  we all work on a volunteer basis here. Thanks. 

The developers are looking at this one trying to figure out why this field isn't getting added.

In the meantime, using PHPMYADMIN -- What is phpMyAdmin? -- or whichever database management tool your host provides, run this query, where smf_ is your table prefix -- so if you changed it to smf2_, change that to smf2_.  It needs to match what your members table is titled.


ALTER TABLE smf_members
ADD passwd_flood varchar(12) NOT NULL default '';
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

JamesD01

I have the same problem, I created a topic and no response!

Anyway, I'll try what metallica48423 suggested with phpmyadmin..
Best regards,
James

JamesD01

Error
SQL query:

ALTER TABLE smf_membersADD passwd_flood varchar( 12 ) NOT NULL default ''

MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'passwd_flood varchar(12) NOT NULL default ''' at line 1

I got that error when trying to run that query...

Any other ideas?
Best regards,
James

zeroandone

I am having trouble connection to my database with phpMyAdmin, so I can't test it right now. But I think you can try this:
ALTER TABLE smf_membersADD passwd_flood varchar( 12 ) NOT NULL default \'\'
ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

JamesD01

Quote from: zeroandone on September 19, 2008, 03:02:30 PM
ALTER TABLE smf_membersADD passwd_flood varchar( 12 ) NOT NULL default \'\'
Still got the error :-\ :(
Best regards,
James

zeroandone

Well, there is a space between "smf_member" and "ADD":
ALTER TABLE smf_members ADD passwd_flood varchar( 12 ) NOT NULL default \'\'
ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

0413

Quote from: metallica48423 on September 19, 2008, 02:16:16 PM
I understand that you're between a rock and a hard place, however, please don't bump a topic unless 24 hours have passed with no reply or PM team members requesting help.  we all work on a volunteer basis here. Thanks. 

The developers are looking at this one trying to figure out why this field isn't getting added.

In the meantime, using PHPMYADMIN -- What is phpMyAdmin? -- or whichever database management tool your host provides, run this query, where smf_ is your table prefix -- so if you changed it to smf2_, change that to smf2_.  It needs to match what your members table is titled.


ALTER TABLE smf_members
ADD passwd_flood varchar(12) NOT NULL default '';


worked like a charm.  Thanks so much for the info!!! 

zeroandone

Finally I got to connect to my DB. Yes, it worked like a charm. Thanks a bunch and very sorry for bothering you via IM, metallica48423.
ASP.NET developer
Drupal fan
Joomla fan
Ubuntu newbie
http://www.codingbeaver.com

metallica48423

not a problem.

I apoligize if i came across as harsh
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

edi67

this solution solved my problem too thx

PS. one question but why need this modification in DB for make our users login ? in smf 2 3.1 beta there wasn't problem
CrazyZone - My SMF Forum


From the difficult the hardening of the man you can see

metallica48423

Quote from: edi67 on October 10, 2008, 04:45:33 PM
this solution solved my problem too thx

PS. one question but why need this modification in DB for make our users login ? in smf 2 3.1 beta there wasn't problem

The upgrader doesn't always fail to add the field.  As i said, as far as i'm aware we haven't been able to determine why this field isn't getting added -- it is certainly in the upgrader
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

metallica48423

#19
Can I get some information from you guys that had this problem?

Specifically, can I get your PHP version, your MySQL version, the version of SMF you upgraded from, and the version you upgraded to.

Also, are there any error logs pertaining to the issue?

Link to bugtracker ticket: Bug 2294
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

edi67

Quote from: metallica48423 on October 10, 2008, 06:57:31 PM
Specifically, can I get your PHP version, your MySQL version, the version of SMF you upgraded from, and the version you upgraded to.

Mine:
phpMyAdmin - 2.9.1, php4/5 

mysql version how i can find this data?
CrazyZone - My SMF Forum


From the difficult the hardening of the man you can see

Deprecated

I had this exact problem myself the first time I upgraded a Beta 3.1 to Beta 4. Here is how I fixed it:

Download the Beta 4 small update package and extract it to a local folder on your PC. Discard all the files except the upgrade*.* ones. Upload those 5 files to your SMF directory (same one as SSI.php). Execute upgrade.php by typing in the appropriate URL to your browser and follow the prompts. Delete the 5 files when you are done.


(I'm pretty sure that only upgrade.php and upgrade_1-1.sql are required, but the rest won't hurt.)

metallica48423

#22
To verify... you guys *did* run the upgrade.php between beta 3.1 and beta 4 -- correct?

phpMyAdmin should have information on the mysql version
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Deprecated

I've noticed that this topic icon has changed to "solved."

Has the OP reported that he solved his problem?

motuoverseer

I had the same issue, but this fixed it in a second.  Thanks a lot metallica48423!

Requested Information:
PHP version   4.4.9
MySQL version   4.1.22-standard
Upgraded from Beta 31. to Beta 4
We must stop asking: How can these things be?  And begin asking: Why are these things?

holodoc

I too had the problem but I think that the problem started to appear as I added the Sebian Cyrillic UTF-8 language pack.

The above solution solved my problem.

Requested Information:
PHP version   5.1.6
MySQL version   5.0.45
Upgraded from Beta 3.1.to Beta 4

Advertisement: