User Profile Photo Not Showing

thesage · 14 April 2025 13:28

When uploading a user profile photo in Suitecrm 8.8, the photo doesn’t not display. The photo uploads correctly to the upload directory but it is missing the png extension. Example: 4654c8df-0014-aae6-0838-67f69c1d5c09_photo

I have tried multiple .png and .jpg photos with different dimensions. It didn’t solve the problem.

There is no problem when uploading image to “Current Logo” in system settings, user interface.

Is this a bug or there is something wrong with my installation?

rsp · 15 April 2025 16:51

For profile image, it looks like an error. It is not working.

For Company Logo, the PNG format image worked for us but not JPG.

thesage · 22 April 2025 08:20

Thank you for the reply. Good to know that it’s not my installation problem.

creativologist · 12 August 2025 14:22

So this still doesn’t work?

rsp · 12 August 2025 15:40

Did you try it out with PNG image?

creativologist · 12 August 2025 16:03

Yeah nothing. broken image in profile

Code:

Filename is “1_photo” (not i_photo10) as reference and no extension

I changed it to 1_photo10 (without the extension)

Now the file name shows in profile.

It’s clickable, leads to a download but it’s an empy png

rsp · 12 August 2025 16:42

Are you trying to update the profile image? That does not work in the SuiteCRM. It will only show you the image name & if you click on it. It will download it for you in the v8.

In version 7, we could see the image in the user management, but still it will not show it in the profile icon on the top-right corner.

So, it is a bug and maybe someone already raise it on the GitHub.

creativologist · 14 August 2025 00:51

This is the error. It looks like the fix is pretty easy for someone that understands this, there’s a missing field in the USER database table

Tue Aug 12 2025 at 11:13:54 [644014][1][FATAL] Query Failed: SELECT filename name FROM users WHERE users.id= ‘1_photo10’: MySQL error 1054: Unknown column ‘filename’ in ‘field list’

rsp · 14 August 2025 14:16

I do not see the filename column in the database.

We have the photo column in the users table.

Maybe we need to update code for it.

pgr · 14 August 2025 16:22

The filenames ending in _photo, without any extension, are normal.

See my blog post for details.

creativologist · 14 August 2025 16:37

That’s fine. We are trying to ascertain why the images won’t show and the missing field in the DB seems to point to the problem.

Tue Aug 12 2025 at 11:13:54 [644014][1][FATAL] Query Failed: SELECT filename name FROM users WHERE users.id= ‘1_photo10’: MySQL error 1054: Unknown column ‘filename’ in ‘field list’

pgr · 15 August 2025 11:23

Maybe the bug is the missing field, or maybe (more likely) it is a bug generating the query.

It would be helpful if you could list the “steps to reproduce” the bug, what specifically makes that log message appear.

creativologist · 17 August 2025 03:26

After looking into further, the error first doesn’t appear in log.

However the filename in the upload directory is 1_photo

The page source is this:

img src=“index.php?entryPoint=download&id=1_photo10&type=Users” style=“max-width: 200px;” height=“50”

So it looks like it’s looking for 1_photo10

I thought I would rename the file in the upload directory to 1_photo10.

That’s when the error shows in the log.

Sat Aug 16 2025 at 22:22:04 [312833][1][FATAL] Mysqli_query failed.
Sat Aug 16 2025 at 22:22:04 [312833][1][FATAL] Query Failed: SELECT filename name FROM users WHERE users.id= ‘1_photo10’: MySQL error 1054: Unknown column ‘filename’ in ‘field list’

pgr · 19 August 2025 15:30

For reference, this conversation continues here

github.com/SuiteCRM/SuiteCRM-Core

Custom image field in products modules comes with an extra "10" at the end of the filename. Images don't load.

opened 06:17PM - 18 Aug 25 UTC

inhubbynogitty

Type: Bug

### Issue I added image fields to the product module using the studio in versio…n 8.8.1. The links to the images are generated wrong, with an extra "10" to the end of the file name, making the link invalid. Digging through code, in cache/themes/suite8/modules/AOS_Products/DetailView.tpl `<img src="index.php?entryPoint=download&id={$fields.id.value|default:''}_{$fields.photo_03_c.name}{$fields.width.value|default:10}&type={$module}" style="max-width: {if isset($vardef.width)}120{else}200{/if}px;" height="{if isset($vardef.height)}{else}50{/if}">` if I delete the whole "field width value" then the extra "10" is gone and the images are properly loaded. Where do I patch it permanently? I'm a php developer but new to suitecrm. ### Possible Fix _No response_ ### Steps to Reproduce the Issue ```bash 1. In studio add image field to products module and fix layouts for editing and vewing. 2. Save and implement. 3. Go to products module and insert a new product, selecting images for the fields. Save and go to listing. 4. The images are not display showing a broken link. ``` ### Context _No response_ ### Version 8.8.1 ### What browser are you currently using? Firefox ### Browser Version 128.13.0esr (64-bit) ### Environment Information MariaDB php8.3 ### Operating System and Version RHEL9

creativologist · 1 October 2025 01:25

That resolved the user profile photo. It now shows when i edit my profile. I would have thought it would also show in place of the placeholder on the top right but doesn’t, nor do I know if it’s supposed to

But that didnt resolved the product issue and I added a comment there

Thanks for that link.