Impex SNAFU!

kernel-panic · April 16th, 2007, 03:11 PM

I just migrated from UBB.threads 6.5.5 to vBulletin 3.6.5 using Impex. The userid in my vb_user table doesn't match what was in w3t_Users table in UBB.threads, and it's causing trouble with my PhotoPost installation. I need to either fix the userid's in PhotoPost to match the new vB install or change the vB userid's to match the old UBBt userid's. Any idea how I could sync everything up again?

Chuck S · April 16th, 2007, 03:45 PM

Well this issue does not have anything to do with the Photopost scripts so I dont know why your putting a little mad icon on your post. If you want to be mad you can direct that frustration towards vbulletin

However I know what their import script does and I created a handy little tool to resync Photopost userid's based on their username

http://www.photopost.com/forum/showp...65&postcount=1

kernel-panic · April 16th, 2007, 03:47 PM

I'm not mad at PhotoPost, I'm mad at the situation. PhotoPost did nothing wrong here, I'm just looking for some help. I'll try the script and see what happens. Thanks!

kernel-panic · April 16th, 2007, 04:06 PM

The script ran without errors, but it seemed to do nothing. For example, my admin account had U_Number 5 in UBB. My imported account has userid 2. After running the script, my PhotoPost photos still show userid 5. Any ideas where I went wrong?

Chuck S · April 16th, 2007, 04:43 PM

If your Photopost is correctly integrated with vbulletin then the script should work. It would appear in your case you have not done that yet.

kernel-panic · April 16th, 2007, 04:47 PM

In the Config section of PP admin, my User Database information is correct, and I've entered my vB3 license number.

In the Integration section of PP admin, all 3 vb3 options are on and paths to my vB installation are correct.

In the Usergroups section of PP admin, I used the "refresh usergroups" link to update PP with my vB usergroups.

PP shows me logged in and allows me to access the admin after logging into vB.

Am I missing anything else?

Chuck S · April 16th, 2007, 05:04 PM

If you connected to the vb correctly then the script should work it is a very simple script

It loads your photo inserts grabs the userid based on the user's username and then updates the record

It then does the same thing for the comments table

kernel-panic · April 17th, 2007, 09:57 AM

What's the chance of you examining my installation to determine the problem?

Chuck S · April 17th, 2007, 10:29 AM

http://www.realtree.com/photopost/sh...00/ppuser/2468

http://www.realtree.com/forums/member.php?u=2468

Your site looks absolutely fine.

Outdoorlife3 is user 2468 in Photopost and also user 2468 in the forum

kernel-panic · April 17th, 2007, 10:57 AM

But, each record in the photos table still has the old userid from UBBt.

Chuck S · April 17th, 2007, 12:20 PM

I am not seeing how cause it sure is displaying the correct userid's on your gallery right.

Where is this userid wrong? Maybe your looking in an alternate backup database cant say but your program appears fine from what I see if it is not please provide links and proof otherwise

kernel-panic · April 17th, 2007, 03:27 PM

The `userid` and `username` columns in the `photos` table still have the old id and username from UBBt. For example, my user "Administrator" had an id of "5" in UBBt. In vB, this user has a new id of "2". In the PP `photos` table, all this users photos have userid=5 instead of userid=2. I know your userfix.php script was supposed to correct this, but it didn't. PP seems to be communicating properly with the vB users table, so I don't know why the script is failing.

I was informed by another vB user that the vB `user` table has a column called `importuserid` in it to track the user's id from the previous forum. Anything we can do with that?

Chuck S · April 17th, 2007, 04:44 PM

http://www.realtree.com/photopost/sh...t/500/ppuser/2

How is this wrong here I see your gallery is that not your gallery it says Administrator?

kernel-panic · April 17th, 2007, 04:45 PM

I did a SQL query to update my photos. I guess I should have used another user as my example.

Chuck S · April 17th, 2007, 05:58 PM

If you can find one sure but the user I picked out of random shows fine

There is no reason the script would not work unless you ran the Admin => Scan Database utility to updates usernames on photos which would mess your whole system up if you did not run this script first since that updates things based on username not userid

kernel-panic · April 18th, 2007, 07:55 AM

Quote:

Originally Posted by Chuck S

There is no reason the script would not work unless you ran the Admin => Scan Database utility to updates usernames on photos which would mess your whole system up if you did not run this script first since that updates things based on username not userid

Uh oh! I may have done that. I'm going to try to get my db restored and run the userfix.php before the Scan Database utility.

Chuck S · April 18th, 2007, 08:49 AM

Yep that would explain your issue

You cant use one of our admin utilities on a broken install as that makes it worse.

kernel-panic · April 19th, 2007, 11:13 AM

I got a copy of my PP database restored. Now when I run the userfix.php, I'm getting about 700 records in the photos table fixed, then the page shows me this error:

Quote:

"We're sorry, but the system experienced an unrecoverable error. Please try again later."

In the userfix.php file, I added an ORDER BY id in the SELECT query, and it throws the error after record number 886. Coincidentally, there is no record 887 - my database skips to 888. This behavior is consistent regardless of sorting - it always stops when the id column skips a number.

The comments update flawlessly.

Chuck S · April 19th, 2007, 12:00 PM

You should not need to alter it in any way

I suggest instead you make sure your logged in as admin and then set debug option in admin to display errors