how to add a profile image for a member

Yes, you can make it manually,

look at
Table: media
fill here records,
(insert new record and upload picture to profile folder)

to set as thumb, look at
Table: Profiles
fields
PrimPhoto and Picture

PrimPhoto mean ID of `media`
Picture mean - use this as thumb or not :) (1 or 0)

after just clean your cache folder (*.php)

and Done - recheck result

Thanks, AndreyP, that worked like a charm! I noticed in the cache folder there's a file called tiny_mce_4490a91eecf6b6b85d1dc70190ee1a2e.gz - what is that? Is it malicious??