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!!
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!!
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?
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
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 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.
but you really shouldn't be getting that error anyways unless you restored from a different version then you are currently on.
1- create a new file in the root/concrete directory of your site. into that file, put this code
User::loginByUserID(1);
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.
What do I name the file in the root with the code "User::loginByUserID(1);"?
name it admin_login.php or something like that- it shouldn't matter, you just have to remember what you named it.
Yeah I did that.. but I just get nothing?
Can I pm you please? Sorry to bother
sure. If you give me ftp access I'll try to fix it for you.
-jack
-jack
I messaged you, thanks a lot for your help :)
You are a legend! Thank you for your help :) Greatly appreciated :)
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
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
sure, just pm me phpmyadmin details.
With 'strange' issues somehow it frequently helped me out when i trashed the /tmp folder.
I did the same and it fixed the issue.
Is it safe to delete the entire /tmp folder with contents?
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.
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.