PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)
-   -   photos not matching members(NOT A BUG) (http://www.photopost.com/forum/photopost-pro-installation-upgrades/115823-photos-not-matching-members-not-bug.html)

nnowakow September 25th, 2005 06:53 PM

photos not matching members(NOT A BUG)
 
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

http://www.photopost.com/members/for...d.php?t=115240

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.


All times are GMT -5. The time now is 05:34 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97