I have seen the other solutions for this (cut entity and paste) and was able to use it on other entities however I don't know where the userprofile entity is and have no idea how it got changed.
Database Upgrade Error | Column 'OSUSR_M66_USERPROFILE.ID' exists in database as Integer (int) but the new version is defined as Integer (Autonumber). Database int columns can not be changed to Autonumber.
I ended up just closing the module and reopening which brought up the latest version. I lost my changes but they were minor. Leaving this in case anyone else runs into a similar issue.
Hi Paula,
You can Right click the Database element and select "Add Dependency":
Then you can search for "USERPROFILE" and see from which module this entity is:
Once you find the entity, you can delete the data on it and the database upgrade will work. Since there won't be data there to break the attribute conversion process.
I hope this helps you :)
Best regards,
Miguel.