[SOLVED] Can't login after 2.2.6 to 2.3.1 upgrade

dazed_and_confuzed

Joined: 2008-12-16
Posts: 19
Posted: Thu, 2010-08-12 14:42

2.2.6 to 2.3.1 upgrade on Linux, Ubuntu 10.4, php 5.3.

I haven't touched my original installation - it's running on an older version of Ubuntu LTS with php 5.2 (I think).

I backed up the mysql DB, copied the g2data folder over to a 10.4 Ubuntu install with a current version of mysql and php 5.3.
Had it all up and running and working as expected and then tried the upgrade. If there is no easy fix for this I can just start over, if someone can point out where I hosed this.

On top of a fully functional 2.2.6 full version of gallery2 I downloaded the 2.3.1 full version.
un tar'd it over the /usr/share/gallery2 directory, fired up the browser and pointed it at http://www.taftbbs.com/gallery2 (This isn't public right now) and walked through the upgrade process, the whole process ran a while but I saw no errors and everything looked fine.

This seems to be the most relevant thread http://gallery.menalto.com/node/97200 but I don't have the duplicated tables this pointed to as the issue.
I can't even login with the admin ID and the password stored in the config file.

Can I just clear the hash in the g2_user table for an admin equivalent ID and will that get me in and let me clean up?

====================Solved

I just added a new record in the user table and using that ID I was able to get to the "recovery password" process using the 'login.txt' file.
Interesting.

I can login, but I'm missing a required object related to the new user:

Error Detail -
Error (ERROR_MISSING_OBJECT) : Missing object for 25

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 2054 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 98 (GalleryStorageExtras::_identifyEntities)
* in modules/core/classes/GalleryStorage.class at line 314 (GalleryStorageExtras::loadEntities)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 71 (GalleryStorage::loadEntities)
* in modules/core/classes/GalleryCoreApi.class at line 2361 (GalleryEntityHelper_simple::loadEntitiesById)
* in modules/core/AdminUsers.inc at line 198 (GalleryCoreApi::loadEntitiesById)
* in modules/core/SiteAdmin.inc at line 209 (AdminUsersView::loadTemplate)
* in modules/core/classes/GalleryView.class at line 293 (SiteAdminView::loadTemplate)
* in main.php at line 465 (GalleryView::doLoadTemplate)
* in main.php at line 104
* in main.php at line 88

I used phpmyadmin to remove the record for the temporary userid and things so far appear to be working.