issues with version 5.7.6 - Access Roles

[rabii]

Hey Guys,

We have upgraded the crm to the latest version 5.7.6 but seems that there are some issues, amongst the list below :

• Our project managers can't view their team accounts, contacts, calls etc
• Mass assignment is not effective and doesn't mass update the records.
• Loading issues of the whole application

We are confused and our managers can't follow up with their teams hence they can't view any records assigned to their teams and this is vital for us. The system was working fine with access roles and once we upgraded we started seeing these unwanted behaviours from the system.

Can anyone help please.

Many thanks

best regards,
Rabii

[Maximus]

Hello,
Could you provide the next information:
1. From what version you have upgraded?
2. What php and db version do you use?
3. What role permissions are selected (screenshot preferred)?
4. What does "Loading issues of the whole application" mean?
5. Error log file from data/logs directory.
6. Check whether the 'aclStrictMode' is true or false in the /data/config.php file?

[rabii]

Hey Maximus,

1 - I have upgraded from version 5.7.1 to 5.7.6 ( i have done it sequencely through all versions )
2 - php version 7.1 and mysql version 5.6
3 - attached screenshot, a project manager should be able to view all his team records but this is not happening after upgrade
4 - application take time to fully load
5 - Below the error log :
[11-Jun-2019 20:59:37 UTC] PHP Fatal error: Uncaught RuntimeException: PHP's json extension is required to use Monolog's NormalizerFormatter in /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Formatter/NormalizerFormatter.php:34
Stack trace:
#0 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Formatter/LineFormatter.php(42): Monolog\Formatter\NormalizerFormatter->__construct(NULL)
#1 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php(184): Monolog\Formatter\LineFormatter->__construct()
#2 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php(112): Monolog\Handler\AbstractHandler->getDefaultFormatter()
#3 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(35): Monolog\Handler\AbstractHandler->getFormatter()
#4 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Logger.php(336): Monolog\Handler\AbstractProcessingHandler->handle(Array)
#5 /home/rmtelema/pitch.wecode.ma/vend in /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Formatter/NormalizerFormatter.php on line 34
[16-Aug-2019 22:30:35 UTC] PHP Fatal error: Uncaught RuntimeException: PHP's json extension is required to use Monolog's NormalizerFormatter in /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Formatter/NormalizerFormatter.php:34
Stack trace:
#0 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Formatter/LineFormatter.php(42): Monolog\Formatter\NormalizerFormatter->__construct(NULL)
#1 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php(184): Monolog\Formatter\LineFormatter->__construct()
#2 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php(112): Monolog\Handler\AbstractHandler->getDefaultFormatter()
#3 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(35): Monolog\Handler\AbstractHandler->getFormatter()
#4 /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Logger.php(336): Monolog\Handler\AbstractProcessingHandler->handle(Array)
#5 /home/rmtelema/pitch.wecode.ma/vend in /home/rmtelema/pitch.wecode.ma/vendor/monolog/monolog/src/Monolog/Formatter/NormalizerFormatter.php on line 34
[28-Aug-2019 00:04:47 UTC] PHP Warning: unlink(data/logs/espo-2019-07-29.log): No such file or directory in /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php on line 567
[28-Aug-2019 00:04:47 UTC] PHP Warning: unlink(data/logs/espo-2019-07-29.log): No such file or directory in /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php on line 567
[28-Aug-2019 00:04:47 UTC] PHP Stack trace:
[28-Aug-2019 00:04:47 UTC] PHP Stack trace:
[28-Aug-2019 00:04:47 UTC] PHP Warning: unlink(data/logs/espo-2019-07-29.log): No such file or directory in /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php on line 567
[28-Aug-2019 00:04:47 UTC] PHP 1. {main}() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:0
[28-Aug-2019 00:04:47 UTC] PHP Warning: unlink(data/logs/espo-2019-07-29.log): No such file or directory in /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php on line 567
[28-Aug-2019 00:04:47 UTC] PHP Stack trace:
[28-Aug-2019 00:04:47 UTC] PHP 2. Espo\Core\Application->__construct() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:32
[28-Aug-2019 00:04:47 UTC] PHP 1. {main}() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:0
[28-Aug-2019 00:04:47 UTC] PHP Stack trace:
[28-Aug-2019 00:04:47 UTC] PHP 3. Espo\Core\Container->get() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Application.php:48
[28-Aug-2019 00:04:47 UTC] PHP 1. {main}() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:0
[28-Aug-2019 00:04:47 UTC] PHP 4. Espo\Core\Container->load() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:44
[28-Aug-2019 00:04:47 UTC] PHP 2. Espo\Core\Application->__construct() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:32
[28-Aug-2019 00:04:47 UTC] PHP 1. {main}() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:0
[28-Aug-2019 00:04:47 UTC] PHP 2. Espo\Core\Application->__construct() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:32
[28-Aug-2019 00:04:47 UTC] PHP 5. Espo\Core\Container->loadLog() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:61
[28-Aug-2019 00:04:47 UTC] PHP 3. Espo\Core\Container->get() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Application.php:48
[28-Aug-2019 00:04:47 UTC] PHP 2. Espo\Core\Application->__construct() /home/rmtelema/pitch.wecode.ma/api/v1/index.php:32
[28-Aug-2019 00:04:47 UTC] PHP 3. Espo\Core\Container->get() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Application.php:48
[28-Aug-2019 00:04:47 UTC] PHP 6. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->__construct() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:122
[28-Aug-2019 00:04:47 UTC] PHP 4. Espo\Core\Container->load() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:44
[28-Aug-2019 00:04:47 UTC] PHP 3. Espo\Core\Container->get() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Application.php:48
[28-Aug-2019 00:04:47 UTC] PHP 7. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->rotate() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:59
[28-Aug-2019 00:04:47 UTC] PHP 4. Espo\Core\Container->load() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:44
[28-Aug-2019 00:04:47 UTC] PHP 5. Espo\Core\Container->loadLog() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:61
[28-Aug-2019 00:04:47 UTC] PHP 4. Espo\Core\Container->load() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:44
[28-Aug-2019 00:04:47 UTC] PHP 8. Espo\Core\Utils\File\Manager->removeFile() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:86
[28-Aug-2019 00:04:47 UTC] PHP 5. Espo\Core\Container->loadLog() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:61
[28-Aug-2019 00:04:47 UTC] PHP 6. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->__construct() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:122
[28-Aug-2019 00:04:47 UTC] PHP 9. unlink() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php:567
[28-Aug-2019 00:04:47 UTC] PHP 5. Espo\Core\Container->loadLog() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:61
[28-Aug-2019 00:04:47 UTC] PHP 6. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->__construct() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:122
[28-Aug-2019 00:04:47 UTC] PHP 7. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->rotate() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:59
[28-Aug-2019 00:04:47 UTC] PHP 7. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->rotate() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:59
[28-Aug-2019 00:04:47 UTC] PHP 8. Espo\Core\Utils\File\Manager->removeFile() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:86
[28-Aug-2019 00:04:47 UTC] PHP 6. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->__construct() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Container.php:122
[28-Aug-2019 00:04:47 UTC] PHP 8. Espo\Core\Utils\File\Manager->removeFile() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:86
[28-Aug-2019 00:04:47 UTC] PHP 9. unlink() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php:567
[28-Aug-2019 00:04:47 UTC] PHP 9. unlink() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php:567
[28-Aug-2019 00:04:47 UTC] PHP 7. Espo\Core\Utils\Log\Monolog\Handler\RotatingFileHa ndler->rotate() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:59
[28-Aug-2019 00:04:47 UTC] PHP 8. Espo\Core\Utils\File\Manager->removeFile() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/Log/Monolog/Handler/RotatingFileHandler.php:86
[28-Aug-2019 00:04:47 UTC] PHP 9. unlink() /home/rmtelema/pitch.wecode.ma/application/Espo/Core/Utils/File/Manager.php:567

