Problem with User ID after 4Images import

odsnet · May 15th, 2008, 03:55 AM

Hi...

I just did the import of my 4Images gallery to photopost.
The problem now is, that the User IDs are a complete mess.

Reason:
We had vBulletin and the 4Images gallery as two seperate Homepages with sepereate registrations. Of our 8000 Users in the vbulletin only 400 wanted to use the 4Images gallery and registered there with their vbulletin nickname.

Now I have the following situation:

vBulletin forum:
Usernickname: Vivalranger
User ID in Database: 377

4Images gallery:
Usernickname: Vivalranger
User ID in Database: 22

So after the import in Photopost, all the pictures who were uploaded from the User "Vivalranger" (ID:22) were connectet with the User which has the ID:22 in the vBulltetin forum. But that is not the correct User...

I hope, I managed to explain the problem.

What can I do about this?
- would it be possible to manually change all the 400 UserIDs in 4Images to the corresponding UserID of the vbulletin forum. Or will the DB get messed up if freely change the UserIDs? (and besides that it is a hell lot of work)
- would it be possible to modify the import script so that it compares the usernames and assigns the correct ID corresponding to a Username match?

Hoping that you can help me or at least give me some advice...
Tilo

Chuck S · May 15th, 2008, 09:41 AM

Your actually in luck!

In Most cases you would be out of luck because its not really a problem with our software or our importer. You choose not to have those two application integrated so userid's would not be correct as you have found out.

Now enough people switched integrations to vbulletin that I wrote a little tool for that here

Reassign userid's when switching integrations to VBulletin

It was essentially written to realign photo id's after people imported phpbb2 to vbulletin etc but it works really for anything. What it does is grabs the photo username and authenticates the user against vb and grabs their info and updates the userid with whats in vbulletin or really any forum you integrate with.

odsnet · May 15th, 2008, 03:21 PM

hmm... I think this script will not solve the problem here.

The thing is, that after I imported all the pictures from 4images there are no usernames shown. Only after I click on
Scan Database --> resync photo/comments usernames/update comments
does Photpost show me the Usernames of the pictures. But by then the mistakes has happened.
Guess I would need to run the script on 4Images BEFORE I do the import, so that the Usernames in 4Images will get the corresponding UserID from vbulletin.

The script will porbably not work with 4Images, will it?

odsnet · May 15th, 2008, 03:22 PM

Quote:

Originally Posted by Chuck S

It was essentially written to realign photo id's after people imported phpbb2 to vbulletin etc but it works really for anything.

ok... I just found the answer

odsnet · May 15th, 2008, 03:40 PM

Code:

Content visible to verified customers only.

ok... would have been too easy to just copy the script to my 4Images directory and run it there.

Chuck S · May 15th, 2008, 04:25 PM

If works for Photopost only the script I posted.

Try redownloading the 4images importer and try doing a fresh import again clear your photopost photos table of all entries

I made a little change that might help you. The photos table of 4images if I remember right does not store a username so I added another query to grab it.

odsnet · May 15th, 2008, 05:21 PM

wonderful!!
You did it!
It worked!

... but now photopost doesn't show me any pics in my categories, although there are pic in them.
scan database --> Check here to recalculate photos/posts numbers and check children

does not seem to work anymore... any suggestions?
sorry for all the trouble

odsnet · May 15th, 2008, 05:22 PM

http://evil.outdoorseiten.net

odsnet · May 15th, 2008, 05:23 PM

oh... fixed it.
Had to save the categories again.
Everything Perfect!!!

Thanks so much, chuck!!

Chuck S · May 15th, 2008, 07:44 PM

Not a problem I was just gonna say if you did a reimport do the work instructed in the import thread.

odsnet · May 22nd, 2008, 12:45 PM

damn...

now that everything worked out fine on the backup server I get the following message when trying to import form 4images on our live-server:

Code:

Content visible to verified customers only.

any ideas what went wrong there?
I CHMODed the 4images.cnf.php to 777
The databasename, username and passwort for the database are correct....
Am I missing something obvious??

somehow it does not get access to the database, right? But to which database? the 4images or the photopost database?

Chuck S · May 22nd, 2008, 01:20 PM

Something in your config file is not correct for the live server with errors like that being listed.

Based on your errors the information for both 4images and Photopost are wrong. See the errors line 298-299

Thats this

Code:

Content visible to verified customers only.

That means both are wrong

odsnet · May 23rd, 2008, 02:30 AM

I tried several times to type in the login information again... and then it worked.
At least I looked like it.

Importing the Users, categories and picture names seems to work.
Comments do not work and once it gets to importing the picture files I get the following message:

Code:

Content visible to verified customers only.

here is line 574.

Code:

Content visible to verified customers only.

When I the look into the admin CP of Photopost, I see no new categories... nothing.

Any ideas??

odsnet · May 23rd, 2008, 02:35 AM

I had a mistake in the table prefixes.
Problem solved.

Sorry for the bother...

Chuck S · May 23rd, 2008, 09:20 AM

Not a problem you have a good weekend.