Thread

Hi there,

I’m trying to upgrade Expression Engine from 2.1.0 to 2.5.2.
The upgrade process appears to complete normally and progresses to each newer version with no errors, but the database schema is left unchanged.

Due to several changes in the newer versions (e.g. the move to a salt-based hashing system),  the users are then unable to log into the admin control panel.

Do you have any idea why this would happen, and how I can fix it?

Thanks

Hi tracesmart,

Welcome to the forums! I am sorry to see you’ve had trouble with the update process.

The upgrade process appears to complete normally and progresses to each newer version with no errors, but the database schema is left unchanged.

What leads you to believe the schema is unchanged? One table to look for is exp_developer_log. If that table exists, the update made changes.

Have any of the users gone through the “Forgot password” process to reset their passwords?

I look forward to your reply!

Cheers,

Hi there,

I just performed another upgrade from the backup copy I made.
It proceeds to version 2.5.2 with no errors, but when I try to reset the admin password I get the following error:

A Database Error Occurred
Error Number: 1054

Unknown column ‘salt’ in ‘field list’

UPDATE `exp_members` SET `salt` = ‘(removed)

Filename: libraries/Auth.php

Line Number: 423

Hi tracesmart,

Can you verify the database selected in /system/expressionengine/config/database.php

Are the credentials there correct for your site?

Cheers,

Yes, the database details are correct.

Hi Paul,

I’ve honestly never seen anything like this.

Have you renamed or moved your /system folder?

Do you have an alternate prefix for your database tables?

If you have changed the name of /system , make sure you update /admin.php with that information. admin.php is new between 2.1 (not included) and 2.5.2 It was first included with ExpressionEngine 2.2

Can you tell me exactly what process you are going through to perform the update?

Cheers,

We have moved the system folder, the structure looks like this:

-- sitename/public/ (Apache document root)
     -- images/
     -- themes/
     -- index.php etc..

 -- sitename/admin/
     -- expressionengine/
         -- config/
             -- database.php
             -- config.php etc..

 -- sitenameadmin/public/ (Apache document root)
     -- index.php

The last file in that list contains the $system_path setting and this is accessed as a different VirtualHost in Apache for security reasons.

To perform the update, I follow the standard instructions and use the URL for our Admin CP.

Hey tracesmart,

Quick question.

Is the database on the same host as ExpressionEngine?

I am not sure what that last location is about, the one on the bottom with another index.php.

Thank you,

The database is on a different host.

The last location is the primary index.php for the Admin CP and pulls in the bootstrap from the middle set of directories.

Hi Paul,

While what you are doing here is certainly not main-stream, it should technically work.

So, we would like to get in for a closer look. Be on the lookout for an email from EllisLab and be sure to include a means for us to access your database.

Cheers,

Hi Paul,

Have you had a chance to look at the email we sent?

We would really like to give you some hands-on assistance with this if you still need help!

Cheers,

Hi there.

I asked Paul and he didn’t get the email (I’m a SysAdmin at our company who’s trying to upgrade EE).
I’ll try some other ways of upgrading then post back if it doesn’t work out.

Hey tracesmart,

Thanks for letting us know. We will be on the lookout for an update from you.

Cheers,