language limits

[Eileen]

Hi,

We are trying to use 4 languages on a civi install (v 4.0) and when I try to enable the 4th one I get the error below.

My research suggests the combined length of the fields in the event table is just too big with 4 languages

http://forums.mysql.com/read.php?22,63584,166521#msg-166521

How many languages are other people using? Any limits hit?

Code: [Select]

Array (   
 [callback] => Array         (           
  [0] => CRM_Core_Error             [1] => handle         )      [code] => -1     [message] => DB Error: unknown error     [mode] => 16     [debug_info] => UPDATE civicrm_event SET pay_later_text_ar_EG = pay_later_text_en_US [nativecode=1030 ** Got error 139 from storage engine]     [type] => DB_Error     [user_info] =>

 UPDATE civicrm_event SET pay_later_text_ar_EG = pay_later_text_en_US

[nativecode=1030 ** Got error 139 from storage engine]     [to_string] =>

 [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_event SET pay_later_text_ar_EG = pay_later_text_en_US [nativecode=1030 ** Got error 139 from storage engine]"] )

[Eileen]

OK,

So just looking

each language has :

 12 text fields
 5 var char fields

In addition to the default fields

The text fields only use the amount of space of the field contents but if one language filled up all their text fields they would hit 9216 bytes - in other words they could exceed the limit with one language alone (unlikely)

However, because there are so many text fields in this table it is likely it would hit limits with 2 or 3 languages using events and almost certain to above that.

[xavier]

argl. Can you check if you need all these to be multi-lingual? Piotr is working on simplifying some other table an monolingual so columns.

X+

[Eileen]

We are pretty early days on this install so they aren't high priority for us yet but... I would have thought that things like event text, pay later e-mail, receipt text are probably some of the most important things to have in more than one language?

[denjell]

And then there is this limit. Like I was saying over at topic,19900.0.html - there needs to be a fundamental change in the way that multilanguage installs are treated.

I was hoping to get our dual language install working so that I could estimate how much time would be needed to get the third, fourth and fifth languages incorporated, but this really dampens my hopes...

[Donald Lobo]

I think the current multi-lingual works nicely for 2-3 languages (maybe even 4)

beyond that there will be issues and we'll need to switch to a different algorithm. Would be great if folks who'd like to allow civicrm to work seamlessly in 5+ languages simultaneously would help design and architect the next generation of the multi-lingual system

Ultimately folks as for any open source project folks scratch their own itch. So far a majority of our users/developers are mono / bi-lingual and hence our focus and attention has been on that aspect

lobo

[samuelsov]

I got this error on event in the registration page civicrm/event/manage/registration?reset=1&action=update&id=5 with 3 languages (including 1 deactivated language). Appart from the fact there is no way to remove one language (views and triggers), it seems that 2 languages is really the limit with the actual system.

[xavier]

Which version are you using?

We did try to limit the number of translated fields to avoid hitting the problem too quickly

[petednz]

we have 2 languages firing on the live site - and i tried implementing a 3rd on dev and now can't recall if i got this while translating the dual language event or just from adding the 3rd language

Code: [Select]

[code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => UPDATE civicrm_contribution_page SET thankyou_text_es_ES = thankyou_text_en_US [nativecode=1030 * Got error 139 from storage engine]
    [type] => DB_Error
    [user_info] => UPDATE civicrm_contribution_page SET thankyou_text_es_ES = thankyou_text_en_US [nativecode=1030 * Got error 139 from storage engine]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_contribution_page SET thankyou_text_es_ES = thankyou_text_en_US [nativecode=1030 ** Got error 139 from storage engine]"]
)
will be upgrading soon and trying again - was on 4.0.8

[samuelsov]

Which version are you using?

We did try to limit the number of translated fields to avoid hitting the problem too quickly

I am using CiviCRM 3.4.8