Can't log in
Permalink
I am a beginner with Concrete5, looking for a way to get an attractive and flexible website without too much of a learning curve. Things have been working well for several months, until this week.
I am no longer able to log in to my website. I get the following error message (ellipses inserted for user name and password):
mysql error: [1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("select uID, uName, uIsActive, uIsValidated, uTimezone, uDefaultLanguage from Users where uName = '...' and uPassword = '...'")
Resetting the password does not help. My hosting service assisted me in accessing the database and resetting the password manually, also without the desired result.
This problem occurred after I made two changes: upgrade of the Concrete5 version, and installation of an add-on (Amiant Image Gallery). After the install, I created a new page with an Amiant block. This seemed to work for awhile, but then could not be edited successfully. I finally tried to delete the entire page, but this did not work, either. To get rid of the faulty page, I then did a restore (from a backup made just before the changes—I believe it was before the Concrete5 version upgrade, also).
Login worked for awhile, but has now failed.
Any help with this is very much appreciated!!
I am no longer able to log in to my website. I get the following error message (ellipses inserted for user name and password):
mysql error: [1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("select uID, uName, uIsActive, uIsValidated, uTimezone, uDefaultLanguage from Users where uName = '...' and uPassword = '...'")
Resetting the password does not help. My hosting service assisted me in accessing the database and resetting the password manually, also without the desired result.
This problem occurred after I made two changes: upgrade of the Concrete5 version, and installation of an add-on (Amiant Image Gallery). After the install, I created a new page with an Amiant block. This seemed to work for awhile, but then could not be edited successfully. I finally tried to delete the entire page, but this did not work, either. To get rid of the faulty page, I then did a restore (from a backup made just before the changes—I believe it was before the Concrete5 version upgrade, also).
Login worked for awhile, but has now failed.
Any help with this is very much appreciated!!
Interesting. The website has 2 administrative accounts and neither table has the uDefaultLanguage row. All other rows are the same as those shown on your attachment. Any suggestions?
The first attempts at resetting the password were done via C5 login.
Thanks!!
The first attempts at resetting the password were done via C5 login.
Thanks!!
The log in problem seems to be solved!!
I found this posting:http://www.concrete5.org/community/forums/installation/critical-can...
The SQL query works, although the db name "Users" needs to be capitalized, as follows:
ALTER TABLE Users ADD uDefaultLanguage VARCHAR(32);
Can't figure why the uDefaultLanguage column was dropped, but this restores it. I'm posting this here, in case others encounter similar problems.
I found this posting:http://www.concrete5.org/community/forums/installation/critical-can...
The SQL query works, although the db name "Users" needs to be capitalized, as follows:
ALTER TABLE Users ADD uDefaultLanguage VARCHAR(32);
Can't figure why the uDefaultLanguage column was dropped, but this restores it. I'm posting this here, in case others encounter similar problems.
It seems like a MySQL problem.
1 - When you changed your password on the database, did you consider the hash? As far as I know, only way to do that is copying the password from another C5 Installation, and changing the hash to the same on the other Installation.
2 - Error 1054 means C5 couldn't find a column in the table. Specifically, uDefaultLanguage.
I'd suggest:
1 - Log in manually to your mySQL Server and go to the "Users" table.
Check if the Schema is similar to the one I've attached. Possibly the line uDefaultLanguage is missing or somewhat broken.
If it is allright, go to the view of this table, click the edit button for the Admin, and empty the uDefaultLanguage. After saving it should become "NULL".
Maybe you uninstalled a language or something?
Well, check if that did the trick and then tell me.
Also, if you changed the password ignoring the hash it possibly broke your password. If that happened, try resetting through C5 or asking here again. ^^
Best of luck.