Help: User seeing wrong photos in "My Photos"

pharry · July 16th, 2009, 06:19 AM

This week we moved from phpBB 2.0 to vBulletin 3.8. In addition, we modified both to use a common template for the same look and feel in both places (forum & gallery).

Today I've received a report from a user that when she clicks on "My Photos", she gets someone else's photos.

Here's info from the person who did the conversion for us:

Photopost was converted from the phpbb registration system to vbulletin registration system following the instructions posted here: https://www.photopost.com/forum/1222477-post2.html

...this error might be related to the userfix script that needs to be run after the changeover to the vbulletin registration system. In the userfix script there are three things that need to be clicked..Photos, Comments and Albums

This script will realign your userid's after you import your forum you had priorly integrated with to your new vbulletin userid's
Photos Fix Photo Userid's
Comments Fix Comment Userid's
Albums Fix Album Owners Userid's

...the albums ran successfully, but the first two gave me the following error:

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

Can anyone tell us what to do to fix the error, and I assume complete the last two required steps on the userix?

Can I leave my gallery up while this is being resolved, or do I need to lock it down?

Chuck S · July 16th, 2009, 11:26 AM

You would have to post a link to the site but I would think something is not configured correctly if you get an error trying to realign things.

pharry · July 16th, 2009, 11:34 AM

Thanks, Chuck. Here's the link: Main Index - A Peek into Yesterday Gallery

mimihp is the one who reported the problem with her photos.

Chuck S · July 16th, 2009, 11:53 AM

You can add this to the top of userfix.php to see the true error as long as in debug options you have display errors selected in global options in admin

anywhere you see this in userfix.php

Code:

Content visible to verified customers only.

below it add this

Code:

Content visible to verified customers only.

christon26 · July 16th, 2009, 04:22 PM

Quote:

Originally Posted by Chuck S

You can add this to the top of userfix.php to see the true error as long as in debug options you have display errors selected in global options in admin

anywhere you see this in userfix.php

Code:

Content visible to verified customers only.

below it add this

Code:

Content visible to verified customers only.

Hi Chuck

I'm the person who installed vbulletin and did the re-integration for Photopost for Pat...I just need to double check....should that be authenticate(); with a t?

Lissa

Chuck S · July 16th, 2009, 05:38 PM

Yes authenticate should give you the correct mysql error if you run this as admin

christon26 · July 16th, 2009, 05:48 PM

I have been running this from the browser as that is what I thought I was supposed to do, and I couldn't find any instructions otherwise lol....I added that line in all the places specified and now just get a blank screen after clicking Proceed to upgrade

The debug options are set to display...can you let me know if I have been running it correctly or if there's a different way I'm supposed to run it?

Chuck S · July 16th, 2009, 05:51 PM

In userfix.php we require pp-inc.php and then you place this line and this should authenticate the user so we see what the issue is

Code:

Content visible to verified customers only.

If users photos belong to someone else then this script is not running

christon26 · July 16th, 2009, 06:05 PM

Ok...so my bad...I pasted the wrong one without the t LOL so I just fixed it and this is what I get:

Code:

Content visible to verified customers only.

Just to clarify...I looked at mimi's gallery after Pat brought this to my attention last night and most of the photos in her gallery do appear to belong to her, it's just that there are some photos in there that don't...it's not that all the photos aren't hers, just some, if that makes any difference.

This error in particular, looks like the username has an unescaped ' that's throwing the script off?

Lissa

Chuck S · July 16th, 2009, 06:43 PM

You will need to do the same for the comments portion also for the get_userinfo line but try adding something like this in bold

Code:

Content visible to verified customers only.

christon26 · July 16th, 2009, 06:56 PM

Perfect! The script ran through all the way this time, thank you

I will get Pat to have her ladies check their albums....and hopefully all is well now lol

Chuck S · July 16th, 2009, 07:23 PM

Have a good evening

pharry · July 21st, 2009, 06:55 AM

Chuck, I think we've cleared up the problem with the photos, but now that same person is reporting that she is seeing comments in her message queue. Any suggestions?

Chuck S · July 21st, 2009, 11:00 AM

Her message que?

Switching integrations is not something we necessarily support here. I wrote up that tool to help realign photos and comments id's because usernames are stored in those tables.

If your talking about private messages, photo notifications etc you might simply want to clear those tables

DELETE FROM pp_messages;
DELETE FROM pp_notify;