Photo does not show on users's profile

💬 General Discussion
1

I am just editing the photos and adding the new fields to (Users / Employees) menus, but I can upload the images, however when I edit the user’s or employee’s profile, the picture does not load, however when I use the Contact menu, works fine there!

is there something to be done? I’ve tried to redimension the image to 160x160 which is the default resolution, but even though, does not load.

Could someone help me out?

Best Regards,

1 Like
2

Hello All,

I’ve gotten this erros on the log files, if this can help!

for employees

Wed Nov 25 14:21:56 2015 [23425][28d8b126-7060-0521-18a6-545a075a21a8][FATAL] Query Failed: SELECT photo FROM employees LEFT JOIN employees_cstm cstm ON cstm.id_c = employees.id WHERE employees.id= ‘28d8b126-7060-0521-18a6-545a075a21a8’: MySQL error 1146: Table ‘suitecrm.employees’ doesn’t exist

for users

Wed Nov 25 14:22:17 2015 [23246][28d8b126-7060-0521-18a6-545a075a21a8][FATAL] Query Failed: SELECT photo FROM users LEFT JOIN users_cstm cstm ON cstm.id_c = users.id WHERE users.id= ‘28d8b126-7060-0521-18a6-545a075a21a8’: MySQL error 1146: Table ‘suitecrm.users_cstm’ doesn’t exist

I hope this can help!

Thank you!

3

Have you tried running Quick Repair and Rebuild: if, at the bottom of the resulting page you are prompted to execute something you should proceed and then run Quick Repair and Rebuild again.
It should fix your database. It seems that the table for employees custom felds is missing.
I also recommend to reset files and folder permissions before and after Quick Repair and Rebuild.
Perform a backup of your db and files before.

4

When I run the Quick Repair and Rebuild, I always get this code at the end:

/* Table : alerts */
/COLUMNS/
/*MISMATCH WITH DATABASE - subscribers - ROW [name] => ‘subscribers’ [type] => ‘mediumtext’ /
/ VARDEF - subscribers - ROW[name] => ‘subscribers’ [vname] => ‘LBL_SUBSCRIBERS’ [type] => ‘varchar’ [len] => ‘65534’ [massupdate] => ‘’ [studio] => ‘false’ [comment] => ‘A serialized array of (SugarBean type => id) which can receive this alert.’ [dbType] => ‘varchar’ [required] => ‘’ /
/ INDEXES */
ALTER TABLE alerts modify COLUMN subscribers varchar(65534) NULL ;

I have already ran it directly on the MySQL interface and through the “Execute” button at the bottom of the page!
No matter how many times I run the Quick Repair and Rebuild function, I always get this message!

do you think that this can be an error which is causing this problem?

Best Regards (I have not change permissions yet)

5

Does your Apache log show anything useful?

Try resetting permissions before and after running quick repair and rebuild.
Have you configured permissions in config.php?
These are fundamental things for the good functioning of the system.

6

Could you guide me through this process?

1 - how to set the right permissions for the folders/files?
2- which permissions should I configure in the config.php?

I am kind of new on suitecrm and I sill have limited skills to work this out!

I appreciate your help!

Thanks!

7

for permissions I’ve used:

sudo chown -R www-data:www-data /var/www/suitecrm
sudo chmod -R 775 /var/www/suitecrm
sudo chmod -R 775 cache custom modules themes data upload config_override.php

then I ran the Quick Repair and Rebuild again and got the same message at the end:

/* Table : alerts */
/COLUMNS/
/*MISMATCH WITH DATABASE - subscribers - ROW [name] => ‘subscribers’ [type] => ‘mediumtext’ /
/ VARDEF - subscribers - ROW[name] => ‘subscribers’ [vname] => ‘LBL_SUBSCRIBERS’ [type] => ‘varchar’ [len] => ‘65534’ [massupdate] => ‘’ [studio] => ‘false’ [comment] => ‘A serialized array of (SugarBean type => id) which can receive this alert.’ [dbType] => ‘varchar’ [required] => ‘’ /
/ INDEXES */
ALTER TABLE alerts modify COLUMN subscribers varchar(65534) NULL ;

This commands I have run already and from the MySQL and the query ran successfully!

Any idea?

8

when I tried to click on the picture which was linked to the User or Employee I get this error message on the browser:

“Error retrieving record. This record may be deleted or you may not be authorized to view it.”

I am trying to work this around and as I go, I tell you!

Thank you!

9

Try checking the .htaccess file(s). It may also be possible that they are blocking something.
Check first the file in the SuiteCRM folder and then in the main folder.
Then check if you have some settings in your apache config file that may block the viewing of photos

10

when I use the contacts menu, the images are loaded normally.

what would be the .htaccess files? where is their location? I could not find it yet!

11

Hi there, just to be sure, the installation guide says

sudo chmod -R 755 /var/www/suitecrm

Is there a reason why you used

sudo chmod -R 755 /var/www/suitecrm

?
Thank in advance,
Eef Vreeland