No content loaded inside espoCRM 5.7.* after server migration

[Michael-NDV]

setting old server:
Apache 2.*
MySQL 5.6
EspoCRM 5.7.* installation (the latest version before MySQL 5.6 wasn't supported any longer by newer versions)

setting new server
Apache 2.*
MariaDB 10.5.16
moved installation and MySQL 5.6 Database of the old server

situation
config.php was properly adjusted to the new database details
file/directory permission were adjusted as described here.

login to the software is possible, but after the login no other content (e.g. email messages or administration overview)
can be loaded.

See some screenshots attached.

Any ideas how to overcome this issue ?

Many thanks!

[Kharg]

Hi,

can you check the browser console for errors?

[Michael-NDV]

Hi,

thanks for your hint to the browser console - attached some screenshots of the console.

Here the main error messages:
--------------------------------------------
Uncaught Error: Could not load file 'client/res/templates/fields/link-parent/list.tpl?r=1666577645'
Uncaught Error: Could not load file 'client/res/templates/email/fields/person-string-data/list-for-expanded.tpl?r=1666577645'
Source-Map-Fehler: Error: request failed with status 404
Source-Map-Adresse: gridstack.min.map
Source-Map-Fehler: Error: request failed with status 404
Source-Map-Adresse: purify.min.js.map
Uncaught Error: Could not load file 'client/res/templates/email/fields/person-string-data/list.tpl?r=1666577645'
--------------------------------------------

It's quite curious that even loading the favicon was denied (see screenshot)
The file permission rules are the same like at the old server.


Here are the htacess rules:
--------------------------------------------
<ifModule mod_headers.c>
Header always set Access-Control-Allow-Methods "POST, GET, PUT, PATCH, DELETE"
</ifModule>

DirectoryIndex index.php index.html

<IfModule mod_rewrite.c>
RewriteEngine On

# PROTECTED DIRECTORIES
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^/?(api|client)/ - [F]

RewriteRule ^/?data/ - [F]
RewriteRule ^/?application/ - [F]
RewriteRule ^/?custom/ - [F]
RewriteRule ^/?vendor/ - [F]
RewriteRule ^/?client/?$ - [F]
#END PROTECTED DIRECTORIES

RewriteRule .* - [E=HTTP_ESPO_CGI_AUTH:%{HTTP:Authorization}]

RewriteRule reset/?$ reset.html [QSA,L]
</IfModule>
--------------------------------------------

[Michael-NDV]

File permission example
640: /client/res/templates/fields/link-parent/list.tpl

Should it be 644 as I read it here:

https://docs.espocrm.com/administration/server-configuration/#required-permissions-for-unix-based-systems

Curious that this example file had 640 at the old server and everything worked out.
Could this be the problem?

[esforim]

You can't just load the database/data? Wouldn't this fall into the database issue...?

Check if your new server database username login and password to the database is correct?
And to make sure to create a user to have access to that database, then update the config.php file with the new username.

That just my guess, also you should look at your logs, I think it under /data/log file

[Michael-NDV]

Login details for the database are properly set in the file config.php.
I doublechecked this by testing the database by installing for test purposes the current espocrm version.
So everything fine with the db login details.
I can as well login with all deposited software users into the software. But after login email messages aren't loaded as you can see in the first screenshots.

Would it be possible that the file permissions as pointed out are the problem?
I'll have a look into/data/log thanks.

[Kharg]

That may as well be the problem, try to set the permissions again by executing the commands written in the docs.

[Michael-NDV]

Many thanks for your help.
A quite amount of files had indeed the wrong file permission. 640 instead of 644
I changed them like here described in the docs and now everything loads properly.

We just mirror the data from one server to another and didn't change anything on these files.
So if anyone else has similar problems: check the file permissions :-)