Some photos missing problems

creativepart · June 27th, 2006, 07:15 PM

I just completed a migration from PHPBB to vB3. I ran Userfix.php and it ran well (after removing any usernames with apostrophes). I've checked random photos of dozens of users and all are fine.

I have one user reporting that his photos are missing. I checked and his userid has been properly updated, and when I look him up in the database I see all 39 of his photo's listed.

I can see the cat number in the database and when I go look on the server the photos are there.

Yet, when I go to his username in the member gallery section it returns the message: "This category does not contain any images." Yet all the other users around him bring up their images just fine.

If I look in the db and find the name of one of his photos I can search for that name and the photo is found. I can rate it and leave a comment. And it goes through fine. But when I click on his member gallery it still comes up the error message above.

Got any ideas on why this would be happening?
Paul Green

Chuck S · June 27th, 2006, 08:24 PM

Sorry not without seeing links of what you mean.

creativepart · June 28th, 2006, 06:16 PM

OK here is an example:

Go to this link:
http://www.tdpri.com/telephoto/showphoto.php?photo=2875

and you'll see a photo from user "kingnimrod". Under that photo is a link to his gallery. Click on that and you'll see the error message: "This category does not contain any images."

If you do a search by username you get the same error message, yet if you go to categories that you know he's uploaded to his photos show up. He has 39 photos uploaded.

Looking in the database I see some duplicate image names for this user. I also see some of his photos have a "storeid" and "store cat" of zero and some have numbers that correspond to the directories in the data directory. I don't know if either of those things have any impact on this or not.

So, now that you have an example of what I told you in the first post on this topic, what do you think the cause and or solution is?

Chuck S · June 28th, 2006, 08:34 PM

Did you run the userfix script as I dont think this has been ran or completed

creativepart · June 28th, 2006, 09:13 PM

Yes, as I said in my first post in this thread "I ran Userfix.php and it ran well..." And I've double checked this person's userid has been updated correctly.

I've checked a couple of dozen userids and all were updated correctly.

However, for some reasons other users are reporting in this similar problems.

I re-uploaded my pre-import database and reran userfix.php and the result is exactly the same.

Chuck S · June 28th, 2006, 10:36 PM

Private Albums have not been updated to the new user's userid.

Clearly the album belongs to userid 8647 user britelite so what is brite lites new userid in vbulletin?

creativepart · June 28th, 2006, 11:05 PM

Britelite's vB userid is 8467 and his PHPBB import userid was 9535

Kingnimrod was 8467 but now is 7822.

The userfix.php updates the photos table and the comments table and nothing else.

So, it seems that the userid was updated for some of the table fields but not all???

As I said, I've run it, had this problem, reapplied the backup and run it again. Both times userfix.php has completed without error.

Where is the album info kept? The photos table or elsewhere?

What do I do to fix this?

I have a couple of others complaining about albums now tonight as well.

Chuck S · June 29th, 2006, 10:10 AM

Look at your categories table how many private albums do you have?

You can update that category parent field to 7822

creativepart · June 29th, 2006, 12:15 PM

I have 39 Private Albums. So I might be able to do these by hand. I think I see these in the category table. Is that correct?

So, I went in and changed one of these for Kingnimrod and two of his Private Albums show up. BUT if you go to member galleries and search on his name you will see the now repaired private album, but below the listing of personal albums you get the "This category does not contain any images." error message still.

Why is userfix.php updating the photos and comments table and not the other tables that use user ids for association?? What can I do to correct this situation?

Chuck S · June 29th, 2006, 02:09 PM

yes the ones where cattype=a

I would have to look at adding that to userfix but that would be a complicated process since the cat table does not use the username and we are no longer connected to the other forum

creativepart · June 29th, 2006, 02:22 PM

OK, I can fix the Private Album issue manually.

But why are some user's photos not showing up in the Members Gallery? I mean if you've got 39 photos in the system, why does the Member Gallery for that user show "This category does not contain any images."

Is there a way to predict which members will have this problem is it related to the Private Album problem.

Chuck S · June 29th, 2006, 02:34 PM

Once you fix the private album issue if all they have is private albums you will get the no pictures thing still but you should get an albums thumbnail block with the albums on it

http://www.reeftalk.com/gallery/show...t/500/ppuser/1

creativepart · June 29th, 2006, 03:43 PM

I manually fixed the Private Album issue (turned out to be 60) and when looking at this one user... kingnimrod, I can see that there are photos still missing. He has 39 photos. It shows in the member gallery that he has 39 photos. But when you bring up his member gallery you get 2 Private Albums with a total of 24 photos and the "This category does not contain any images." error message.

He does have other photos. They should show up in the Member Gallery under his Private Albums. I have to assume there are other users that will turn up with the same complaint.

What do I do to fix this issue?

creativepart · June 29th, 2006, 03:52 PM

Checking "Kingnimrod's" photo table I see some duplicated photo names in his record. In fact, he has 14 duplicate and one triplicate. That's 15 photo which is the number "missing".

If Member Galleries shows him with 39 photos and his 2 Private Albums total 24 then 14 dup and one trip would equal 39.

Think this is the cause?

Should I run the maintanence "de-dup" program?

Chuck S · June 29th, 2006, 06:26 PM

If you allowed optional categories on upload he can have duplicates which are shown in other categories thats a feature of the program and this is what I am going to assume these duplicates are.

cant say more without you posting the inserts here

creativepart · June 29th, 2006, 06:45 PM

Could that be why his count is 39 but he only shows 24 in his Private Albums and none in his member gallery listing?

Chuck S · June 29th, 2006, 07:19 PM

I can not say without you posting the inserts here

creativepart · June 29th, 2006, 07:22 PM

I'm not sure what you mean by "inserts." Are you talking about the sql for this users' photos?

Chuck S · June 29th, 2006, 07:26 PM

yes thats the ticket