Error Number: 1054
How Do I?
Hi All,
I seem to be getting a white screen of death on the “System” directory after moving an EE site to another server. It’s currently running on 2.9.2. I turned on debug mode and got the following error:
A Database Error Occurred Error Number: 1054
Unknown column ‘sess_start’ in ‘field list’
INSERT INTO exp_sessions (admin_sess, session_id, ip_address, user_agent, member_id, last_activity, sess_start, fingerprint) VALUES (1, ‘2050e961294359515d6732a160850dcb2491a826’, ‘81.xxx.xxx.xxx’, ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36’, 1, 1435579185, 1435579185, ‘b89d80a5323e17c04cc0bfec10a1b2fa’)
Filename: libraries/Session.php
Line Number: 409
Any thoughts or ideas on how to resolve this?
My thought would be that you delete the admin session above from the exp_sessions table. That should clear the existing admin login session info leaving you free to log in. You may have to delete other sessions as well for any other logged in users.
I am still a noob to EE so this may not be correct, but intuitively it feels like the solution.