Upgrading 6.1.4 to 6.1.6 - Profile photos gone

Hello anyone. I have been upgrading from 6.1.4 to 6.1.5 and from 6.1.5 to 6.1.6 to have my Dolphin updated, but ever since, my members photos are not displayed anymore. It is showing only from those who register new account. I followed the structure of the database to compare the changes, but it does'nt seem to be a difference from the old profiles with the new ones...

Did anyone found the solution to this? Thanks for taking time reading and/or replying.

Something you can look for is to go here: media/images/profile/

make sure that you see the number files(ex. 1, 2, 3, 4, etc.) of all members and they contain the profile images for your existing users. If they do, you may need to re-associate the primary photos in the database.

check Profiles table field PrimPhoto if it has values, if its empty create a script to generate the value for PrimPhoto based on records in media table.

I checked everything well. There is no difference, all the same, with proper media ID and media profile ID. Any other possibility?

Well, is strange that displays only the new added photos. My media files are still there and intact together with the tables. Cannot figure out what went wrong.

Try going into your admin panel and click Settings>Advanced Settings then remove the check mark from use GD fro image processing and see if they populate then. Sorry, just trying to think of all the possibilities.

Chris

This is insane. Now i realise that the member IDs got somehow changed. ALL of them... I wonder how that coudl be possible... Now who is who?

I had a test profile which was with ID 1, and turned as 428. What about the other members? Shall i take them one by one? Is insane!!! Only from a damn upgrade it changed my profile IDs somehow. Now im thinking to a better solution to fix this ...

I see that ID 428 is the lowest member ID, which used to be ID 1 before. That must be a rule or something... I guess member with ID 2 turned as 429??? Im going nutts...

Shaneed, your going to have fun fixing all of this if you go forward with your upgrade.  Right now you have 2 choices as I see them.

1.  Re-set the site to 6.1.4 with a back-up of the DB & the public_html/directory (or whereever you have your files).  Then you can consider starting over again.  Question though real quick, did you do the 6.1.5 upgrade before you did the 6.1.6 upgrade?  They have to be done in order and no steps can be skipped in this.

2.  If you did the upgrades in the correct order, you can fix this DB error yourself, but it will be time consuming for you. 

Login to your cPanel and go to phpMyAdmin and select the DB for the 6.1.4 if you still have it somewhere or grab a back up of the DB and ask them to set it up a new DB and set it in there.  Your host should do this for you no problem, not a huge deal.

Next, login and pull up in phpMy Admin your DB of the 6.1.6 system.

Now, in each you need to go to profiles & then click on Browse in the top menu, next take a look at the number of pages you have (right now your at 30 per page) and do the math, figure your total number of profiles.  If it's 429 then you need to set it as follows at the bottom of the page:

And then click "Show" this will make all the profiles (however many there are show up)

Next, you want to scroll back to the bottom & click the "Check All" and then you want to click the "Pencil" icon next to With selected:

 This is going to open all the Profiles up for you to edit them.  Do this in the 6.1.4 DB & the 6.1.6 DB and set them side by side on your screen so you can look at 6.1.4 & fill in 6.1.6 as you go.  Your after the first field on each one of the profiles.  They will not necessarily go in numerical order if you have had some members delete their profiles and your looking to make everything match up, so this is how your going to do it.  Wish I could just write an SQL query for you, but we don't know if it did it in the same exact numerical order on 6 as it was in 4.

When your finished and get to the bottom of the page (it will be a very very very long page) just click "Go" at the bottom and it will save it all for you and update the DB accordingly.

Good luck and I hope you have tons of good music, because this is going to take a little bit of time to fix.

***Note:  Boonex may want to take a look at what did happen here, as this is NOT supposed to happen from a simple upgrade from 6.1.4 to 6.1.6 if you did it properly. 

Thanks mydatery, i own you for this.  That's kind of you. I have to mention that i did properly upgraded as stated in readme files. from 614 to 615 and lately from 615 to 616. Anyway, i have a backup of it, so i will follow your advice. Thanks a bunch for sharing and for your time explaining me.

I suggest you start over if you can too.

614 to 5 is just a few ray/site stat sql's  I think perhaps you used the wrong patch

615 to 6 is also simple touchups that dop not touch Profiles table.

The files are good.

start with backup 614 DB and then run the patches in order...for this you will need the sql folder reuplaoded, then the upgrade file re uploaded for 614 to 615   then run the www.site.com/upgrade.php

now overwrite the sql folder with the 616 sql folder and upgrade.php and run www.site.com/upgrade.php

this should save you hours of time doing it by hand.

Thanks anyway mrpowless, but after 2 hours of manual editing from old database to the new one, i finally got the IDs in order. Huh, now is ok again as before. But im still worried about the next upgrade if there will be so much struggle again. But still cannot find the explanation of changing my members IDs from upgrade. Thank you all for your contribution, i own you one. I also had found a profile with the Username couple32(2), which caught my attention, having another member with couple32. Strange...

But i still wonder after what rule Dolphin assigns the IDs...