Details
-
Type:
Patch
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.15, 4.7.16, 4.7.17, 4.7.18
-
Fix Version/s: 4.7.25
-
Component/s: Core CiviCRM, Internationalisation
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Contributed Code
-
Verified?:No
Description
Disabling multiple languages is almost certain to fail on an existing reasonably well populated system due to row size constraints. This patch makes a couple of simple tweaks to the SQL queries so that it is much more likely to succeed!
1. Column is renamed instead of created and copied, as the copy often leads to a row size constraint (eg. in civicrm_event when you have some text in intro_text_lang).
2. Use DROP VIEW IF EXISTS instead of DROP VIEW (supported in mysql 5.1+). There is more support for IF EXISTS on other SQL functions in new versions of mysql but we can't use them if we're maintaining compatibility.