[SOLVED] upgrade error from G2 0.8 to 0.9.10

Hi,
I had G2 0.8 installed and was working great. This morning when I try to visit my album, I'm automatically taken to update page and on step 3, I'm receiving this error. debug info that I think is causing problem is below

Any help is greatly appreciated.
Regards
-R'twick

An error ocurred while upgrading Gallery Core Module
Something went wrong when we tried to upgrade the core module. In the boxes below you can find some debug information. Report this in the Gallery Forums and we'll help you diagnose the problem. 

Stack Trace: 
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1190 (gallerystatus::error) 
in modules/core/classes/GalleryStorage.class at line 241 (mysqldatabasestorage::execute) 
in modules/core/CoreModuleExtras.inc at line 309 (gallerystorage::execute) 
in modules/core/module.inc at line 515 (coremoduleextras::upgrade) 
in modules/core/classes/GalleryModule.class at line 137 (coremodule::upgrade) 
in upgrade/steps/UpgradeCoreModuleStep.class at line 72 (coremodule::installorupgrade) 
in upgrade/index.php at line 152 (upgradecoremodulestep::processrequest) 

here's last part of debug info

mysql error: [1051: Unknown table 'g2_ItemPropertiesMap'] in EXECUTE("DROP
TABLE g2_ItemPropertiesMap")

--------------------------------------------------------------------------------
(mysql): DROP TABLE g2_ItemPropertiesMap   
--------------------------------------------------------------------------------
1051: Unknown table 'g2_ItemPropertiesMap'
                  adodb_mysql._execute(DROP TABLE
g2_ItemPropertiesMap, false) % line 
833, file: adodb.inc.php
               adodb_mysql.execute(DROP TABLE g2_ItemPropertiesMap,
Array[0]) % line 1184, file: DatabaseStorage.class
            mysqldatabasestorage.execute(DROP TABLE
[GalleryItemPropertiesMap], Array[0]) %
line  241, file: GalleryStorage.class
         gallerystorage.execute(DROP TABLE
[GalleryItemPropertiesMap]) % line 
309, file: CoreModuleExtras.inc
      coremoduleextras.upgrade(Object:coremodule, null,
Object:statustemplate) % line  515,
file: module.inc

realpath(/home/httpd/vhosts/utkalika.net/subdomains/album/httpdocs/modules/core/classes/../../../)
      

----

Gallery URL (optional):http://album.utkalika.net
Gallery version: 0.8
Webserver (with version): Apache 2.0.46
Datatabase (with version): mysql 3.23.58
PHP version (eg 4.2.1): 4.3.11
phpinfo URL (optional):
Graphics Toolkit(s): netpbm/ImageMagik/gd
Operating system:CentOS 3.4
Web browser/version: All
G1 version (for migration bugs):

Sorry Valian,
but I have no idea how to disable the upgrade. when I try to visit the page, it automatically takes me to the upgrade page. Any way to disable it?

Also, I'm sorry I didn't do some reaserch on it before, but after posting did a search and found the solution to create the table. When I did that,
got errors saying duplicate key in g2_MimeTypeMap. Deleted all records from it and now got a new error

mysql error: [1146: Table 'utkalika_gallery2.g2_PermissionMap' doesn't
exist] in EXECUTE("
            SELECT
              COUNT(DISTINCT g2_PermissionMap.g_itemId)
            FROM
              g2_PermissionMap
             LIMIT 1")

--------------------------------------------------------------------------------
(mysql): 
            SELECT
              COUNT(DISTINCT g2_PermissionMap.g_itemId)
            FROM
              g2_PermissionMap
             LIMIT 1   
--------------------------------------------------------------------------------
1146: Table 'utkalika_gallery2.g2_PermissionMap' doesn't exist
                     
  adodb_mysql._execute(
            SELECT
              COUNT(DISTINCT g2_PermissionMa..., false) % line  833, file: adodb.inc.php
                     adodb_mysql.execute(
            SELECT
              COUNT(DISTINCT g2_PermissionMa..., Array[0]) % line  452, file: adodb-mysql.inc.php
                  adodb_mysql.selectlimit(
            SELECT
              COUNT(DISTINCT g2_PermissionMa..., 1, -1,
Array[0]) % line 1152, file: DatabaseStorage.class
               mysqldatabasestorage.search(
            SELECT
              COUNT(DISTINCT [GalleryPermiss..., Array[0],
Array[1]) % line  220, file: GalleryStorage.class
            gallerystorage.search(
            SELECT
              COUNT(DISTINCT [GalleryPermiss..., Array[0],
Array[1]) % line  206, file: Gallery.class

realpath(/home/httpd/vhosts/utkalika.net/subdomains/album/httpdocs/modules/core/classes/../../../)

any more pointers?

another question: is it possible to create a new installation and import data from my existing album (all pictures and user details) ?

thanks for your help
-R'twick

thanks I'll do that and try to migrate manually (mostly if I can move user info) I'll be fine. just don't want to tell all users to register again. Hopefully that will not be much difficlt.

i just installed the latest snapshot (04-29) but couldn't find the forgot password link anywhere. Is this something I have to install separately?

rtwickn, there's a notice in the readme. when upgrading, flush your PHPA cache, the memory and the filesystem cache.

0.8.11 > 0.8.4. so yes, it should be safe.

but as akways when upgrading: it's a good idea to backup your complete g2 (g2data, gallery2 , database) before you start the upgrade.

trungdong, a few questions:
- so you upgraded from 0.8.11 to what? g2 beta 2 or a more recent nightly snapshot?
- did you hit refresh/back in the browser or did this happen on the first try?
- could you fill out the support template (g2 version, webserver, mysql, php, ..)?

thanks

I have installed the latest cvs code as well as the nightly snapshot (for 04/29) but I can't see the password recover feature. Is there any place I have to enable it?

EDIT: never mind. It was the cache in my browser. As soon as I changed browser got the link.
thanks

trungdong, does this problem happen when you upgrade again from your backup? When you restore to your backup, make sure that the g2_AccessSubscriberMap table is gone (or at least empty).