Intergrating Question

Charly · October 21st, 2010, 10:32 PM

I have had a stand Alone Photopost and now we installed VB,How can we intergrate them so you only need one Log in so when oyu sign up for one it signs you up for both and how do we get the ones already Gallery members forum mebers?
I am sorry of this has been asked i am new ot this site and oculdnt find it.I found similar ones but not this exact one.
Thanks Charly

Chuck S · October 22nd, 2010, 09:09 AM

1. Install vbulletin

2. Use the vb import script to import your photopost users

3. Clear your pp_usergroups table

4. Rerun the install script into the same database tables and select vb integration

5. Run the userfix script in the photopost pro imports scripts forum to realign your userid's to the new vb userid

Your done.

Charly · October 22nd, 2010, 10:02 AM

Thank you will try that...
Hugz Charly

Chuck S · October 22nd, 2010, 10:48 AM

No problem enjoy your weekend and let us know if you need anything else.

Charly · November 4th, 2010, 09:40 PM

I ran the impex script and imported the users from photopost into vbulletin, emptied the pp_usergroup table, reinstalled photopost using vb integration using the same database and ran the userfix script.

Most looks ok.. but there are a couple of things. When a user that was imported from PP as an admin signs into the vb admin, there are only limited options available. I have changed them to "Administrators" as their primary usergroup in vb, but still, only limited permissions. The users that were already admins in vb prior to the import are still able to see all the options.

Second.. we have found one user in the gallery that the photos, comments, albums were not 'fixed' and reassigned to the correct user.

Can you please help me with these issues?

Charly · November 4th, 2010, 09:42 PM

the headings in vb that the imported admins are able to see are annoucements, moderation and statistics/logs. Even after my changing them to the vb administrators usergroup. The rest of the headings/options are not showing up.

Charly · November 4th, 2010, 10:56 PM

Disregard the permissions issues. I resolved that with the administrator permissions settings in vb.

Now the issue is just the 1 user that I need to fix her posts/comments and albums. If you can help me please

Chuck S · November 5th, 2010, 08:05 AM

I dont know how I can help with one user.

Maybe you can issue queries against the database if you know the proper information for him.

Like example if his old userid is 12 and the new one is 23 those queries would do it

UPDATE pp_photos SET userid=23 WHERE userid=12;
UPDATE pp_comments SET userid=23 WHERE userid=12;

The problem here is if you ran the userfix script which should query your vb database based on the guys name to get his userid I would be more concerned why his userid is not found meaning is this guy really in vb?

Thats more likely your issue. Remember we cant directly support changing integrations because of all the mess. I can provide tools and tips which we have but its not foolproof here.

I would really suspect that this guy does not exist in vb therefore there is nothing you can do other than have him register in vb then do the userfix script or rather you register him.

Charly · November 5th, 2010, 08:20 AM

Thank you Chuck. A couple of questions.. does it matter where the userfix is uploaded? I looked for this in the forums however I did not find mention of it. When I ran it, I uploaded it to the gallery directory and then ran it. Would it make a difference if I uploaded it the vb directory that you know of?

The users that are tangled are both admins. The original poster of the photos/comments/albums was an imported admin from pp and the admin now showing as the owner of those posts/comments/albums was originally an admin of vb prior to the import. Not sure if that sheds any more light onto the situation. I'm wondering if maybe they were both the same userid in the different original databases (pp & vb). Perhaps that is why they are tangled now.

VB does have a merge user option in the admin... I know you don't provide support for vb, but I am wondering if you know if this will take care of the ownership of the photos/comments/albums? I don't have a problem with creating a new admin user account for the 'incorrect owner' and merging that user into the original posters id if that makes sense. Just wondering if you have any insight on whether that will solve the ownership issue. In my head, I am thinking it should....

Charly · November 5th, 2010, 08:31 AM

if I do this option.. the incorrect owner userid is 3 and the original/correct owner userid is 6.. so I would go with..

UPDATE pp_photos SET userid=6 WHERE userid=3;
UPDATE pp_comments SET userid=6 WHERE userid=3;

correct?

Also, can I then also do a ...

UPDATE pp_albums SET userid=6 WHERE userid=3;

To fix the albums? Would that be the correct code/query?

Thank you again for all of your help!

Chuck S · November 5th, 2010, 09:14 AM

Again as I have said I would not suggest doing anything until you investigate why you have the issue. Like I said if the user your talking about does not exist in your new forum then all your doing is going to be orphaning your images and messing things up worse then they already are.

The script I wrote is foolproof so if something did not change then that username does not exist in your new forum. Thats why nothing was changed for that one user.

The userfix script issues a query that basically grabs the userid from your new forum based on what the username is. If there is no result then nothing is changed in photopost. if there is a result then the userid is updated.

I hope you follow what I am saying now.

If you insist on going further manually without investigating why the user is not found fine but I will not post on this issue further if anything goes wrong for you so be warned.

UPDATE pp_categories SET parent=6 WHERE cattype='a' AND parent=3;

Charly · November 5th, 2010, 09:45 AM

maybe I am not understanding what you are saying about if the user does not exist. I have verified the user does exist in the vb admin. Also in both the vb_user database and the pp_user database the username is userid 6. But as I look at the pp_user database, I see that the 'real name', 'email', etc for userid 6 are showing for userid 3 instead and the 'real name', 'email' etc showing for userid 6 belong to someone else. In the vb_user database userid 6 has the correct email, etc associated with it.

The username does show in both databases though.. but some things are messed up in the pp_user database.

I certainly do not want to mess it up more.. just trying to figure out what my next step is.

Chuck S · November 5th, 2010, 10:26 AM

well you can run the queries all I am saying is there has to be a reason that one user was not updated. Most likely his username is not exactly the same as it is in vbulletin which would cause no result to be found. I have that clarifies what I have been saying here all along.