photos not matching members(NOT A BUG)

nnowakow · September 25th, 2005, 06:53 PM

I received the following message from one of our users:

this link http://www.wetdawg.com/pages/photopo...500&ppuser=149 say that the album owner is perry22b, it should say jc_vaillant, these are my pictures

look like my daughter's picture is there on a new album http://www.wetdawg.com/pages/photopo...500&ppuser=150

I'm now 150 instead of 149

--------------------------------

Referring Page: http://www.wetdawg.com/pages/photopo...user/2/cat/500
IP Address: 65.94.160.42
User Name: jc_vaillant
User ID: 150

How do I fix this?

Chuck S · September 26th, 2005, 10:44 AM

Did you switch integration types? If so you would need to realign your userids
s

nnowakow · September 26th, 2005, 04:41 PM

We switched from phpbb to VBbulletin. How do I realign the userid? I am not a programmer, so I need some step by step instructions. Thanks!

Chuck S · September 26th, 2005, 05:15 PM

this should help

Reassign userid's when switching integrations to VBulletin

nnowakow · September 27th, 2005, 06:54 PM

okay - yes, that will do the trick. I downloaded import.php. However, since I did not install photopost on my site, I am not certain what the proper database name, user name and passwords are. I have all the info on a document the programmer gave me, but they dont' seem to work...

I get this message when I try to call import.php

Unable to select VB database

Do i use the mysql dbname, user name and passwords?

Chuck S · September 27th, 2005, 08:22 PM

Open up your config-inc.php file and the information you need should be in there

nnowakow · October 1st, 2005, 12:31 AM

I found the information I need and I imputed the correct information. Now I get this error msg when I run import.php.

Error 1146: Table 'wetdawg.user' doesn't exist Query: SELECT * FROM user

What does this mean?

Chuck S · October 1st, 2005, 08:36 AM

Did you enter the right table prefix for vbulletin database?

nnowakow · October 2nd, 2005, 05:30 PM

Yes, I did...I entered

"photo_" for the photopost database prefix....

So what went wrong?

nnowakow · October 2nd, 2005, 05:33 PM

whups- actually, there does not seem to be a prefix for the vbulletin database. Its not anywhere in the file so I had left the vb prefix line blank -

$vb_prefix="";

I can't find any prefix for Vbulletin...I found the one for photopost...

nnowakow · October 3rd, 2005, 05:16 PM

Omegetron? Can you continue to help me with this? Read my last message pls. THere is not prefix for Vbulletin...

Chuck S · October 3rd, 2005, 08:25 PM

Is wetdawg the database your forums are in?

nnowakow · October 3rd, 2005, 10:45 PM

Yes it is. I just checked in "myphpadmin" and the vb3 tables are in the WetDawg database...I tried using "vb3_forum_" as the prefix - did not work, even though that is a table in the WetDawg database....

Chuck S · October 3rd, 2005, 11:27 PM

well you have to have some of the mysql stuff wrong look at this below its a simple query connect

Code:

Content visible to verified customers only.

Thats about as simple as it gets. As long as your database connection proper database and table are entered in the config you should be able to connect to that table

nnowakow · October 4th, 2005, 05:27 PM

I think I am misunderstanding you. I just don't know WHERE to look for the prefix for vb3. Where would I find the prefix. It certainly isn't in the config-inc. php file.

Chuck S · October 4th, 2005, 06:22 PM

Oh your vb3 config.php file in the vb includes directory at the bottom of the file right before cookie prefix

nnowakow · October 5th, 2005, 04:29 PM

I finally got the import file to run. It was completed. I went to my photogallery and saw that there were a lot of thumbnails missing. So I went to admin and clicked "scan database" and asked it to create thumbnails where it was missing. The result: TONS of photos were LOST! What the heck happened. Is this reversible?

nnowakow · October 5th, 2005, 04:35 PM

Omegatron - look at my gallery - you will see I have lost so many photos - compare the columns on the home page - it says I have say "8" photos and then in the last column it says "no photos". What the hell happened?

Chuck S · October 5th, 2005, 05:49 PM

If your using the right script here it doesnt do anything to photos but place the right userid onto them. It deletes no photos.

Just like any upgrade or import your suppose to make backups before running them.

Did You?

I would tend to think your no photos is because of something else you ran not this specific script. I used this very script when I switched from UbbThreads to VB as did Michael.

What other steps did you do here besides run this script. Did you try to run this script on an old version of Photopost say 4.8 then do a photopost upgrade? That would not work. This script is for 5.0 and above. So it is very important to know what you did to cause this to be able to suggest a resolution.

nnowakow · October 5th, 2005, 07:22 PM

1. I used the import.php script. I am sure it was not designed to delete photos.
2. I put "vb3_" as the prefix in import.php, uploaded it to my photopost directory and then called it in my browser
3. Program ran successfully.
4. When I checked my photogallery, I saw that there were ALOT of thumbnails missing.
5. I then went into my admin and checked "scan database"
6. In there, I checked "check for and create missing thumbnails"
7. As this process was being done, the program deleted tons of photos - it kept saying "no thumbnail, deleting photo!"
8. I did not back up the database prior to doing this
9. Is there a way to retrieve the old photos - I know my database has been backed in up in the past, is it possible to retrieve old photos from there?

Please provide me with suggestions and I will find a programmer to help me out of this mess. Or can I hire one of you guys to fix this mess for me? I will provide you with all passwords, etc.