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) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contact Change Logging
Pages: [1]

Author Topic: Contact Change Logging  (Read 534 times)

kengle3

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
Contact Change Logging
October 30, 2012, 04:26:16 pm
Currently, the only way to do contact change logging is working on English only sites.

I'd like to understand why its disabled for multi-language sites, and not generally available. Can anyone point me in the right direction?

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: Contact Change Logging
October 30, 2012, 05:00:51 pm

to be more accurate change logging was available only to uni-lingual sites

the major reason was both change logging and multi-language used triggers on tables and mysql allows only one trigger function per table

however in 4.2 we've improved the code and introduced a trigger hook to combine multiple triggers etc in one function. This in theory will allow u to combine multi-language and change logging

however no one has tested it and/or changed the code to get the two working together.

however on a larger scale, our multi-lingual implementation does not really scale beyond 2-5 languages and will become less scalable as some tables get bigger. This is primarily because we just add column to the same table for each additional language.

Ideally would be good to get a few users and developers who are using multi-lingual civicrm and figure out how to improve and make things better going forward.

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

kengle3

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
Re: Contact Change Logging
November 19, 2012, 03:50:23 pm
Where in the code should I look to modify it and test it in order to support both.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contact Change Logging

This forum was archived on 2017-11-26.