Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17827

Can't add more than 6 languages

          Details

          • Versioning Impact:
            Patch (backwards-compatible bug fixes)
          • Documentation Required?:
            None
          • Funding Source:
            Contributed Code

            Description

            Hi there,

            In our project we are using CiviCRM with multilanguage mode. Unfortunately we are not able to add more than 6 languages. We are receiving DB error (screenshot attached).
            After some research we found that there is limit on row size in innoDB tables (65535).
            ALTER TABLE civicrm_event ADD title_ar_EG varchar(255) [nativecode=1118 ** Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

            Adding new language in CiviCRM alters some tables (like civicrm_event) and adds new columns per language.

            In my opinion db structure is wrong.
            Do you have any idea how to bypass this issue? Or maybe you've already know that and it is planned to be fixed?

              Attachments

              1. civicrmIssue1.png
                7 kB
                Grzegorz Grzywna
              2. civicrmIssue2.png
                208 kB
                Grzegorz Grzywna

                Issue Links

                is duplicated by

                Bug - A problem which impairs or prevents the functions of the product. CRM-12627 Addind new language gives "Row size too large" error

                • Major - Major loss of function.
                • Done/Fixed

                Bug - A problem which impairs or prevents the functions of the product. CRM-9981 Multilingual limitations with more than 2 languages

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Done/Fixed

                  Activity

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      grzywna.g@gmail.com Grzegorz Grzywna
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated: