PhotoPost Community - View Single Post - Blank page when transfering photospark from one server to another

DesmondSweeney · August 23rd, 2007, 03:28 PM

Hello,

We recently upgraded our server, and are in the process of transferring the data from one server to another.

We have photopost installed at a couple URL's. Our transfer procedure was basically as follows:

1) tar.gz entire directory structure
2) mysqldump appropriate databases and zip
3) transfer directory backup + mysql backup to the new server
4) extract everything, set up virtual servers in apache, etc
5) import mysql data using mysql --user --password database < mysql.sql

2 of our photopost installations came over without issue. The third did not.

If I install photospark from scratch (Clean install), and bring over the database tables one by one, I can see the photos until I bring over the category table. At that point, photopost does not load -- it just dispalys the site header (vbulletin integration), but nothing from photopost at all.

What i've done to debug this further is took a phpmyadmin export of just the categories table, and imported it bit by bit. At first it was working, then the same result. So i cleared the categories table and started the import with the offending records ... and photospark successfully loaded! So I don't think it's just one category problem ... but maybe it is.

Does this spark any ideas with any of the developers? I don't even know where to start debugging this, but i'm willing to try.

Please post any suggestions / comments / questions.

I can provide any files upon request.

Thanks!
Desmond.

August 23rd, 2007, 03:28 PM	#1 (permalink)
DesmondSweeney Junior Member Verified Customer Join Date: Jan 2006 Posts: 19	Blank page when transfering photospark from one server to another Hello, We recently upgraded our server, and are in the process of transferring the data from one server to another. We have photopost installed at a couple URL's. Our transfer procedure was basically as follows: 1) tar.gz entire directory structure 2) mysqldump appropriate databases and zip 3) transfer directory backup + mysql backup to the new server 4) extract everything, set up virtual servers in apache, etc 5) import mysql data using mysql --user --password database < mysql.sql 2 of our photopost installations came over without issue. The third did not. If I install photospark from scratch (Clean install), and bring over the database tables one by one, I can see the photos until I bring over the category table. At that point, photopost does not load -- it just dispalys the site header (vbulletin integration), but nothing from photopost at all. What i've done to debug this further is took a phpmyadmin export of just the categories table, and imported it bit by bit. At first it was working, then the same result. So i cleared the categories table and started the import with the offending records ... and photospark successfully loaded! So I don't think it's just one category problem ... but maybe it is. Does this spark any ideas with any of the developers? I don't even know where to start debugging this, but i'm willing to try. Please post any suggestions / comments / questions. I can provide any files upon request. Thanks! Desmond.