Warnings after installing language pack

CRMFox · 1 October 2021 13:24

Hi everybody,

yesterday I finally got my suiteCRM installation to run. 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.

After that the system worked as expected but after adding a language pack and running the Quick Repair and Rebuild I got the following warnings:

Clearing language files from cache…done

Warning: unlink(cache/modules/Emails/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

Warning: unlink(cache/modules/AOK_KnowledgeBase/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

Warning: unlink(cache/modules/Prospects/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

Warning: unlink(cache/modules/AOS_Contracts/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

Warning: unlink(cache/modules/Home/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

Warning: unlink(cache/modules/EmailTemplates/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

Warning: unlink(cache/modules/Leads/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

Warning: unlink(cache/modules/Surveys/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

Warning: unlink(cache/modules/AOS_Products/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

Warning: unlink(cache/modules/FP_Event_Locations/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

Warning: unlink(cache/modules/Meetings/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

Warning: unlink(cache/modules/ProspectLists/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

Warning: unlink(cache/modules/Administration/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

Warning: unlink(cache/modules/Accounts/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

Warning: unlink(cache/modules/FP_events/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

Warning: unlink(cache/modules/AM_ProjectTemplates/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

Warning: unlink(cache/modules/AOS_Product_Categories/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

Warning: unlink(cache/modules/AOK_Knowledge_Base_Categories/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

Warning: unlink(cache/modules/Documents/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

Warning: unlink(cache/modules/jjwg_Areas/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

Warning: unlink(cache/modules/Tasks/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

Warning: unlink(cache/modules/Users/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

Warning: unlink(cache/modules/Cases/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

Warning: unlink(cache/modules/Contacts/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

Warning: unlink(cache/modules/AOR_Reports/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

Warning: unlink(cache/modules/Notes/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

Warning: unlink(cache/modules/AOS_PDF_Templates/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

Warning: unlink(cache/modules/Spots/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

Warning: unlink(cache/modules/jjwg_Address_Cache/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

Warning: unlink(cache/modules/Calls/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

Warning: unlink(cache/modules/Opportunities/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

Warning: unlink(cache/modules/Campaigns/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

Warning: unlink(cache/modules/AOW_WorkFlow/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

Warning: unlink(cache/modules/jjwg_Maps/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

Warning: unlink(cache/modules/Project/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

Warning: unlink(cache/modules/Alerts/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

Warning: unlink(cache/modules/AOS_Invoices/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

Warning: unlink(cache/modules/Calendar/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

Warning: unlink(cache/modules/AOS_Quotes/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

Warning: unlink(cache/modules/jjwg_Markers/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

can anybody help me fixing this issue or can I ignore the warnings?

samus-aran · 1 October 2021 13:35

Looking at them being all in the cache folder, yes I would be inclined to ignore them. I suspect it is because en_us is being deleted (due to the repair & rebuild) or they didn’t exist in the first place.

Is there any warnings you get that aren’t “language” related?

BTW, Welcome to the community

CRMFox · 1 October 2021 13:49

wow, that was quick
I understand, I was installing the system in English so I’m pretty sure the en_us existed at some point. Also I still can switch between the two languages.
Concerning other warnings I’m glad you’re asking. Unfortunately there are some other warnings, and I forgot to mention, that I added one field to accounts via the Studio:

Rebuilding Relationships
Warning: unlink(cache/modules/ACLRoles/ACLRolevardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/ACLActions/ACLActionvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/Leads/Leadvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/Cases/Casevardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/Bugs/Bugvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/ProspectLists/ProspectListvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239
.
.
---- I had to shorten this because of the message limit, but they are all related to VardefManager.php
.
.

Warning: include(cache/modules/SurveyQuestions/SurveyQuestionsvardefs.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 453

Warning: include(cache/modules/SurveyQuestionOptions/SurveyQuestionOptionsvardefs.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 453

Warning: unlink(cache/Relationships/relationships.cache.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/data/Relationships/RelationshipFactory.php on line 90

Warning: unlink(cache/Relationships/relationships.cache.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/data/Relationships/RelationshipFactory.php on line 90
Rebuilding TableDictionary…
Updating the admin warning message…

---------------------------------- Next Warning section ---------------------------------

Audit table for SurveyQuestionOptionss already exists. skipping…
Done
Warning: unlink(cache/modules/ACLRoles/ACLRolevardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/ACLActions/ACLActionvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/Leads/Leadvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/Cases/Casevardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239

Warning: unlink(cache/modules/Bugs/Bugvardefs.php): No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 239
.
.
---- I had to shorten this because of the message limit, but they are all related to VardefManager.php
.
.

Warning: include(cache/modules/Surveys/Surveysvardefs.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 453

Warning: include(cache/modules/SurveyQuestionResponses/SurveyQuestionResponsesvardefs.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 453

Warning: include(cache/modules/SurveyQuestions/SurveyQuestionsvardefs.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 453

Warning: include(cache/modules/SurveyQuestionOptions/SurveyQuestionOptionsvardefs.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/VardefManager.php on line 453

Database tables are synced with vardefs

Warning: require(cache/modules/Users/language/en_us.lang.php): failed to open stream: No such file or directory in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/include/SugarObjects/LanguageManager.php on line 275

Warning: filemtime(): stat failed for cache/smarty/templates_c/%%00^00F^00F5D2D7%%footer.tpl.php in /var/www/web26589463/html/suiteCRM/SuiteCRM-7/vendor/smarty/smarty/libs/Smarty.class.php on line 1397

samus-aran · 1 October 2021 14:01

Hmmm These “include” and “require” is a little more puzzling than the unlinking.

You see that it says “cache/modules/SurveyQuestionOptions/SurveyQuestionOptionsvardefs.php” But that should really be “cache/modules/SurveyQuestionOptions/SurveyQuestionOptions/vardefs.php” See that missing forward slash?

I stand corrected. This missing slash is fine having looked deeper. The VardefManger hasn’t been updated for a while so I suspect that those warnings are accurate for another reason.

That line 453 links to this.https://github.com/salesagility/SuiteCRM/blob/73ded274eebfd17868b3b24e2e3294690635857e/include/SugarObjects/VardefManager.php#L453

Interestingly though it needs to go through these two checks to even get there… indicating that the file does exist AND it’s writable…

if (file_exists($cachedfile)) {
            if (is_readable($cachedfile)) {
                include($cachedfile);
            }

Now I would see if that affects things i.e.the general day to day running of your systems, if you add new fields to these modules do they still function as expected? If you are still able to do these things without any noticeable difference then I think I am happy enough that the vardefs somewhere else are being referenced correctly to your cached folder.

Another one I’m not happy seeing is:

Warning: require(cache/modules/Users/language/en_us.lang.php)

Can you check if it there? If it IS there, then check the permissions, perhaps the system can’t read/write to it. Same goes for the whole cache folder, ensure its permissions are set to allow the application to read/write.