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

[Silver_2000]

I dumped the settings table of both the test db and the real db for both vb and for pp and they are identical

still confused

going home - maybe a beer will help

[Chuck S]

Your vbulletin license number is not correctly entered in your photopost config file on the vblicense line I can say this much from my login that I tried

[Silver_2000]

Originally Posted by Chuck S

Your vbulletin license number is not correctly entered in your photopost config file on the vblicense line I can say this much from my login that I tried

$vblicense = "VBXXXXXXA";


Its there ... been there ..

[Chuck S]

You are completely logged out of vbulletin when logging into Photopost which is a license issue usually

You can send me an admin login and phpmyadmin link

[Silver_2000]

Originally Posted by Chuck S

You are completely logged out of vbulletin when logging into Photopost which is a license issue usually

You can send me an admin login and phpmyadmin link

Cookie settings have kicked my butt before - they may be doing it again - thanks for the offer of help

I cant find an email link and I get this when trying to PM

Chuck S has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

[Chuck S]

chuck@photopost.com

[Silver_2000]

Well I finally fixed it

It was one of 2 things - either the version number of PP in the PP config file or the fact that the VB config file was borrowed from another VB install and had the wrong key in the comments at the top ...

I run 2 copies of VB and must have used the other one to save some editing on this ...

Whats weird is that the NEW version of PP I installed after giving up on the old one , it pointed to the same vb config file with the wring license in the comments

Thanks for your help Chuck

As I mentioned in email
Your support link its linked off the members page is invalid
http://www.photopost.com/forum/vbugs.php

[Silver_2000]

One issue remains

the page descriptions still show the wrong ( VB ) username
"Home » Member Galleries » Usernam before the fixscript "

when I attempted rerunning the userfix.php it switched the names back to the original wrong ones...

Im restoring the DB from backup now ...

[Chuck S]

Again just recheck which databases your connecting to ensuring the correct one. The userfix script does not change usernames at all. It changes userid based on the username.

[Silver_2000]

Originally Posted by Chuck S

Again just recheck which databases your connecting to ensuring the correct one. The userfix script does not change usernames at all. It changes userid based on the username.

Yeah running scan db with one reference to the old folder structure left hidden was NOT a good idea

I reloaded the backup and the pictures are assigned correctly they have the right owner - the names of the galleries is still not correct
if you go to member galleries then click the members pictures - the right pictures come up its just the title at the top that says

Home » Member Galleries » Bcoffman Gray Ghost
Search
Images 1 to 12 of 1253 Page 1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · 11 ... 105 »

It should say Home » Member Galleries »Dreamcast - all the pics correctly belong to him. And it was D and then dreamcast that I clicked on in the members gallery list

where is that nme stored ?

[Silver_2000]

Here is a good example

I moved 10 or so pics from the "new" blank galley I had set up into this one for this user and now he has 2 galleries

http://www.prowltalk.com/ppost/showmembers.php?sl=m

[Chuck S]

You never run a scan database resync names after switching a forum integration like you did cause what your doing is changing the username based on the userid which we know is wrong since your vbulletin impex script changes userids. Userfix on the other hand realigns userid's based off the username which is correct. The only way to be sure you did things correct is to restore a true backup where userid and usernames are correct before your forum switch and then ONLY RUN USERFIX SCRIPT.

Running userfix after running a scan database is not going to do anything cause the username has already been improperly assigned.

[Silver_2000]

Originally Posted by Chuck S

The only way to be sure you did things correct is to restore a true backup where userid and usernames are correct before your forum switch and then ONLY RUN USERFIX SCRIPT.

Running userfix after running a scan database is not going to do anything cause the username has already been improperly assigned.

You want me to restore the DB to the Phpbb usernames ?

I thought the userfix was only going to work on the imported names.
Which is what it was run against.

Or do you expect me to dump BOTH VB and PP and go thru the whole impex thing again ? Then run userfix. If thats the case you just lost a 4 license customer.

[Chuck S]

