Problems with migrating gallery to another server
|
systemX
Joined: 2004-11-04
Posts: 147 |
Posted: Thu, 2009-11-12 15:44
|
|
Hi. I have previously made a backup of the whole gallery2 folder, including the g2data which resides in it. I have also backed up the mysql database. The problem is, i am not able to determine what my gallery version is. I took a look at the module.inc file and it says 2.2.4 as the version, is this correct? I copied the whole gallery2 folder onto the new server, and also changed the database details in config.php, and imported the database, but i get a white blank page when i try to load gallery2. I try to do a new install by going to the /install/ folder, and it says that the "Gallery tables already exist in the database and there is a versions.dat file in the Gallery storage directory. But the version of the installed Gallery database tables does not match the version of the installed data in the Gallery storage directory." Does anyone have any idea how i can save my gallery? Thank you. |
|
Posts: 16503
Can you still upgrade G2 on the old server?
Follow this guide if you can:
FAQ: How can I move my gallery installation from one server to another?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 147
the old server does not exist anymore.
shall i count my losses and go Gallery 3 and re-upload everything? Or is there a slim chance of saving it without the old server?
Posts: 16503
I don't know what state everything is in. Open up your g2data/versions.dat file and post it's contents (it's just 2 lines)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 147
it looks like this below:
1.2.0.6
2.2.4
Posts: 147
shameless bump, hoping for nivekiam to see this
Posts: 16503
Sorry, had to dig up some info.
Do you have the database imported on the new server? Do you have phpMyAdmin installed? If so browse your G2 database and tables. The table name is PluginParameterMap, look for the pluginId named core, then look for the parameterName named _version
Here is a query you can perform, you'll probably need to replace the prefixes (g2t_ and g2c_) with what you are using.
SELECT * FROM `g2t_PluginParameterMap` WHERE `g2c_pluginId` LIKE 'core' AND `g2c_parameterName` LIKE '_version'
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 147
okay thanks for helping.
i executed the query and i suspect you want the g_parameterValue?
it is 1.3.0, looks like this below:
g_pluginType = module
g_pluginId = core
g_itemId = 0
g_parameterName = _version
g_parameterValue = 1.3.0
Posts: 16503
That's one problem. Your database thinks it's at version 2.3 and your versions.dat file thinks it's at version 2.2.4.
Did you successfully upgrade Gallery to 2.3 in the past?
If so, you should be able to change versions.dat to read
1.3.0
2.3
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 147
ok nivekiam, i suspected i messed with my DB previously before i posted here.
i have re-dumped the backup DB again, and i have a different value now.
the accurate parameterValue is 1.1.0.2, hope this is good news!
Posts: 16503
That still doesn't match what's in your versions.dat file. That's an older version of the DB.
Try changing your versions.dat to be
1.1.0.2
Delete the second line, it's not really needed or used.
Then try upgrading to the latest version of G2:
FAQ: How to upgrade Gallery2?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 147
ok, i changed the version 1.1.0.2 in versions.dat.
i am not sure if i did the upgrade correctly, but this is what i did, correct me if i am wrong.
1. downloaded the latest gallery version 2.3 to the server
2. unpacked it and overwrote all the files in gallery2 folder
3. went to the url path where gallery resides in, and it led me to the upgrade page
4. everything was ok until the upgrade process, giving me the error below entitled "An error occurred while upgrading Gallery Core Module"
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage.class at line 494 (GalleryCoreApi::error)
* in modules/core/classes/Gallery.class at line 202 (GalleryStorage::search)
* in modules/core/CoreModuleExtras.inc at line 633 (Gallery::search)
* in modules/core/module.inc at line 486 (CoreModuleExtras::upgrade)
* in modules/core/classes/GalleryModule.class at line 175 (CoreModule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 85 (GalleryModule::installOrUpgrade)
* in upgrade/index.php at line 186 (UpgradeCoreModuleStep::processRequest)
Did i do something wrong? thanks for the help.
Posts: 16503
zip and attach any install and upgrade logs in your g2data directory.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 147
hi nivekiam, sorry it took so long..
i have attached the logs, and compressed them into .zip if you dont mind, thanks again.
Posts: 147
bumping for nivekiam to spot this
Posts: 16503
Sorry it took so long, but I had to find a place in time where I had enough of it to dig into this. Looking at your logs makes me think your install history has gone like this:
2006-04-02 installed 1.1.0 (2.1) on host1
blew that install away and reinstalled?
2007-02-26 installed 1.1.0.2 (2.1.x)on host1
2007-09-20 upgraded to 2.1.2 on host1
2008-06-05 upgraded to 2.2.3 on host1
Move to new host
2009-11-26 attempted upgrade to presumably 2.3 from 2.2.3, but didn't bring over all the files (versions.dat) so Gallery doesn't know what version it's currently working on and assumes the oldest possible version to ugprade from (Alpha 3) Which first of all won't work if it was Alpha 3 and really won't work since it isn't Alpha 3.
Here's the real meat of it, try this using the backup from your old host on the new host.
Since it appears you were actually running 2.2.3 and that's what you're trying to upgrade from put the value 1.2.0.5 into versions.dat
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here