View Full Version : switching integrations from vb3 to xf
September 3rd, 2013, 09:59 PM
I was reviewing the steps to switch integrations and realized that this doesn't really import the database. Is that true?
Right now on my test-site I imported from a copy of the original vb3 database; which includes vb3 tables, PhotoPost Classifieds tables, and PhotoPost Pro tables - all in one database. In order to test Xenforo, I had the XF importer copy the vb3 data in to a separate database, which it did successfully.
What I didn't realize until this evening that if I want to continue using one database for everything, then I would need to do the entire migration within one database - because an PP-Pro integration switch may not actually import data.
If this is true, is there any harm in keeping Xenforo and it's respective plugins in one database - and then leaving PhotoPost Pro in it's current/separate database when I go live?
September 3rd, 2013, 10:06 PM
Correct the steps outlined are how to switch an integration. You can do whatever you wish with databases. You can use two databases or one as our product is outlined to do either that is why our config has two database sections.
September 5th, 2013, 09:16 PM
Let me know when your done always like seeing xenforo setups see the different styles.
September 7th, 2013, 12:00 PM
The migration on my test site was a disaster. Several of the initial issues were my own errors, but after going through all of the mysql errors I'm thinking that I need to upgrade my production site to the latest version of PhotoPost Pro first - and then copy the data over to my test site. Because I'm currently running PP-Pro v7.1 on my production site.
If that is true, what are the implications of transitioning to mysqli on PhotoPost Pro within vb3? I use mysqli on my vb3 forum, but not currently in PhotoPost.
Is it possible to upgrade my production vb3 PP-Pro site, leave in mysql, and then switch to mysqli on my XF test site using the latest data copy without issues?
I know one of my vb include blocks will need to be re-coded - but I may just disable it since the migration is about to happen.
Let me know your thoughts,
September 7th, 2013, 12:11 PM
Well you definately want to upgrade because 7.1 would never have supported Xenforo at the level we do now. ;)
You can use mysql or mysqli without issues it is all about what your server supports the queries are the same just the strings are different and thats all handled in the code.
The are no issues with Xenforo and PhotoPost if you properly upgrade. Like I have said any specific issue I would need more information on.
That should be a clean xenforo pp gallery install no hacks mods just out of the box.
September 7th, 2013, 12:15 PM
Ok, I needed to do another test-run on the vb3 forum import anyway. Starting over on the test site isn't going to be a major hardship.
September 7th, 2013, 05:12 PM
Yeah integrating with Xenforo is not really much different than installing to integrate with vbulletin so if your use to that it should not be that hard.
September 8th, 2013, 12:55 PM
I'm almost back to where I was before
Wiped out my test site and database, upgraded PP-Pro on my production site, copied over the necessary files/database, installed Xenforo and imported the vb3 data. My XF Test site is working.
I went through the PP-Pro new install process and discovered that it couldn't refer to the proper $vbpath at the last page. I ended up tricking it by restarting apache before going to the admin login. That was the only way I could stop the mysqli errors.
I deleted cookies through the interface, and closed by browser and clean all cookies from my PC - but still can't login to the PP-Pro admin.
I did remove the pp_usergroups table before the install, but should I remove the pp_users table before the install as well?
PhotoPost is working in some ways, but I think it's giving me a "guest" experience. Also, the "larger image" links display the pop-up, but never the image on showfull.php.
September 8th, 2013, 01:05 PM
You would need to post a link. You can clear the user table that would not harm anything since essentially we get user info from the forum not our users table.
1. Your cookies must be set properly in both applications you sure your not still setting your cookies to vb not xenforo? You did specify the proper xenforo globalsalt right?
2. It is essentially real hard to comment about something I do not see.
My Photo Gallery | Omegatron.net (http://www.omegatron.net/gallery)
If you can not login I would think that your cookies and global salt have to be off. Without seeing the site logging in and seeing what cookies are created etc it is real hard to say for sure.
September 8th, 2013, 07:00 PM
I think the cookie issue was in that my xf config file doesn't show a cookie value. It appears to be declared as "xf_" in the application.php file, so I went back into the PP-Pro install and entered that - along with the table prefix. I was able to access the PP-Pro Admin right away :) but the style was completely gone.
The PP-Pro install was re-defining my forum main URL with "/forums" at the end of it. This was a problem because I use a different value. So I used just a slash "/" and that helped fix the style issues.
I built the Xenforo plugin and installed it; appears to work.
The inability to view larger images appears to be linked in that I changed the default data directory years ago - but it is still "data" in my config. I wonder if this represents something I should check/fix on my production site? Regardless, I was able to view larger images on my test site again after resolving.
The only problem I'm experiencing is inconsistent issues with initially viewing a gallery of photos. If I know the URL, I can get there and see it, but most of the pictures are in a Member's Album - and I can't see it at all :confused: What could be causing this problem? I tried resetting category permissions, but no luck. I wonder if this is because I deleted the pp_users table before the install?
September 8th, 2013, 07:55 PM
Shawn without seeing your site it is hard to say as you switching an integration there are various issues one can see if something is not done correctly.
Most of the stuff your talking about in your post if you had run the install script to install into xenforo and input the correct values none of these issues would have been encountered. I take it you where trying to do things backend through just editing config files and various mysql entries if all these variables where incorrect.
You can post a url so I can see any issue but if you imported forum data to xenforo from vb did you run the userfix script noted in the switch integration to fix userid's? After you do that you can always as well go to Scan Database in admin and update the users last photo entry. That should update users last photo field and users should be able to be seen in the members gallery category.
September 8th, 2013, 08:16 PM
The userfix.php file displayed a magic quotes errors, and then something about content compression error. I ran the "update users last photo entry" option and it seemed to help. To my understanding if the Xenforo install is new and there is no data, a vb3 import won't change ids on posts/forums/users.
I did run the install, but did try editing the config files directly. Never did change the values in the mysql database.
I'll send you the URLs to the production and test sites; along with the logon to the test site - it is password-protected.
September 8th, 2013, 08:30 PM
Would not importing the vb data import data into xenforo. The issue I am referring to is that if you are importing forum data which means the users the import script will renumber users so say user 436 in vb might be user 421 in xenforo because the import script will import the users in order and compact the users so say if you had deleted vb users those are gaps in userid's and the import changes userids as the import is not going to import users and leave gaps. ;) Hense the userid would not match on the photos as we would store userid 436 for say username Guy. The userfix script simply checks the forum you now are integrated with for the userid for a username of Guy and updates photo and comment userid's accordingly.
Okay so if you ran the install then you did not enter the correct values on reinstall to integrate with xenforo then whichever way you did it. I am just saying that running the install script and entering correct things like forum url cookie prefix etc you would not have had the issues you where presented with. That is fixed though so lets figure out your image thing now. ;)
September 8th, 2013, 10:20 PM
To my understanding, when xenforo imports vb3 data it doesn't change the IDs on anything as along as there is no data to begin with. The only thing it merges is my own userid (which is number 1), so I went in an saw that my user profile did have more than one usergroup assigned to me (likely from years ago) and cleaned it up. However, it didn't make a difference when looking at some of my categories.
It seems like I know longer have permissions to view certain images ...
September 8th, 2013, 10:34 PM
well I am merely explaining how an import script works. ;) It has nothing to do with what your saying now though.
I am not sure what you mean by you do not have permission to certain images. I was able to view any image that I clicked in your site.
viewing permissions are based in usergroup permissions which you set under admin edit categories.
You would have to give more specific examples as I see nothing wrong with your test setup.
September 9th, 2013, 03:26 PM
Just checking in to see if you can send a login and url so I can see what your talking about.
September 9th, 2013, 08:09 PM
I logged into my test site a moment, and now I can see all of the pictures?! That is strange. I've been out since last night, this is my first opportunity to check back on things.
September 9th, 2013, 08:15 PM
No idea like I said I was able to see everything fine with the login you sent so guess your all good.
September 9th, 2013, 08:48 PM
I did some other upload and formatting test and they worked out as well. Good enough to mark this one as tested. I'll leave my test site up at least through next weekend, to use as a reference for migrating the production site.
September 9th, 2013, 08:51 PM
One question, should I delete just the pp_usergroups table; not the pp_users table?
September 9th, 2013, 09:11 PM
the only table I note you need to remove is the usergroups table so we can recreate and import the new groupnames for the new forum.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.