Cant login after upgrade

[Juan Carlos]

I just upgrade two forums to the last Github today and in one of them all works perfectly but in the other when the upgrade finish (without errors) the login screen apears and I cant not acces.

Some ideas?

[vbgamer45]

Check your smf's forum's error log database table and grab the latest entries after trying to login.

[Juan Carlos]

Thanks for answer

This is the error in log:

Data Base Error: Data too long for colum...

[vbgamer45]

Can you expand the data or get complete message from error log?
We need to find out what column and what database table.

[Juan Carlos]

Ok sorry I think this is the information

url   text ?action=login2

message   text   Database error: Data too long for column 'password_salt' at row 1

file   varchar(255) /homepages/8/d361504127/htdocs/cuatro/foro/Sources/Subs.php
line   mediumint( unsigned 412

backtrace   varchar(10000)         
[{"file":"\/homepages\/8\/d361504127\/htdocs\/cuatro\/foro\/Sources\/Subs-Db-mysql.php","line":489,"function":"smf_db_error"},{"file":"\/homepages\/8\/d361504127\/htdocs\/cuatro\/foro\/Sources\/Subs.php","line":412,"function":"smf_db_query"},{"file":"\/homepages\/8\/d361504127\/htdocs\/cuatro\/foro\/Sources\/LogInOut.php","line":402,"function":"updateMemberData"},{"file":"\/homepages\/8\/d361504127\/htdocs\/cuatro\/foro\/index.php","line":173,"function":"Login2"}]

[vbgamer45]

What version of SMF did you upgrade from?

[Juan Carlos]

2.1

[Juan Carlos]

Hi
Did you find something that can help me?

[m4z]

How did you "upgrade"? Did you try to use upgrade.php, or did you just replace the files?

[vbgamer45]

I haven't been able to find the cause. I am not sure what cause the password_salt to exceed 255 characters.

[Juan Carlos]

I use the upgrade.php.

Is extrange because I made the same in two forums and one run perfectly

Can I made something to acces?

[m4z]

I might be mistaken, but IIRC you aren't supposed to use upgrade.php when upgrading the development version, because to the script, both/all development versions (beta*, rc*, or any other) are the same.

[Illori]

if you have *ever* installed SMF 2.1, you need to run the upgrade.php file to upgrade to another release or version on GitHub. without doing that you will be missing all the database changes.

[m4z]

if you have *ever* installed SMF 2.1, you need to run the upgrade.php file to upgrade to another release or version on GitHub. without doing that you will be missing all the database changes.

Define "version". A released version? Or does this also apply to commit IDs "on top" of RC2?

If I understand correctly, Juan Carlos installed RC2, then upgraded to the current git HEAD, then ran upgrade.php.

[Illori]

tech will need to run upgrade.php in that case.

[m4z]

Interesting, I didn't know that. I did the same(?) (initially installed rc2, then just updated (replaced) the files from GH afterwards), never ran upgrade.php once.

[shawnb61]

Interesting, I didn't know that. I did the same(?) (initially installed rc2, then just updated (replaced) the files from GH afterwards), never ran upgrade.php once.

That would be a problem.  The only way to get db updates and data fixes is to run the upgrader.

[Juan Carlos]

Yes,
I have version 2.1 rc2 installed from the beginning and I have been doing frequent updates from the github in two forums always running the upgrade.
It is the first time that the problem appears (and only in one of the forums)

[shawnb61]

JC - Would it be possible to share phpinfo for the environment where it's not working?

The way the salt was generated changed a couple weeks ago.  The random number generation changed. 

My first thought is that the random # library being used is one that is not used often???  It checks to see what's available & so may use different logic in different environments.


(For the record, JC has a solid track record of identifying - real - issues...)

[Juan Carlos]

Hello

Here is the my php info file

Thank you very much