Profile Pictures are 'scrambled' after update from 3.x to 3.5.1

[InfidelMatt]

In both 3.0.7, and now 3.5.1 profile pictures are stored in the database. The problem is that in the new version, the old pictures are brought in scrambled and unrecognizable.

Note that uploading new pictures works fine.

Any help would be appreciated,
Matt

[Steve Machol]

Did you backup and restore this database? There is a corruption problem with shell backups for vB 3.0.x made with the mysqldump from MySQL 4.1.x. To fix this problem, run these queries on the db prior to making the backup:

ALTER TABLE attachment CHANGE filedata filedata MEDIUMBLOB NOT NULL, CHANGE thumbnail thumbnail MEDIUMBLOB NOT NULL;

ALTER TABLE customavatar CHANGE avatardata avatardata MEDIUMBLOB NOT NULL;

ALTER TABLE customprofilepic CHANGE profilepicdata profilepicdata MEDIUMBLOB NOT NULL;

We found that a character set issue in MySQL 4.1.x is at fault. Converting these fields to mediumblob fixes the problem.

This is not an issue with vB 3.5.0 because these fields are already set this way.

[Freddie Bingham]

Note, the problem only occurs with 3.0.7 or older. 3.0.8 already has those queries performed.

[InfidelMatt]

That must be it. I won't have to worry about it when I push the upgrade on my live board, good to know.

[zendiver]

None of my profiles are showing up either, yet I see them all in the `vb3_customprofilepic` table of the database. I am running 3.5.2 now as I was running 3.0.3. Is there way to retrieve them now so that they are exported back into the proper folder so they will be viewable? I have read through almost every post that showed up with something like this in the title from doing a search. I have done the 'move to database' back to files...etc....yet they are still visible in the table.

[zendiver]

I have said the heck with it and have asked my members to reupload their profile photos. NOW when they do, the get an error: "Upload of file failed."
This is not true. Their upload did succeed and their profile picture is in the appropriate folder 'customprofilepics'. I am glad that it works, but why are they receiving this error. I tried it myself and got the same error yet my photo uploaded and is visible.

Any thoughts?

[zendiver]

Is anyone else having this issue of uploading profile pictures. They seem to upload, but they get an error before it does.

[Art Andrews]

-Update: Problem fixed-

I moved the avatars and profile pics to the database, and then I unsuccessfully tried to move them back into the file system. The problem was the "customprofilepic" directory was new and did not have 777 permissions.

After CMOD-ing the "customprofilepic" directory, the profile pictures were restored and worked properly within the forum.

---------------------------------------
Yes, I am having the same error. On my main forum, it shows a broken image to the user's profile picture. Even Vb reports that I have one meg used on profile pictures, even though there are none in the customprofilepics folder. Uploading over the old profile pic doesn't work at all on that board.

On a test board I upgraded, uploading the profile picture results in an error, but it is visible afterward, just as you described, Zendiver.

[Freddie Bingham]

When upgrading to 3.5.x from 3.0.x and you have avatars in the FS, you must move them back to the DB and then back out to the FS. This note is in the release announcement.

As for the "Upload Failed" problem, please submit a support ticket and ask for it to be assigned to me.