You need to take the appropriate steps to counter any mistakes made when you switched your integration. We claim to integrate with various forums. I have made it easier for people by making scripts and tools and providing step by step instructions on how to do something the software is not designed to do. If you switch a forum integration obviously you need to counter any issues faced by using tools of some other company. I do not support the vb impex script nor will I. You need to restore the Photos and Comments tables that was there when you had phpbb integrated so the usernames are correct so the userfix script I wrote can do its job. This is why I have laid out in many threads how to switch an integration. You ran the scan database tool which does the opposite of what you want to do. It is updating the usernames not the userid's which is what the vb impex script changes. Your issue has nothing to do with Photopost it is all because you switched forum integrations. If you restore those two tables and run the userfix script you should be okay. The minute you ran that scan database you got yourself in this issue. That tool is in our admin when people change there usernames in forum software like you can in some so that you can update the username changes.

[Silver_2000]

Originally Posted by Chuck S

You need to take the appropriate steps to counter any mistakes made when you switched your integration. We claim to integrate with various forums. I have made it easier for people by making scripts and tools and providing step by step instructions on how to do something the software is not designed to do. If you switch a forum integration obviously you need to counter any issues faced by using tools of some other company. I do not support the vb impex script nor will I. You need to restore the Photos and Comments tables that was there when you had phpbb integrated so the usernames are correct so the userfix script I wrote can do its job. This is why I have laid out in many threads how to switch an integration. You ran the scan database tool which does the opposite of what you want to do. It is updating the usernames not the userid's which is what the vb impex script changes. Your issue has nothing to do with Photopost it is all because you switched forum integrations. If you restore those two tables and run the userfix script you should be okay. The minute you ran that scan database you got yourself in this issue. That tool is in our admin when people change there usernames in forum software like you can in some so that you can update the username changes.

The mistake I made when doing the integration was that I didnt search well enough to find your userfix script. When I ran in to a problem I tried posting a support request, but your support link on the members page, is an invalid link. So I posted a thread here looking for help. I was told by Micheal that there was no fix. At that point I abandoned the gallery that was damaged by the import and started fresh. Then 3 days later you replied to that thread pointing me to the userfix script.

In hoping to recover a years worth of images and repair countless missing image links in the forum...
When you pointed out the userfix script I restored the pictures and the DB as it was after the VB impex in to a test DB in a test folder.

I then ran the userfix script - which changed MOST of the user issues except the issue highlighted above where the title of the gallery is wrong.

forget the posts about running the scan db and rerunning the userfix script - I have restored the DB to the state it was in right after the VB impex completed and its now in the state it was in after the userfix script.

So in conclusion the images and the DB in the production gallery are in the state they would be in after the VB impex and the userfix script. The only thing that hasnt been manually restored from backup in a couple days is the pictures themselves BUT I dont think the images themselves have been altered by either the userfix script or the scan db. If need be I can restore them as well.

Im not looking for you to support impex or to get in an argument. I just want some help understanding what went wrong and how to fix it.

[Chuck S]

All I can say is what I have already stated. If the userid's in your comments and photos tables are like they where when you integrated with phpBB then when you integrat with vbulletin. You make sure your using the correct database etc and run userfix.php cause I know you have had issues pointing to the wrong install before dealing with me in this thread. The script will simply scan your vb users table and grab the right userid based on the username that is in your photopost tables and update those two tables to the proper userid that vbulletin's impex changed the user too. That is all I can suggest.

I am not going to argue with you which is why I completely sidestepped your one statement in your last post when you where getting frustrated. I am only going to reiterate in a support manner the steps needed to switch the integration and run the script.

The sure fire way as I have stated to make sure things are correct is to double check your real install not test install to ensure the vb integration is working right and it appears to be. You then restore the Photos and comments tables which is an easy task to a backup before you ran the impex. This does not mean you have to redo impex or anything hard. You then simply upload userfix.php and run that script. That should be all there is to it.

[Silver_2000]

Originally Posted by Chuck S

The sure fire way as I have stated to make sure things are correct is to double check your real install not test install to ensure the vb integration is working right and it appears to be. You then restore the Photos and comments tables which is an easy task to a backup before you ran the impex. This does not mean you have to redo impex or anything hard. You then simply upload userfix.php and run that script. That should be all there is to it.

This is exactly the kind of information I was looking for - Thank you

The impex was run during the week of before Christmas,

That means there are 2 problems - one my daily sql backups get over written after 30 days.

2 there are changes to the photos in 30 days.

Ill take a closer look in a couple hours - let my head clear