Moving to new web host

colesg

Joined: 2007-02-07
Posts: 24

Posted: Sat, 2007-09-08 04:42

I'm moving to a new web hosting company and want to move my Gallery 2 over. It has around 10,600 images. I'm thinking the way to do it is export the tables in the g2 database and import them on the new host, then move the albums and images over. Is there an easier way?

Greg

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Sat, 2007-09-08 10:51

please see:
FAQ: How can I move my gallery installation from one server to another?

yes, you need to export / copy the database and copy the g2data folder.

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

colesg

Joined: 2007-02-07
Posts: 24

Posted: Wed, 2007-09-12 06:20

Received the following running the upgrade to 2.2.3:

Error (ERROR_STORAGE_FAILURE) : Error trying to run query: ALTER TABLE g2_CacheMap DROP INDEX g2_CacheMap_81545, DROP INDEX g2_CacheMap_24286, DROP INDEX g2_CacheMap_69068, ADD COLUMN g_isEmpty int(1), ADD INDEX g2_CacheMap_21979(g_userId, g_timestamp, g_isEmpty)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1723 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1344 (gallerystorageextras::_executesql)
in modules/core/classes/GalleryStorage.class at line 740 (gallerystorageextras::configurestore)
in modules/core/CoreModuleExtras.inc at line 2097 (mysqlstorage::configurestore)
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)

Is this error due to the large size of this table? Is it something I can truncate, then run the upgrade again.

Greg Coles

colesg

Joined: 2007-02-07
Posts: 24

Posted: Wed, 2007-09-12 17:28

You must get tired of people asking for help before researching the documentation and FAQ's.

I am going to do some things I found in the documentation and if it is not successful, I will be back.

Greg

Greg Coles

colesg

Joined: 2007-02-07
Posts: 24

Posted: Wed, 2007-09-12 18:10

When I try to extract gallery2.tar.gz, I get the message that the extraction failed.

When I extract the zip file on PC and then ftp all the files up to the server and run the upgrade, I get a message that four files are missing and 232 file have been modified. When I search the extracted files on my PC, the four missing files are nowhere to be found. One of the missing files is style.css. The only thing I can find in the documentation and the FAQ about this is that I'm supposed to ensure that no files are missing or have been modified.

Greg

Greg Coles

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Wed, 2007-09-12 22:10

> Is this error due to the large size of this table? Is it something I can truncate, then run the upgrade again.

the exact reason / error is logged in the upgrade log file, which is located in your g2data/ folder.

> When I try to extract gallery2.tar.gz, I get the message that the extraction failed.

with the preinstaller? please see: documentation -> installation -> preinstaller -> upgrading.
i guess your gallery2 folder isn't writeable. there are workarounds described.

alternatively, just extract the gallery2.tar.gz on your own computer and upload the hundreds/thousands of files via FTP.

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

colesg

Joined: 2007-02-07
Posts: 24

Posted: Fri, 2007-09-14 21:12

I've been told the below messages mean the php available to me will not support the upgrade.

Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/modules/core/classes/GallerySession.class on line 1206

Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122

Greg Coles

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Sat, 2007-09-15 12:19

@colesg:
please see:
FAQ: I get "Notice: Only variable references should be returned by reference in ", what's wrong?

> I've been told the below messages mean the php available to me will not support the upgrade.

it means that the upgrade _might_ work, but you would be well adviced to ask your webhost to fix their php setup, it's buggy.

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

colesg

Joined: 2007-02-07
Posts: 24

Posted: Wed, 2007-09-19 17:59

FYI... migration complete. I had someone download the old version of Gallery on the old host to his personal server, run the upgrade, then export the tables for me to import into the database on the new server. After a few changes to the config file, everything worked. Well, almost everything. The comments on the pics were gone. Just needed to turn on the comment module, though.

One reason for all the problems experienced is because I could never get logged into my control panel on the old host to do some of the tasks. Logon would work about 1 out of 10 times. Their tech support was terrible, insisting they had no problem logging in under my account.

Greg

Greg Coles

colesg

Joined: 2007-02-07
Posts: 24

Posted: Sun, 2007-09-23 21:51

Amazing! I can't believe how fast Gallery is now that we're with a different hosting company.

Greg Coles

colesg Joined: 2007-02-07 Posts: 24	Posted: Sat, 2007-09-08 04:42
	I'm moving to a new web hosting company and want to move my Gallery 2 over. It has around 10,600 images. I'm thinking the way to do it is export the tables in the g2 database and import them on the new host, then move the albums and images over. Is there an easier way? Greg
	XUser login Username: * Password: * Create new account Request new password
