admin problems after integration

[nnowakow]

I originally had phpbb integrated with my photopost, but just switched to vBulletin. The programmer integrated the two successfully. However, now I find that I can only access the vBulletin admin panel. I seem to no longer be able to access the photopost admin panel if I sign in as "admin" in photopost. How do we fix this?

[Chuck S]

Your programmer may have switched integration types but did he successfully rewrite all userid's in the photos and comments table to the new userids since the vb3 import script changes your phpbb userid's

Did he successfully change the cookie settings?

Did he successfully change the usergroup settings to vb3?

Basically those are the things to be concerned with here.

Thus to fix you to get admin access.

1. If cookie settings are not in sync then in phpmyadmin view your photopost settings table enter settings 171-173 the correct cookie settings as your vb3 cookie settings. Remember the cookie prefix is location in your config file of vb and usually bb by default. Also remember in our config-inc.php file you must place your exact vb3 license number

2. Usergroup relignment. In phpmyadmin again view your usergroups table and find the Administrators group and edit it. Change the groupid to 6 from 2 so vb admin will have access. Delete any other groups except admin. Then login to Photopost and from admin resync usergroups to pull in the vb groups

The above two things should get ya synced up but you also might want to make your programmer aware of the userid thing as your photos will be belonging to other users and most people dont think about this one when they switch user integrations midstream.

[Interdit]

Originally Posted by omegatron

you also might want to make your programmer aware of the userid thing as your photos will be belonging to other users and most people dont think about this one when they switch user integrations midstream.

Hello,

Would you have a script (the attachment is gone on another thread) or part of it to rename all files in /data ? Do all files have a prefix ?

Working on a phpbb to vb3, then now matching userid's for pp.

Best regards,
thanks,
Francois

[Chuck S]

If your using pp5 you dont need to write the files.

You would need to write the userid rewrite script to update photos comments and categories tables correct.

If your asking have I dont this before yes I have.

[Interdit]

Yes it's 5.02 vb3.

Well the queries are already processing, as it's a big db, it's taking a while.
But i'm only altering 4 tables, pp_comments, pp_photos, pp_favorites and pp_notify. Why do i need to modify the categories ?

So since 5.x no need to rename the files in the data dir anymore ? so we are done with it (didn't renew my license still on 4.85 on my main site)

Thanks for your support,
Francois

[Chuck S]

you need to modify the category table parent field for useralbums? cattype a with the new userids

[Interdit]

Right thanks i forgot to alter that table.

Francois