Thread

I am unable to log into my CP after upgrading from EE 2.1.3 to 2.5.3.  The site is hosted with Engine Hosting.

I forgot to log out of my CP when I did the upgrade so I’m not sure if that caused a problem.  When I try to log into CP I keep getting “Someone is already logged in using this account.”  I even tried logging in using another member account and it just reloads a blank login form after I submit.

Other things I noticed was if I change my config.php file to turn the site on it shows a blank home page.

I tried editing the config file to allow multiple users, to ignore ip address, and more but nothing helped.

Thanks.
Lori

Hi L2,

First, let’s work on getting you back into your installation. Ask EngineHosting if they’ll truncate your exp_sessions table to make sure the system sees all users as logged out. Next, make sure you’ve cleared the cache on your browser and cleared any cookies that your browser set for your site’s domain name. If you’re still unable to log in after that, let us know and we’ll dive in for a look ourselves.

Hi Kevin,

I will ask Engine Hosting to truncate your exp_sessions table as you recommended.  If that works and I can log in, I will follow the rest of your instructions.  I will let you know how I make out.

I reposted this issue about an hour ago here: http://ellislab.com/forums/viewthread/227928/ so I’m not sure if you want to delete that one.

Thanks.
Lori

Hi Kevin,

I truncated the exp_sessions then tried to log in but it didn’t help.  When I look at the database via PHPAdmin interface I can see that I’m logged in but on the front end I am not being taken to the actual control panel.  Instead I’m redirected back to the login form page. 

Engine Hosting had me turn on the debugging in the public_html/index.php page and this is the error I received.

Error Number: 1146

Table 'ehXXXXX.exp_files' doesn't exist

SELECT * FROM (`exp_files`) WHERE `upload_location_id` IN ('1') AND `file_name` IN ('feature2.png')

Filename: models/file_model.php

Line Number: 346

Thanks.
Lori

Hi Lori, just so I’m clear- the update itself appeared to run fine and cycled through to 2.5.3, ending by telling you you’ve successfully updated.  Correct?

Let’s see if we can’t force you into the backend.  Let’s try cookies only first- if that doesn’t work, we’ll try cookies only.  So- edit your sytem/expressionengine/config/config.php file and set

$config['cookie_domain'] = "";
$config['cookie_path'] = "";
$config['cookie_prefix'] = "";
$config['admin_session_type'] = "c";
$config['user_session_type'] = "c";
$config['require_ip_for_login'] = "n";
$config['require_ip_for_posting'] = "n";
$config['secure_forms'] = "n";

This is just for testing.  Clear your cookies- attempt to login to the backend.

Also- are you trying via admin.php or system/index.php and is it an MSM install?

Hi Robin,

Just so I’m clear- the update itself appeared to run fine and cycled through to 2.5.3, ending by telling you you’ve successfully updated.  Correct?

Yes, that is correct.  The update ran fine it wasn’t until I tried logging into the control panel that I had an issue.

Let’s see if we can’t force you into the backend.  Let’s try cookies only first- if that doesn’t work, we’ll try cookies only.  So- edit your sytem/expressionengine/config/config.php file and set

$config[‘cookie_domain’] = “”;
$config[‘cookie_path’] = “”;
$config[‘cookie_prefix’] = “”;
$config[‘admin_session_type’] = “c”;
$config[‘user_session_type’] = “c”;
$config[‘require_ip_for_login’] = “n”;
$config[‘require_ip_for_posting’] = “n”;
$config[‘secure_forms’] = “n”;

I changed my config.php file as you suggested, cleared my browser cookies, cache, etc. but I got the same result - it looks like it is processing my login then I am taken back to the login page.  When I check the database via the PHPAdmin interface I can see the new record in exp_sessions showing I am logged in.

Are you trying via admin.php or system/index.php and is it an MSM install?

I am logging in using admin.php so “www.domain.com/admin.php”.  No, it is not an MSM install, it’s just one site.

Thanks.
Lori

Hrm- I’m going to send over an email so we can go in and take a closer look.  Before you reply, though- might try switching it to sessions only and see if that does any better.  Clear cookies, set

$config['admin_session_type'] = "s";

Also- just to be sure- if you have an htaccess file- remove/rename it when you test.

If that doesn’t work?  Reply back to the email and we’ll take a closer look.

Hi Robin,

I tried your suggestion of switching it to sessions but it didn’t work.  Therefore, I replied back to your email.

Thanks for your help.
Lori

Hi Lori, all,

Just a note to let everyone know we are working with Lori on this and will post back when we have a solution.

Thanks!

Has anyone come up with the solution to this problem. We have attempted to upgrade from v2.0.2pb01 to 2.5.3. I have followed the troubleshooting steps provided in the threads (http://ellislab.com/forums/viewthread/227828/) and nothing has worked. I truncated the exp_sessions table. I have also enabled logging for Expression Engine and not seeing any error messages from the expression engine side nor the apache side.

I ended up having to rollback to my previous EE version 2.1.3 then update it again and it worked the second time.  I’m not certain but I think it may have had to do with one of my addons called “NDG Flex Admin” which is now it’s called “Zoo Flex Admin”.  I basically uninstalled Flex Admin, did the EE update then installed the latest version of the addon and it worked ok.

Thanks.
Lori

Hey Lori,

I am glad that we were able to offers some help and that you are back up and running.

If you need anything else, please just let me know by opening a new thread.

Cheers,