valiant Joined: 2003-01-04 Posts: 32509	Posted: Sat, 2007-09-08 10:51
	please see: FAQ: How can I move my gallery installation from one server to another? yes, you need to export / copy the database and copy the g2data folder. -------------- Documentation: Support / Troubleshooting \| Installation, Upgrade, Configuration and Usage

colesg Joined: 2007-02-07 Posts: 24	Posted: Wed, 2007-09-12 06:20
	Received the following running the upgrade to 2.2.3: Error (ERROR_STORAGE_FAILURE) : Error trying to run query: ALTER TABLE g2_CacheMap DROP INDEX g2_CacheMap_81545, DROP INDEX g2_CacheMap_24286, DROP INDEX g2_CacheMap_69068, ADD COLUMN g_isEmpty int(1), ADD INDEX g2_CacheMap_21979(g_userId, g_timestamp, g_isEmpty) in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1723 (gallerycoreapi::error) in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1344 (gallerystorageextras::_executesql) in modules/core/classes/GalleryStorage.class at line 740 (gallerystorageextras::configurestore) in modules/core/CoreModuleExtras.inc at line 2097 (mysqlstorage::configurestore) 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) Is this error due to the large size of this table? Is it something I can truncate, then run the upgrade again. Greg Coles

colesg Joined: 2007-02-07 Posts: 24	Posted: Wed, 2007-09-12 17:28
	You must get tired of people asking for help before researching the documentation and FAQ's. I am going to do some things I found in the documentation and if it is not successful, I will be back. Greg Greg Coles

colesg Joined: 2007-02-07 Posts: 24	Posted: Wed, 2007-09-12 18:10
	When I try to extract gallery2.tar.gz, I get the message that the extraction failed. When I extract the zip file on PC and then ftp all the files up to the server and run the upgrade, I get a message that four files are missing and 232 file have been modified. When I search the extracted files on my PC, the four missing files are nowhere to be found. One of the missing files is style.css. The only thing I can find in the documentation and the FAQ about this is that I'm supposed to ensure that no files are missing or have been modified. Greg Greg Coles

valiant Joined: 2003-01-04 Posts: 32509	Posted: Wed, 2007-09-12 22:10
	> Is this error due to the large size of this table? Is it something I can truncate, then run the upgrade again. the exact reason / error is logged in the upgrade log file, which is located in your g2data/ folder. > When I try to extract gallery2.tar.gz, I get the message that the extraction failed. with the preinstaller? please see: documentation -> installation -> preinstaller -> upgrading. i guess your gallery2 folder isn't writeable. there are workarounds described. alternatively, just extract the gallery2.tar.gz on your own computer and upload the hundreds/thousands of files via FTP. -------------- Documentation: Support / Troubleshooting \| Installation, Upgrade, Configuration and Usage

colesg Joined: 2007-02-07 Posts: 24	Posted: Fri, 2007-09-14 21:12
	I've been told the below messages mean the php available to me will not support the upgrade. Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/modules/core/classes/GallerySession.class on line 1206 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Notice: Only variable references should be returned by reference in /home/colescol/public_html/gallery2/lib/adodb/adodb.inc.php on line 3122 Greg Coles

valiant Joined: 2003-01-04 Posts: 32509	Posted: Sat, 2007-09-15 12:19
	@colesg: please see: FAQ: I get "Notice: Only variable references should be returned by reference in ", what's wrong? > I've been told the below messages mean the php available to me will not support the upgrade. it means that the upgrade _might_ work, but you would be well adviced to ask your webhost to fix their php setup, it's buggy. -------------- Documentation: Support / Troubleshooting \| Installation, Upgrade, Configuration and Usage

colesg Joined: 2007-02-07 Posts: 24	Posted: Wed, 2007-09-19 17:59
	FYI... migration complete. I had someone download the old version of Gallery on the old host to his personal server, run the upgrade, then export the tables for me to import into the database on the new server. After a few changes to the config file, everything worked. Well, almost everything. The comments on the pics were gone. Just needed to turn on the comment module, though. One reason for all the problems experienced is because I could never get logged into my control panel on the old host to do some of the tasks. Logon would work about 1 out of 10 times. Their tech support was terrible, insisting they had no problem logging in under my account. Greg Greg Coles

colesg Joined: 2007-02-07 Posts: 24	Posted: Sun, 2007-09-23 21:51
	Amazing! I can't believe how fast Gallery is now that we're with a different hosting company. Greg Coles

Moving to new web host

XUser login