CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • language limits
Pages: [1]

Author Topic: language limits  (Read 4024 times)

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
language limits
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

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: language limits
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

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: language limits
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+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: language limits
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

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
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...

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • 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
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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

samuelsov

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 2
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
Re: language limits
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

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: language limits
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
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: language limits
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
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

samuelsov

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 2
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
Re: language limits
March 12, 2012, 12:11:10 pm
Quote from: xavier 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

I am using CiviCRM 3.4.8
Consultant @ SymbioTIC.coop
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • language limits

This forum was archived on 2017-11-26.