Critical! Cannot log in any more! pls help

Permalink 1 user found helpful
I updated two add ons from the marketplace, blogga and another I cannot remember now.

Both updates failed, the error message was: You did not upload a working zip file or zip is not installed.

After that, my blogga pages were all empty. All content had gone.

I then did a restore from my database. Now I cannot login to my dasboard anymore. The error message:

mysql error: [1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("SELECT uID, uName, uIsActive, uLastOnline, uTimezone, uDefaultLanguage FROM Users WHERE uID = '1'")

I resent passwrd, reset password, everything ok, but login failed again, same errormessage.

Please help!!

rritz
 
hostco replied on at Permalink Reply
hostco
Is the restore of your database from an older version of Concrete5 or is it a recent backup from the same version of Concrete5 that you are using now?
rritz replied on at Permalink Reply
rritz
Its the same version, I made the data base back up in 11th of August 11, and the only updates I made inbetween are the add on updates that failed
12345j replied on at Permalink Best Answer Reply
12345j
hey- can you register a new account? here are a couple possible solutions-
1- create a new file in the root/concrete directory of your site. into that file, put this code
User::loginByUserID(1);
then view the tools file inn your browser. If it works, great, otherwise give me the error message.
2- do a sql query- If you can access the db with a tool like php my admin run the following code.
ALTER TABLE users ADD uDefaultLanguage VARCHAR(32);


but you really shouldn't be getting that error anyways unless you restored from a different version then you are currently on.
whitelionent replied on at Permalink Reply
What do I name the file in the root with the code "User::loginByUserID(1);"?
12345j replied on at Permalink Reply
12345j
name it admin_login.php or something like that- it shouldn't matter, you just have to remember what you named it.
whitelionent replied on at Permalink Reply
Yeah I did that.. but I just get nothing?
whitelionent replied on at Permalink Reply
Can I pm you please? Sorry to bother
12345j replied on at Permalink Reply
12345j
sure. If you give me ftp access I'll try to fix it for you.
-jack
whitelionent replied on at Permalink Reply
I messaged you, thanks a lot for your help :)
whitelionent replied on at Permalink Reply
You are a legend! Thank you for your help :) Greatly appreciated :)
sebpowell replied on at Permalink Reply 1 Attachment
Hi Jack,

I'm experiencing the same problem as the one described in this thread, after moving a site to a different host.

Looks like the column uDefaultLanguage doesn't exist in my database, which seems to be the problem. I've tried following your instructions to add the column in the database, but when I try doing this via phpMyAdmin I get an error message (see attached screenshot).

Judging from what's been said in the thread, it seems you have experience in fixing this problem so I'd really really appreciate it if you could help me out as I'm not too sure what to do.

Thanks,

Seb
12345j replied on at Permalink Reply
12345j
sure, just pm me phpmyadmin details.
RobertJNL replied on at Permalink Reply
RobertJNL
With 'strange' issues somehow it frequently helped me out when i trashed the /tmp folder.
Steevb replied on at Permalink Reply
Steevb
I did the same and it fixed the issue.
gumbyblue replied on at Permalink Reply
Is it safe to delete the entire /tmp folder with contents?
Steevb replied on at Permalink Reply
Steevb
I was talking about dumping server disk space /tmp folder in cPanel.

I had more than one of the same add on and concrete folders.

If you are talking about the same thing then it is usually ok, but you might want to check what's in there first.