[upgrade] 2.2.1 to 2.2.2 unknown error

bert_r

Joined: 2007-07-14
Posts: 6
Posted: Sat, 2007-07-14 22:18
Quote:
Op dit moment geïnstalleerd Core Module version: 0.8 (Gallery 2.0-alpha-3)
Nieuwe versie Core Module version: 1.2.0.4 (Gallery 2.2.2)

wtf? I had 2.2.1 prior upgrading?!

Stack Trace:

Quote:
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage.class at line 480 (gallerycoreapi::error)
in modules/core/classes/Gallery.class at line 202 (mysqlstorage::search)
in modules/core/CoreModuleExtras.inc at line 581 (gallery::search)
in modules/core/module.inc at line 433 (coremoduleextras::upgrade)
in modules/core/classes/GalleryModule.class at line 160 (coremodule::upgrade)
in upgrade/steps/UpgradeCoreModuleStep.class at line 85 (coremodule::installorupgrade)
in upgrade/index.php at line 185 (upgradecoremodulestep::processrequest)

Debug: http://nije-faam.nl/gallery2/debug.txt

All system checks are ok. Any thoughts?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sat, 2007-07-14 22:56

- i hope you have a database backup
- please check your g2data/versions.dat file. it should exist and have 2 lines. what are the contents of this file?

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
bert_r

Joined: 2007-07-14
Posts: 6
Posted: Sun, 2007-07-15 08:41

- Yes i do have a database backup.
- versions.dat exists but has a size of zero bytes, ie no content.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 14:27

> - versions.dat exists but has a size of zero bytes, ie no content.

that's weird. how did you originally install g2? with fantastico or another 1-click / auto-installer?
or with the normal installation process / wizard?

FYI:
you can create your own versions.dat easily.
If you're 100% sure you had G2.2.1, then versions.dat should have the following contents (2 lines):

1.2.0.1
2.2.1

you can check your version by looking at the PluginParameterMap table of your restored database. SELECT g_parameterValue from g2_PluginParameterMap where g_parameterName = '_version' AND g_pluginId = 'core';

steps to recover your gallery:
1. drop your database
2. import your database backup
3. check your current g2 core version as explained above
4. restore your versions.dat as explained above
5. run the upgrader again

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
bert_r

Joined: 2007-07-14
Posts: 6
Posted: Sun, 2007-07-15 14:39
valiant wrote:
SELECT g_parameterValue from g2_PluginParameterMap where g_parameterName = '_version' AND g_pluginId = 'core';

gives: 1.2.0.1
Guess that makes it gallery 2.2.1, right?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 14:51

correct. please also answer the other question i had (how did you install g2.2.1).
 
bert_r

Joined: 2007-07-14
Posts: 6
Posted: Sun, 2007-07-15 15:17

I started long time ago with gallery 1.x with the normal installation process / wizard. Upgrading went succesful until now.

[coce]1.2.0.1
2.2.1[/code]

typo? [code]
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 15:19

correct, that was a typo (fixed). it should just be:
1.2.0.1
2.2.1

> I started long time ago with gallery 1.x with the normal installation process / wizard. Upgrading went succesful until now.

maybe check your database tables. does any of them have a fulltext index? e.g. the g2_AlbumItem table, does it have a "Fulltext" index?

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
bert_r

Joined: 2007-07-14
Posts: 6
Posted: Sun, 2007-07-15 15:22

Ok i added the two lines to versions.dat
without the code /code!!

Updating went fine.
Guess this one is solved. Thanks very much valiant, keep up the great work
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 15:27

Excellent.
Note: This was just that easy because you are using an older database driver. If your database connection was transactional, it would have been very, very difficult if not impossible to fix your Gallery.

-> Please backup your gallery database from time to time, and especially before upgrades.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
bert_r

Joined: 2007-07-14
Posts: 6
Posted: Sun, 2007-07-15 15:38

Backup are made every month by me and daily by the hoster.

Any clue on how versions.dat got empty?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 16:16

> Any clue on how versions.dat got empty?

No. That's why I asked how you intially installed your Gallery.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 16:38

@note about upgrades:
sorry, confused this topic with another forum topic.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage