[SOLVED] Failed upgrade to beta

I'm trying to upgrade from Gallery 2 Alpha to the Beta. I used the inbuilt windows zip tool NOT winzip and overwrote all the files as specified in the readme. g2data dir is inside the gallery2 dir. On the upgrade to the core module I get the following error:

Old core version 0.8.12

Fatal error: Call to a member function isError() on a non-object in C:\WebServ\wwwroot\htdocs\gallery2\modules\core\module.inc on line 513

I can get through the install routine by refreshing but end up with the error below when trying to view the gallery:

 Error (ERROR_BAD_PARAMETER, ERROR_UNKNOWN) :

    * in C:\WebServ\wwwroot\htdocs\gallery2\modules\core\classes\helpers\GalleryEntityHelper_simple.class at line 50 (GalleryUser::error)
    * in C:\WebServ\wwwroot\htdocs\gallery2\modules\core\classes\GalleryCoreApi.class at line 2042 (GalleryUser::loadEntitiesById)
    * in C:\WebServ\wwwroot\htdocs\gallery2\modules\core\classes\GalleryEntity.class at line 394 (GalleryUser::loadEntitiesById)
    * in C:\WebServ\wwwroot\htdocs\gallery2\modules\core\classes\helpers\GalleryEntityHelper_simple.class at line 98 (GalleryUser::onLoad)
    * in C:\WebServ\wwwroot\htdocs\gallery2\modules\core\classes\GalleryCoreApi.class at line 2042 (GalleryEntityHelper_simple::loadEntitiesById)
    * in C:\WebServ\wwwroot\htdocs\gallery2\init.php at line 167 (GalleryCoreApi::loadEntitiesById)
    * in C:\WebServ\wwwroot\htdocs\gallery2\main.php at line 132
    * in C:\WebServ\wwwroot\htdocs\gallery2\main.php at line 46
    * in C:\WebServ\wwwroot\htdocs\gallery2\main.php at line 39

----

Gallery URL (optional): www.jaynne.co.uk/gallery2
Gallery version: Alpha snapshot 2005-01-28-09-35-28
Webserver (with version): Apache 2
Datatabase (with version): MySQL
PHP version (eg 4.2.1): 5.0.3
phpinfo URL (optional):
Graphics Toolkit(s): ImageMagik
Operating system: Windows XP SP2

I'll just put my Alpha 1 install back on and try the latest nightly, will let you know how I get on

Sorry that was a typo, its Alpha snapshot 2005-01-28-09-35-28 which is Alpha 4. Sorry for the confusion

how clean was your install?
- g2data empty before install?
- db empty before install?
- no missing files, everything green in install step "system check"?

if not, make sure it is now and reinstall.

so, you keep reposting that error but nothing has changed since the first reply to this topic:

what steps are you following? i suggest:
1) restore backup (data and code->alpha-4)
2) ensure everything is working with alpha-4
3) get current nightly snapshot
4) remove all code (keep config.php and g2data) and extract snapshot
5) access site to invoke upgrader

if you still get an error after following these steps you can do step 1,2 again and then PM me ssh/ftp access to your server if you'd like me to debug.

i'll take a look once you have restored a functioning alpha-4

Hello,

First of all I would like to thank you for the great job you are doing. I installed your Gallery2 Alpha3 release few months ago and was happy with that since.

Now I decided to upgrade it to Beta1 but I have a little problem with it.

During the upgrade all 5 steps go well, but when I try to browse to my gallery after the upgrade I get following database error:

-------------------------------------------------------
Error (ERROR_STORAGE_FAILURE) :

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 413 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 113 (mysqldatabasestorage::loadentities)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 82 (gallerystorage::loadentities)
* in modules/core/classes/GalleryCoreApi.class at line 2042 (galleryentityhelper_simple::loadentitiesbyid)
* in modules/core/classes/GalleryView.class at line 328 (gallerycoreapi::loadentitiesbyid)
* in modules/core/ShowItem.inc at line 44 (showitemview::_getitem)
* in modules/core/classes/GalleryView.class at line 210 (showitemview::getthemename)
* in main.php at line 286 (showitemview::doloadtemplate)
* in main.php at line 46
* in main.php at line 39
-------------------------------------------------------

Sorry for my english and thanks for help in advance!

I have a similar problem with the .8 to .9 core upgrade.
I am making a clean, new linux install. The first part of the install goes ok but the upgrade section fails step 2.
g2data is under gallery2 directory.
Permission on the g2data directory is 777 but subdirectories (albums etc.) are all created 755 by the installer.

Any tips?

This is the stack trace:
Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1162 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 241 (mysqldatabasestorage::execute)
* in modules/core/CoreModuleExtras.inc at line 330 (gallerystorage::execute)
* in modules/core/module.inc at line 512 (coremoduleextras::upgrade)
* in modules/core/classes/GalleryModule.class at line 137 (coremodule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 68 (coremodule::installorupgrade)
* in upgrade/index.php at line 155 (upgradecoremodulestep::loadtemplatedata)

mindless, thank you for your reply. I did as you sugessted and started folowing new topic:

http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=27347

Sorry I did not copy-paste more details about the db error, but there are simply NO instructions on the error page to follow.

ok, php 5.0.3 is in place and i'm able to access phpmyadmin (though it seems partially broken.. can't execute sql).
your g2_Entity table has zeroes for g_linkId in every row instead of NULL. but when it loads from the db it still comes up with NULL... for some reason after the upgrade it does return the zeroes when loading from the db which causes the errors you saw.
I updated your table to NULLs (had to execute sql via php due to phpmyadmin problem mentioned above).. install the new code and perform the upgrade now (either beta-1 or current nightly snapshot) and I think you should be ok.
If it does come up ok also try adding a new item and make sure you can then view that item (maybe the null/zero problem will still exist..)

I think I've found why this whole thing has ocurred in the first place. I've been using MyTool to backup the database in Windows, I noticed that after I backed up the database changes you made and then restored them with MyTool that the null values had changed to 0 again causing the original problem.

What PHP code did you execute to change the columns back? Something along the lines of UPDATE 'g2_entity' SET 'g_linkId' = 'NULL' should be in order but I'm not sure how to get that to execute since phpmyadmin won't work correctly as you noticed