Weird Email client problem

SuiteCRM Forum - English Language SuiteCRM General Discussion
3

@JulianHarmer

Check the permissions. Some js files isn’t loading.

4

Hi Ashis,

Yes I tried that and it didnt work for me, I’d have thought it would.

Thanks

5

Hi P.Konetskiy,

Here’s the commands I issued from the link you sent over.

root@suitecrm:~# cd /var/www/html/suitecrm/
root@suitecrm:/var/www/html/suitecrm# ls
Api export.php ModuleInstall suitecrm_06_22_21_1.log suitecrm.log.old
cache files.md5 modules suitecrm_06_22_21.log suitecrm.log.original
campaign_tracker.php HandleAjaxCall.php pdf.php suitecrm_06_23_21.log suitecrm_version.php
composer.json ical_server.php php_version.php suitecrm_06_24_21.log themes
composer.lock include public suitecrm_1.log TreeData.php
config_override.php index.php README.md suitecrm_2.log upgradeWizard.log
config.php install RoboFile.php suitecrm_3.log upload
config.php-original install.log robots.txt suitecrm_4.log vcal_server.php
cron.php install.php run_job.php suitecrm_5.log vCard.php
crossdomain.xml json_server.php service suitecrm_6.log vendor
custom jssource soap suitecrm_7.log XTemplate
data lib soap.php suitecrm_8.log Zend
deprecated.php LICENSE.txt sugarcrm.log suitecrm_9.log
dictionary.php log_file_restricted.html SugarSecurity.php suitecrm.log
download.php maintenance.php sugar_version.json suitecrm.log.2
emailmandelivery.php metadata sugar_version.php suitecrm.log-copy
root@suitecrm:/var/www/html/suitecrm# ls …
index.html suitecrm
root@suitecrm:/var/www/html/suitecrm# sudo chown -R www-data:www-data .
root@suitecrm:/var/www/html/suitecrm# sudo chmod -R 755 .
root@suitecrm:/var/www/html/suitecrm# sudo chmod -R 775 cache custom modules themes data upload
root@suitecrm:/var/www/html/suitecrm# sudo chmod 775 config_override.php 2>/dev/null

Unfortunately the problem persists. What would you suggest?

Thanks

6

@JulianHarmer

Are you sure that owner of your web server is www-data?

7

Hi , Thanks for the suggestion.
from here, https://serverfault.com/questions/125865/finding-out-what-user-apache-is-running-as
I got the following
root@suitecrm:~# ps -ef | egrep ‘(httpd|apache2|apache)’ | grep -v whoami | grep -v root | head -n1 | awk ‘{print $1}’
www-data
So it appears to be www-data

8

@JulianHarmer

OK. I have last idea only - clear the browser cache.

9

Thanks for the suggestion, but I’ve tried that. I’ve exhausted my ideas too.
Is there a way of getting further help?
Thanks

10

@JulianHarmer
Install new copy of SuiteCRM for testing.

11

Thanks for that, I’ve installed a new instance of SuiteCRM and it works fine !!
But I think I know what happened, I just don’t know how to fix it…

I had an older version of Suitecrm, which I upgraded to 7.10.30, but realised the base OS was out of support the following week. So I created a new VM, with Ubuntu 20.04, put SuiteCRM on it, then copied all files/folders from the original the suiteCRM directory over from the VM with the old OS to the VM with the new OS.

So did the copy go as it should? I suspect this may be the cause, or more likley the default "copied"rights. It works fine on the fresh install, can I copy a subset from there to the faulty SuiteCRM installation? If so what permissions need to be set?

Thanks, I believe we’re on the right track.

12

@JulianHarmer

Look at my the first post in this discussion. There is the link on documentation about permissions.

13

Thanks for that, you don’t happen to know which folders would be relevant to the internal email client

14

Try a few different repairs from Admin / Repair. Sometimes after permissions get messed up, these need to be reapplied.

Currently, do you get the problem in your first screenshot, in the second screenshot, or both? I am talking about the ones in your original post above.

15

Hi Pgr,

I get the problem in the first screenshot, then when I select delete I get the second screenshot

Thanks

16

Hi pgr,

I ran every repair option, but unfortunately the problem persists.

I’ve been looking at the fresh install and everything works perfectly, the only difference between them is the copying over my old install on top of my new one, both 7.30.10 What folders are relevant to to the email client? I’d like to copy my fresh install’s folders over the email side of the faulty one and see if that makes a difference.

Thanks

17

It’s not simple, the module pulls files from many places.

What I find strange about your issue is that what you are seeing is a bug that is already fixed in 7.10.30. Strangely, the fix is not taking effect, possibly because of the permission problems you had earlier.

Try deleting everything in this folder (it will all get re-created):

cache/smarty/templates_c

and in this one:

themes/SuiteP/modules/Emails

18

Hi,

I’ve been doing some more researching. Building SuiteCRM servers. corrupting them, building new ones etc.

I’ve found the problem is some how related to the database. As soon as I exported and imported the database to another server the problem followed it

I used this to export it

sudo mysqldump -u root -p yetiforce > dbexport.sql

and this to re import it.

sudo mysql -u username -p dbname < dbexport.sql

Getting Closer !!

Any suggestions?

19

Is your DB import/export being made between matching versions of SuiteCRM?

20

Yes, that’s the weird thing, all versions are 7.10.30

21

Well, I don’t know, we don’t have many clues about the problem, and this DB depedency is surprising to me, I don’t know how it could be affecting this.

Maybe you can try looking for differences in your logs, comparing when it works and when it doesn’t (opening that screen)

22

Just following up from your other posts.

Just to see if we can narrow this down. Now, it is possible you have a corrupted database table which is affecting email templates (because the nature of email templates is that it stores HTML which then may try to be rendered on screen and then throwing up these styling/functional errors). I do suggest that you export your database again but this time to exclude the email_templates table and see if you put that into a fresh instance (test instance) that it appears to be functional. Then at least we can look at any troubling email templates you are having. I’m assuming there is a number of them?

mysqldump -u USERNAME -pPASSWORD DATABASE --ignore-table=DATABASE.table1 > database.sql

DATABASE = your suitecrm’s database
table1 = email_templates

Also, lets see what you’re browser is saying. You can usually see any browser errors from the browser console on the problem page. Now depending on what browser you use you may have to navigate to different menus. If on Firefox you can use F12 . Have a look there and see if you have anything like “Unable to load X,YZ file”