Migrated from Phpbb to VB using impex - now gallery ids are diff than VB ids

[Silver_2000]

the gallery was integrated with phpbb before and is now integrated with vb

the user names are no longer matching the pictures

Is there any way ( please god ) to fix it ?

VB support says nope the import created new ids and no way to fix it

Hopefully someone here has had fixed this before

Doug

[Silver_2000]

anyone ?

Beuller ???

[Michael P]

Not an easy thing to fix, I'm afraid. You'd need to write a script to update the userids in all the PP tables that use them to change from the "old" userid to the "new" userid.

[Silver_2000]

So that then also means that there is no way to tell by the pictures themselves who they belong to ... correct ?

[Michael P]

Not unless you can translate the old userids to the new ones. ImpEx usually leaves an olduserid field in the database; you would be able to use that to help in the translation.

[Silver_2000]

[sarcasm on]

So all I have to do is do a search and replace in PP for userid and replace it with importuserid

[sacasm off]

Actually I have nothing to lose - the gallery is toast now so what the heck

I have backups ... LOL

[Silver_2000]

well that didnt work ....

Darn it

[Michael P]

It's been a while since I've done an import on vB from another forum; but I thought they created a "olduserid" field in the vb_user table. It's not simple, don't get me wrong; it's just that would fall into probably a customization job given the work that would be needed.

[Silver_2000]

I tried a few things and realized it wouldn't be a good result even if it worked and since the user id was in so many tables I ended up dumping the PP tables and reinstalling

It gave me an excuse to get rid of some questionable pictures anyway

[Chuck S]

In our import forum use the userfix script I have posted there to fix the userid's

[Silver_2000]

Originally Posted by Chuck S

In our import forum use the userfix script I have posted there to fix the userid's

This is not good news. if I had known such a thing existed I would have tried it before I dumped the database.

When Micheal posted

Not an easy thing to fix, I'm afraid. You'd need to write a script to update the userids in all the PP tables that use them to change from the "old" userid to the "new" userid.

3 days ago I figured I had no options ....

Tempted to swear but dont want to engage the censor

[Chuck S]

Michael may not be aware of all the little things I make to help users especially considering this is not really a Photopost issue at all. Your vbulletin impex script renames the users userid's and I beleive that every post on our forum here if I do a search has the exact steps needed to switch a forum integration. How did you figure out how to switch your forum integration from phpbb to vbulletin cause all those threads here note to use the userfix script to fix this issue?

[Silver_2000]

Originally Posted by Chuck S

Michael may not be aware of all the little things I make to help users especially considering this is not really a Photopost issue at all. Your vbulletin impex script renames the users userid's and I beleive that every post on our forum here if I do a search has the exact steps needed to switch a forum integration. How did you figure out how to switch your forum integration from phpbb to vbulletin cause all those threads here note to use the userfix script to fix this issue?

moving from phpbb to vb was easy - just change a few settings in the config

I have restored a 2 day old copy of the gallery files and DB to a test folder and have run your fix script - IT did seem to remap the users which is great

Could I get you to look at one issue on the gallery ?

I cant login to the gallery - the login keeps reverting back
and the categories are missing

I can PM the url and my login

Edit: it appears its the integration that is screwing up the categories and the layout ... I still cant seem to login to get to admin.php
Ill edit the settings in the sql table to turn off the visual parts of integration for now

[Silver_2000]

still cant login to the test gallery -

Little help ??

[Chuck S]

This might help you track down what is missing from your switch

http://www.photopost.com/forum/showp...89&postcount=2

[Silver_2000]

pretty sure I did all that

Ill check it again

[Chuck S]

If it is all done correctly you will be able to login and be integrated with vb

[Silver_2000]

yep double checked

Its all there ....

Still cant login

VB logs me in but I still see
Home · Search · Register · Login

on the PP bar - cant get to admin - and whenever Im loggedin the categories are screwed up - if Im not logged in the categories look right

( but there are fewer visible - as designed )

http://www.prowltalk.com/ppost_test/

[Chuck S]

You sure you cleared your usergroups as noted in that thread and realigned the vb admin groupid? You sure cookies are set correctly?

This would be where I would suggest to look since something was overlooked based on my instructions on how to switch an integration.

You can post a regular login here

[Silver_2000]

Originally Posted by Chuck S

You sure you cleared your usergroups as noted in that thread and realigned the vb admin groupid? You sure cookies are set correctly?

This would be where I would suggest to look since something was overlooked based on my instructions on how to switch an integration.

You can post a regular login here

The cookie settings are all correct they match VB
I re deleted the usergroups from the table
the administrators group was already id 6
a username and password to use
test user
tester
http://www.prowltalk.com/ppost_test/
I will warn you that there are mature pictures once you login
feel free to delete user pass when you are done
Doug