Problem with my Site after Update to 5.4.2.2

Permalink
Hello, i updated now to 5.4.2.2 and after logout i cant log in .. this message came to me..
mysql error:

[1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("select uID, uName, uIsActive, uIsValidated, uTimezone, uDefaultLanguage from Users where uName = 'admin' and uPassword = 'xxxxxxxxxxxxxxxxxxxxxxxx'")

any idea? :-D best regards

r.w

ebooki
 
ebooki replied on at Permalink Reply
ebooki
Has nobody an idea?

:-D

greets r.w.
mesuva replied on at Permalink Reply
mesuva
What version did you upgrade from?

Can you have a look at the Users table in your database and check if the field uDefaultLanguage is there?

I can tell that that field was in the Users table back at 5.4.2, but I don't know about any further back. I'm thinking perhaps your upgrade didn't update changes to the database properly.
ebooki replied on at Permalink Reply 1 Attachment
ebooki
Hello,
thx for reply.

now the version is 5.4.1.1 i want to make the update first to 5.4.2.2. then came the problem..

i looked into the mysql
Users Table.. There is no uDefaultLanguage field…
How can I make this filed in the Users Table?
Sorry.. my English is terrible, but I hope you understand that 

Greets from Germany
r.w.
ebooki replied on at Permalink Reply
ebooki
Hello.. do you have an idea??
greets
r.w.
LucasAnderson replied on at Permalink Reply
LucasAnderson
Anything happen when you visits yoursite.com/index.php/tools/upgrade
mesuva replied on at Permalink Reply
mesuva
You may be able to just added the missing column to the table, using something like phpMyAdmin or similar...

...But if you've done an upgrade and a table hasn't been updated, there could be other things it hasn't updated. This could result in more problems down the track.

I would restore your old site from backup, or try to set up the old site somewhere else and try the upgrade again.