Warning after installation "LanguageManager.php"

CRMFox · 8 October 2021 17:58

Hi everybody,

After doing a completely fresh installation of the SuiteCRM-7.11.22 I get the following warning. The system runs on PHP Version 7.3 & MySQL Version 5.6. The only thing I edited in order to get the system working is documented here:

github.com/salesagility/SuiteCRM

Index hits Key threshold in MySQL5.6/UTF-8

opened 12:46PM - 02 Jul 19 UTC

closed 04:49PM - 31 Jul 19 UTC

samus-aran

Type:Bug Status:Fix Proposed Priority:Critical

#### Issue A forum users has discovered that installing SuiteCRM 7.11.6 (>7.1…1.5 are not affected) produces a failure due to the combination of the fields to create a DB index. It appears that the issue is due to MySQL 5.6 hitting the threshold of 1000 characters (MyISAM) or 767 (InnoDB). MySQL 5.7 has a higher threshold which is 3072. However on top of that threshold character set also contribute to this.. in this case it's UTF8 which adds more characters rather than if it was e.g. latin1. This issue was introduced by fix provided to resolve this issue #7351 and it wasn't picked up by tests - most tests run on MySQL 5.7 but our MySQL 5.6 environment also didn't fail. #### Expected Behavior 1. Installation should not fail on MySQL 5.6+ #### Actual Behavior 1. Installation fails (appears) on MySQL 5.6 and using UTF-8 #### Possible Fix Either: 1. Revert original fix by reducing the character limit from 255 to suggested 100 or 2. Cap the character set within the index itself (needs to confirm this is doable). #### Steps to Reproduce Can't replicate this locally or on travis (tho suspect that on travis the install is different) Please see error logs of user's post. https://suitecrm.com/suitecrm/forum/announcements/26612-suitecrm-7-11-6-7-10-18-7-8-31-maintenance-patch-now-available#86505 #### Context #### Your Environment * SuiteCRM Version used: 7.11.6 * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): See Post * Environment name and version (e.g. MySQL, PHP 7): MySQL 5.6 * Operating System and version (e.g Ubuntu 16.04): WAMP @Abuelodelanada Are you able to have a wee look at this?

github.com/salesagility/SuiteCRM

FIX #7509 - Using prefix index to not hit Key threshold in MySQL5.6/UTF-8

salesagility:hotfix-7.10.x ← gcoop-libre:hotfix-7.10.x_7509

opened 05:04PM - 02 Jul 19 UTC

Abuelodelanada

+2 -2

## Description See #7509 ## Motivation and Context ## How To Test Thi…s ## Types of changes - [x] Bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds functionality) - [ ] Breaking change (fix or feature that would cause existing functionality to change) ### 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.

The Warning message:
Warning: unlink(cache/modules/Schedulers/language/en_us.lang.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/LanguageManager.php on line 180

And yes the file is indeed missing.

I also get a lot of warnings when I perform a Quick Repair. Will hand them in later, just changed the domain address which takes couple of minutes.