Forums

5.7.5.13 > any version 8 release

Permalink
I've tried upgrading my 5.7.5.13 site to any of the version 8 releases and I get the same error each time. 
An exception occurred while executing 'select uID, uIsActive, uLastPasswordChange, uIsPasswordReset from Users where uID = ? and uName = ?' with params ["1", "webmaster"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'uIsPasswordReset' in 'field list'

Has anyone got any ideas?
gavthompson
 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Its a long shot...
5.7 Users table does not have that column whereas Version 8 User table does.
So, I would expect the upgrade to create the extra column before writing the data to it.
Perhaps, You do not have ALL privileges set in phpMyAdmin,
In particular the 'Create' privilege in the database structure.
Essentially you should have ALL privileges set (Global)

As I said it is a long shot but worth checking..
gavthompson replied on at Permalink Reply
gavthompson
Thanks for the suggesting weboat,

I deleted the users and recreated it with full permissions, but still get the same error.
gavthompson replied on at Permalink Reply
gavthompson
Thanks for the suggesting weboat,

I deleted the users and recreated it with full permissions, but still get the same error.
Gondwana replied on at Permalink Reply
Gondwana
I'd be wondering about the update process you selected. If weyboat is right and you simply replaced the concrete directory, the update script may not have been run.
gavthompson replied on at Permalink Reply
gavthompson
I've tried running the update via the dashboard (placing the 8.1 concrete file in the update folder) and replacing the concrete folder manually method.

When I run it via the dashboard and fails, I have to remove the update.php file from application/config to get the site back up. I assume the update.php file is generated from the script running at the beginning of the update process?
gavthompson replied on at Permalink Reply
gavthompson
I have found an old copy of our site that I upgrade for testing when V8.1 came out. I think I upgraded to 8.1 from 5.7.5.11.
I guess I could recreate all the live changes on the local copy and upload, more work but at least I'll be past version 5.7.5.13
.
I want version 8.1 on our site as I'm ready to show users the site and don't want to show them redactor when it's gone in version 8.

I wonder if maybe something in 5.7.5.13 is causing this.

I'm not to only one by the looks of it....
https://www.concrete5.org/developers/bugs/8-1-0/upgrade-from-5.7.5.1...