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) »
  • question about change logging
Pages: [1]

Author Topic: question about change logging  (Read 579 times)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
question about change logging
October 22, 2012, 05:50:10 pm
I have turned on the logging feature in a test environment and am inspecting the new log tables to monitor what is being changed.  I have already read the docs at: http://wiki.civicrm.org/confluence/pages/viewpage.action?pageId=74842410  but I have some questions.

- I changed a number of contact records, such as changing basic fields like first name, etc. But I do not see any change records in the log file " log_civicrm_contact" The only records I see there are of type "initialization"

- Should I expect to see the before and after values of first name? Or whatever field I changed?
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: question about change logging
October 22, 2012, 05:52:53 pm
Sarah,

You should see the old and new values of first name.  Note that I've found that in-line editing doesn't always trigger a log entry; I haven't tested extensively to figure out why.  So when testing, it's best to edit a record using the "Edit" button.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

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: question about change logging
October 22, 2012, 08:30:40 pm

thats a bit wierd and surprising, since all the logging is done at the mysql level via triggers

changes were made in 4.2 (or 4.3, not sure) to avoid recording a log entry if there was no change in the data.

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

awasson

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 7
  • Living in a world of Drupal / CiviCRM
    • My Company: Luna Design
  • CiviCRM version: Latest
  • CMS version: Drupal 6/7/8
  • MySQL version: 5.x
  • PHP version: 5.3.x
Re: question about change logging
October 24, 2012, 01:21:54 pm
Not to hijack this thread but on the topic of the Change Logs, I have several civiCRM 3.x and civiCRM 4.x installations; when I view a contact's change log, only the date and name of whoever made the change is posted. How does one add the fields to see what change was made?

Andrew
My CiviCRM Extension Workshop: https://github.com/awasson

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: question about change logging
October 24, 2012, 02:21:48 pm

For full DB logging, u need to have logging enabled. this create a whole new set of mirror tables adn uses triggers to record all changes etc

Would definitely upgrade to 4.2 for this when we worked on it a fair bit for NYSS

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

awasson

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 7
  • Living in a world of Drupal / CiviCRM
    • My Company: Luna Design
  • CiviCRM version: Latest
  • CMS version: Drupal 6/7/8
  • MySQL version: 5.x
  • PHP version: 5.3.x
Re: question about change logging
October 24, 2012, 02:24:51 pm
Ah, ok... That's what I thought. The problem there is that unless I'm mistaken I'll loose any changes that occur prior to switching it on. Not a big deal I suppose as I can't use the info anyway.

I'll have a look at the update process and move them along as soon as I can.

Thanks,
Andrew
My CiviCRM Extension Workshop: https://github.com/awasson
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • question about change logging

This forum was archived on 2017-11-26.