Is the front of your site behaving normally?

Are there any changes you have recently made?

Has your hosting company recently made any changes to your web server environment?

John,
- the front side behaves normally
- we have changed the template to Yosemite and bought a new one but have not applied that one yet
- i am not aware of any changes to the server environment from my hosting company. how can I find out?

Greetings, Reinhold

I have done a few searches through old core versions and uDefaultLanguage was added to that table round about c5.5.

Maybe (big maybe) the version of the c5 code you are running is out of step with the database. Such as, new code, but old database.

What version of c5 are you currently running, what version did you start with? and what is your history of upgrades.

Have you restored the database from an old backup at any point?

Hi John,
answering your questions:
- The front side is behaving normally – although the header on the front side is misplaced, seehttp://www.konsultation-gg.de
- We are using version 5.4.2.2 for a long time. No updates recently.
- Changes we have made: A backup in early October
- We bought a new template, but haven’t applied it yet

The present template worked fine before until suddenly the error appeared.
Thanks for help - or for a possibility to access the backup ...
Reinhold

I have made a specific search of 5.4.2.2 and that column is supposed to be in the database.

If you are familiar with phpMyAdmin or another database management tool and have access, I advise checking the structure of the Users table to see if that column is actually present. From an old 5.4.2.2 database on my development system I have:

Column Type Collation

1 uID int(10)
2 uName varchar(64)
3 uEmail varchar(64)
4 uPassword varchar(255)
5 uIsActive varchar(1)
6 uIsValidated int(4)
7 uIsFullRecord int(1)
8 uDateAdded datetime
9 uHasAvatar int(1)
10 uLastOnline int(10)
11 uLastLogin int(10)
12 uPreviousLogin int(10)
13 uNumLogins int(10)
14 uTimezone varchar(255)
15 uDefaultLanguage varchar(32)

Dear John,
thanks for the reply! However, I am a very lay c5 user, and this is Chinese to me :-( The reason I chose Concrete5 was exactly because I do not know much about what is going on in the background. What I understand is that I cannot get into the backend of my site. Database management is completely unknown to me. Any other way to get "in"?
Thanks a lot, Rinaldo

-----Ursprüngliche Nachricht-----
Von: concrete5 Community [mailto:discussions@concretecms.com]
Gesendet: Freitag, 22. November 2013 18:48
An: rscharnowski@gmx.ch
Betreff: I cant get in any more - mysql error. Help!! : Editing with concrete5

There are a few utilities that can be run from within the concrete5 dashboard to glean the same information, but that is not much use with a database problem that prevents login.

An outside chance is to manuallyre-run the 5.4.2.2 upgrade utility, perhaps reverting to 5.4.1.1 before doing so. However, upgrading can go badly wrong and this process could make things worse. It is always a very good idea to make a full database and files backup before upgrading (again, not much use if you can't login, but you could backup via phpMyAdmin).

So, some options

a) Find someone who can at least look at your database and make some checks for you and ideally make a new backup, even if they don't know enough about concrete5 to draw any conclusions.

b) Learn enough about checking out your database via phpMyAdmin to do the above yourself.

c) Contract an expert to sort it all out.

d) Take a big risk and manually run the 5.4.2.2 upgrade again
http://yoursite.com/index.php/tools/required/upgrade...

e) Take an even bigger risk and manually revert config/site to 5.4.1.1 and run the 5.4.2.2 upgrade again.

f) Take a massive risk and download 5.5.2.1, unzip it and upgrade manually to 5.5.2.1 (there are instructions in the install file in the zip)

Bear in mind that if you try (d),(e) or (f) and it goes wrong, things could get considerably worse and without a new backup you could be completely stuck.