jsm25
27 October 2023 15:06
1
We have just updated from 7.11 to 7.14, and the Modules under the detail view have vanished.
Before, I would look in the Account List and select one Account, which would open the Account Deait view. Under the Account, I would have several Modules displayed, such as Contacts & Quotes, which is not showing for me any more.
Can someone help me out and tell me how to get them back, please?
John
rsp
27 October 2023 16:46
2
It could be permission and ownership problem:
Set the following permissions on the SuiteCRM directory(Linux):
sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php
Check section ‘copying_suitecrm_files_to_web_server’
The following documentation is for SuiteCRM Version 7.x; to see documentation on the same topic for Version 8+, click here.
Downloading and installing SuiteCRM If you are installing SuiteCRM for the first time, follow the instructions in this...
sukh0v
27 October 2023 16:53
3
Same issue. chmod not solve this
Edit the 2 lines of code referred to here, and see if it fixes your issue with the subpanels not showing up:
salesagility:hotfix-7.13.x
← hbartel:master
opened 08:02PM - 06 Dec 22 UTC
Fix Issue https://github.com/salesagility/SuiteCRM/issues/9788
Description
C… hanges implemented in MySQL 8.0.31 cause SQL queries that pull data for subpannels to fail. If the outer ( ) is removed from the query, it will complete normally.
The code that adds the outer ( ) to the query is located on lines 876 and 930 of Suite CRM/data/SugarBean.php. By removing these lines the query if fixed.
876: $final_query = '(' . $tmp_final_query . ')';
930: $query = '(' . $query . ')'; '''
Motivation and Context
If the MySQL environment is updated to MySQL 8.0.31 the subpannels that depend on these SQL queries will fail.
How To Test
Update MySQL to 8.0.31 on host server
Create Account with linked subpanel data (contacts, opportunities, leads, ect)
Subpanels must have data for the error to occur.
Open Account detail page & suitecrm.log to see error.
Remove specified lines and test
## Types of changes
- [X] Bug fix (non-breaking change which fixes an issue)
### Final checklist
- [X] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/).
- [ ] My change requires a change to the documentation.
- [X] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.
sukh0v
31 October 2023 13:58
5
this not help in my situation
jsm25
3 November 2023 16:03
6
The issue I have found is that Version 7.14.1 is work without any issues with PHP 7.4 but when I switch to PHP 8.1 or 8.2 I can see the Account view listin but when I make a selection to go to the detail view its blank page.
I have done a repair but on change.
Any thoughts on what to try please.
John