Author Topic: language limits  (Read 2794 times)

Offline Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 3992
  • Karma: 202
    • Fuzion
language limits
« on: March 29, 2011, 06:56:16 pm »
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]"] )
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Offline Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 3992
  • Karma: 202
    • Fuzion
Re: language limits
« Reply #1 on: March 29, 2011, 07:31:46 pm »
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.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Offline xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4291
  • Karma: 155
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: language limits
« Reply #2 on: March 30, 2011, 12:11:11 am »
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+

Offline Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 3992
  • Karma: 202
    • Fuzion
Re: language limits
« Reply #3 on: March 30, 2011, 12:21:59 am »
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?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Offline denjell

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.0.1
  • CMS version: Drupal 7.0.1
  • MySQL version: 5.1.41
  • PHP version: 5.3.2-1ubuntu4.9 (10.4 64bit)
Re: language limits
« Reply #4 on: May 10, 2011, 06:22:08 pm »
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...

Offline Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15837
  • Karma: 466
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: language limits
« Reply #5 on: May 11, 2011, 04:43:50 pm »
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

Offline samuelsov

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
Re: language limits
« Reply #6 on: January 25, 2012, 09:32:49 am »
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.
Consultant @ SymbioTIC.coop

Offline xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4291
  • Karma: 155
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: language limits
« Reply #7 on: February 20, 2012, 05:13:17 pm »
Which version are you using?

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

Offline petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4437
  • Karma: 168
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: language limits
« Reply #8 on: February 20, 2012, 07:35:12 pm »
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
pete davis : www.fuzion.co.nz : connect + campaign + communicate

Offline samuelsov

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
Re: language limits
« Reply #9 on: March 12, 2012, 12:11:10 pm »
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
Consultant @ SymbioTIC.coop