View Full Version : Photopost Documentation -Upgrades/Migration
February 28th, 2006, 11:10 AM
Is there some documentation I'm missing somewhere?
I'm finding the documentation on Photopost is really lacking when it comes to subject of upgrades or moving databases/servers/forum integration.
I've done some complicated migrations from UBB to vB involving merging seperate existing databases into a single new database and it has been a snap compared to just getting photopost migrated or functioning halfway correctly with vb Integration.
I'm finding that there is pretty much 0 documentation when it comes to this especially when it comes to migrating databases for doing test upgrades.
I never did get an answer or solution here: http://www.photopost.com/forum/showthread.php?t=123295 and I'm almost ready to give up on Photopost altogether.
February 28th, 2006, 11:37 AM
Your post was answered that I see.
Upgrade instructions are clearly outlined in the documentation of the download. You where told you may install a test copy for development purposes.
If you have questions about ubb to vbulletin import I would suggest you post on the vbulletin support site as that is not something we would answer here.
From a Photopost support perspective I will respond with this information again as I stated that there are steps that need to be done if you switch an integration and many threads here have this info.
1. Do your forum stuff that has nothing to do with our product imports etc
2. Edit the settings table of Photopost settings 41,83,171-173 and set to the proper integration type forum mysql table prefix and cookie settings.
3. Edit your config-inc.php file of Photopost and enter in user database the proper vbulletin mysql info and the proper vbulletin license in the $vblicense variable line.
4. In your usergroups table of Photopost delete all entries except Administrators where that one you want to edit it and change the groupid from 2 to 6
You should then be able to login with your vbulletin admin and import usergroups and set the enhanced vb3 integration stuff ;) As the other thread clearly states after you do all this there is a 3rd party script I linked you need to run to realign userid's
February 28th, 2006, 11:55 AM
What I was asking in the other thread from the beginning was about migrating data between two different photopost installs. All your directions related to migrating the live board which did not allow me to do any testing at all.
I have no problems in doing the UBB to vB stuff, that has worked without a hitch. It is the Photopost migration that has caused all the headaches.
So if you look back to the other thread the question I originally asked and doesn't appear to have ever been answered is migrating Photopost data between two different installs. The old install being 4.6.6 and the new install running the latest version, not just blindly upgrading a live install.
February 28th, 2006, 12:04 PM
You need to clone your install just like any other product if your trying to do data on secondary installs another wards just like you did ubb to vb you move everything from the old site to the new site and change the urls and settings and config settings to reflect the new urls and database settings etc.
You then go about doing the upgrade and realignment.
February 28th, 2006, 12:13 PM
The Photopost Tables are in the same database with the UBB data but with a different table prefix. Do you use the vB Impex scripts to import the database data out of the old UBB database? Or is the Photopost Impex scripts purely for going from a Standalone Photopost install to a vB integrated photopost install?
The Photopost data directory file structure is different in the latest version. The old system only has a single directory under data as 500. All the files are in that one directory. I notice in the new version the file structure has changed quite a bit in the data directory. Do I just ignore all the other folders and dump all the files right into the single directory? Do I need to delete the other directories?
February 28th, 2006, 12:28 PM
I think your confused what is vb and what is photopost here at this point. We dont have an impex script nor is anything your doing with Photopost have to do with that script. If your trying to setup a test copy of Photopost if your dont want to upgrade the existing site you need to do so manually.
You must follow the documented instructions with our package for upgrading a Photopost install from 4.66 to 5.3. An Upgrade means you upgrade an existing functioning Photopost Install and the documentation outlines the steps. Yes the file structure changed with Photopost 5 series.
You need to run the upgrade on a working Photopost 4.66. Whether it is the primary one or a secondary one I leave up to you. You do not delete files or directories. Just follow the upgrade instructions to upgrade your Photopost.
Once you upgrade you can go about the switching integration stuff that has been discussed.
February 28th, 2006, 12:38 PM
I understand that the Impex script is part of vB, but given that it is the script for importing Photopost information of some sort into vB, this seems the reasonable place to ask about it in the context of the other questions in setting up photopost.
I understand now that it sounds impossible to migrate the data without performing an upgrade first, so I have to clone an entire instance of the UBB/Photopost system to do this.
February 28th, 2006, 12:46 PM
The Vbulletin Impex script has nothing to do with Photopost Information at all. This is where I think alot of the confusion lies. Your Photopost Information is in Photopost Tables. Impex is a script written by Jelsoft, Inc used for Importing Forum Data from over 80 forums into Jelsoft's vBulletin Forum Product. The script only concerns the steps necessary with importing UBB to vBulletin.
Your not going to migrate anything Photopost with Impex. The only thing you need to worry about with Photopost here is you need to upgrade your Photopst to the latest. After that you then take the documented steps I have outlined which have been noted in many threads on how to switch an integration since you have now changed to vbulletin. The whole upgrade process and switch integration steps should take you no more than 30 minutes.
February 28th, 2006, 01:38 PM
Understood. Given that there is a Photopost Impex script in vB, when/what would someone use that for? Importing a standalone Photopost install to be integrated with vB?
February 28th, 2006, 01:43 PM
Photopost Impex script in VB did not know they even had that. Yes that just imports the photopost users into vbulletin users table period.
February 28th, 2006, 06:39 PM
After several hours of grief I've gotten an upgraded version of Photopost on a shadow copy of the original UBB site. I've migrated all that into vB and have the vB integration working for the most part, styles are completely out of whack...
However when I try running the import.php for the userid's it never works.
I put the import.php script into the photopost directory and when I run the import.php in the browser I just it churning away on a blank page forever with this in the address bar: http://forums.highend.com/photopost/import.php?action=update_comments
I spins forever and never presents anything on the screen.
February 28th, 2006, 07:33 PM
You can open that file and try upping the php memory for the script if this is a large site.
I cant see your site but if your style is not right make sure in your vbulletin admin for styles if this is a custom style any paths to images are full urls not relative urls so Photopost knows where these images are.
February 28th, 2006, 09:30 PM
You can try running the import script from here now if you want to see what it is doing.
It just spins re-opening the page forever not actually displaying anything. It isn't a big site at all but I bumped the memory way up.
I really wonder about this setting being 0 though...
February 28th, 2006, 09:40 PM
what is your phpinfo link?
You can PM me admin login urls ftp info etc and when I get a moment I will look at it
March 1st, 2006, 10:59 AM
FYI...I sent the info in PM last night....let me know if you have a problem accessing it.
March 1st, 2006, 11:32 AM
script seems to have ran and your install looks fine. I noticed you did not have forumstyle turned on so I corrected that for you
March 1st, 2006, 11:48 AM
The import.php script never seemed to run for me. It certainly never displayed anything in the webpage I was running it in.
Looking at the forums now it appears UserID's are still incorrect as comments are attributed to the wrong people.
Correct Old forum
Incorrect New forum
Where is the forum style setting at so I will know about that one?
March 1st, 2006, 12:15 PM
well this is what I see
Username tulio and all the images in his gallery are tulio which tells me something ran. All galleries sorted by username appear to have the proper photos underneath them
I cant see that other site to see what you mean
style setting on off is in Admin => Forum Settings and as stated I turned it on.
March 1st, 2006, 12:22 PM
Sorry about that. I changed permissions on our live site so guests can view photos/comments now. You should be able to see the difference here now:
Correct Old forum
Incorrect New forum
March 1st, 2006, 12:24 PM
Looks fine to me every user matches in order except fallon on the new install and thats because fallon is a user you deleted and does not exist in vbulletin.
March 1st, 2006, 12:33 PM
When comparing the community.highend.com/photopost to the new forums.highend.com/photopost the images and comments are all attributed to different users than what they should be.
Doing a side by side comparison of any of the Galleries is showing this here.
For example the user "HES Community Admin" has become the user "ChrisF"
It is like this throughout the site.
March 1st, 2006, 01:05 PM
Then this is attributed to you doing something extra that the steps we meantioned above about switching
You would have had to run an update usernames on photos and comments from the admin after your vb3 alignment instead of the first thing you do is run the import script meantioned. So basically what happened is you did the opposite of what was needed. Instead of changing userid's you changed usernames
I think I reversed this for you now.
March 1st, 2006, 01:14 PM
Yes, looks much better now.
So I run the import.php script, then after that run the Scan Database to rebuild? Is that correct? How did you make the correction in case I end up there again?
Also what did you change to get the import.php script to run as it was not behaving for me at all. I'll have to do all this again for real on Monday so trying to make sure it will all work.
March 1st, 2006, 01:22 PM
No you have no need to run a scan database for usernames
March 1st, 2006, 01:24 PM
How did you get the import.php script to run properly though?
This database will all get blasted away and we'll import the live one on Monday so I need to sort out the proper procedure here.
March 1st, 2006, 01:32 PM
Well remember I never ran import.php cause everything looked fine
Turns out you ran a scan database when the importer had not been ran so there was nothing for the importer to do
I had to write a special script to reverse what happened from you running the scan database thing.
March 1st, 2006, 01:48 PM
Okay...I'll stay away from the scan database button on Monday then. Might keep that script handy in case I manage to end up in the same state.
March 2nd, 2006, 06:14 PM
I blasted away my vB Test board and started with fresh imports of the UBB.Threads Data. To make life easy I kept the same Photopost install but pointed the config files to the new MySQL database name for vB. Nothing changed with the Photopost database or directories at all.
I tried running the import.php but it still won't run. What I'm seeing is that none of the User names show up at all in Photopost.
March 2nd, 2006, 06:23 PM
If you changed nothing in Photopost you dont need to run the import.php all the users photos userids where already correct
March 2nd, 2006, 06:25 PM
I'm a bit concerned that the import.php never seems to run for me and I keep ending up in a state of broken comments.
Any ideas what I would need to do to correct this?
March 2nd, 2006, 08:00 PM
It all depends what your doing. I mean last time I found you had ran a scan database to update names instead of the userids so I had to change things.
What I am saying at this point if nothing has changed in Photopost and all you are doing is a fresh import into vbulletin you should not have to do anything to Photopost at all.
March 2nd, 2006, 08:02 PM
If you think you have an issue I would need to look at it.
March 6th, 2006, 11:38 PM
I'm in the middle of our live rollover from UBB to vB Photopost and have hit the same issues again. I've gone through the exact sequence for doing the migration step by step and ran into the same issues.
1. The import.php script doesn't run.
2. When looking at Member Galleries it doesn't display anything in the User column at all.
3. When viewing the comments on a photo, they are all attibuted to the wrong person as before.
Can you please take a look at it so we can get it sorted. This is the live rollover now so once it works I'll burn the admin passwords to Photopost so no one ever touches it again ;)
The URL is http://forums.highend.com/photopost All the account info I PM'd you with last week should still be valid.
The forum db is vb_forums Photopost db is vb_photopost
March 7th, 2006, 08:49 AM
You'll have to resend info as I don't have anything anymore.
March 7th, 2006, 10:53 AM
I have PM'd all the login info.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.