Custim Avatar filenames not correct in DB

[pattycake]

If I look in the customavatars table, I see amongst other things, the filename of the custom avatar.

The filename is av-33.gif, and the actual avatar does exist in the ./customavatars folder.

When I look at any post for this person, I see the word's "Jim's Avatar" instead of the avatar.
When I right click the missing avatar, the properties show the name as avatar33_0.gif

Where the heck did that name come from?? It's not in the customavatars table.

[kh99]

If I remember correctly, the filename field is the name of the file that was uploaded. But I think the '0' in avatar33_0.gif is the avatarrevision field from the user table. I hink it's added when you store files in the filesystem so that if, for example, Jim uploads a new avatar with the same name, the avatar revision will be increased so that the new file has a different name and people's browsers will load the new image instead of continuing to see a cached image.

But I don't know why you're not seeing Jim's avatar. There should be a file with that name (with the _0) in the customavatars folder.