6 - aclStrictMode is enabled in config.php

Looking forward to hearing from you

many thanks Maximus.

Best regards,
Rabii

[Maximus]

Please check in Administration -> Settings Requirements whether all extensions are installed. It seems that your PHP doesn't have JSON extension.
Did you change PHP on your web-server?

[rabii]

hey

i have just checked and JSON extension is enabled by default. Nope i have not, which version should work better 7.1 / 7.2 / 7.3 ?

Thanks

[Maximus]

Check please for the json extension by running this command in a terminal:

php -m

Try to install json again by running this command:

sudo apt-get install php7.1-json

After instalation restart your webserver:

sudo service apache2 restart

Check whether the errors apearing again.

For now php v.7.1, 7.2. and 7.3 are supported. In the next EspoCRM release v.5.8.0. php v.7.1 support will be dropped.

[rabii]

Hey Maximus,

I have the command php -m and confirmed that Json is enabled in the configuration. Also reinstalled the extension/plugins and restarted the apache2 and still same problem.

Do you think this could be fixed when the new version 5.8.0 is released.

Thanks

[yuri]

Please provide a screenshot of user roles (Administrator > Users > select user that has problem > click Access button). I believe that there will be "No" access levels. And you will need to fix it in Roles.

[rabii]

Hey yuri

Please see attached screenshot of role for one of our managers, especially entity companies / read - team but it still doesn't work and our manager Mina can't view companies of her team. Am i missing something here.

Thanks

[Maximus]

Hello,
tried to reproduce and it is work as it should. Mass update works w/o any problem.
Can you confirm that this role is set in the manager's role field?
Can you confirm that records which managers don't see have assigned to the manager's team?

[rabii]

Hey Maximus,

yes the mass update works without any issue.

The role is set properly in the manager's role field - i confirm this.

Yes this manager is running a team of 3 sales people and all 3 sales people have records (companies assigned to them) but the manager still can't view these records, when the manager log into the system she can only see her records and can't view her team's records even when she tries to filter only companies that belong to one of her sales team, the result is empty.

I am not really sure why this is happening although everything is set up correctly.

Thanks

[Maximus]

To let your manager see the records in the 'team' scope you should assign these records to the manager's team (see attachment).

[rabii]

Hey Maximus

Thanks for your help. all resource that belong to that manager and his team has been updated - team field - has been reinitiated and was empty after upgrade / only companies entity, so just paid attention to that and fixed it and all is working fine now. though we have another issue with emails now, even if the email account is set correctly but the system doesn't fetch any emails. Could this be a bug or is it something that changed with the latest version regarding email inbox / accounts.

Many Many thanks
Rabii

[Maximus]

>Could this be a bug or is it something that changed with the latest version regarding email inbox / accounts.
I can't reproduce this issue. All works good. I don't think that this is a bug. Also, there are no any upgrades that could affect this functionality.
Try to enable a DEBUG mode in the data/config.php file by changing WARNING to DEBUG in this row

'level' => 'WARNING',

. It should help to gather more info about the issues in your system.

[rabii]

Will do

many thanks again for your great support. Much appreciated

Best regards,
Rabii