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 CiviMember (Moderator: Deepak Srivastava) »
  • OK to clear civicrm_membership_log table?
Pages: [1]

Author Topic: OK to clear civicrm_membership_log table?  (Read 1096 times)

anton

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
OK to clear civicrm_membership_log table?
July 29, 2010, 08:28:50 am
I'm a victim of this bug:

http://issues.civicrm.org/jira/browse/CRM-6125

It caused my civicrm_membership_log table to reach a massive 195MB (2.4 million rows).

Upgraded to v3.2.0 yesterday so this bug is fixed.

Looking through it it seems like there's no crucial data kept in it - would it be OK to just clear it (keeping the table structure in tact of course) without losing membership info and renewal data etc? Or is there important info kept in it?

TIA...

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: OK to clear civicrm_membership_log table?
July 29, 2010, 10:31:01 am
You will loose the change history of memberships. Main membership data and payment data is kept in separate tables.

Kurund
Found this reply helpful? Support CiviCRM

anton

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
Re: OK to clear civicrm_membership_log table?
July 29, 2010, 10:38:39 am
Thanks Kurund.

So only if the membership has been edited I will lose that data?

Alternatively, do you know of a query I can run on the database to find (in order to delete) all the meaningless entries?

Thanks!

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: OK to clear civicrm_membership_log table?
July 29, 2010, 10:59:15 am
Quote
So only if the membership has been edited I will lose that data?
Yes

Quote
Alternatively, do you know of a query I can run on the database to find (in order to delete) all the meaningless entries?
All the log entries are linked to membership record. So I think it is not possible to find meaningless entries.

Kurund
Found this reply helpful? Support CiviCRM

anton

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
Re: OK to clear civicrm_membership_log table?
July 29, 2010, 11:09:58 am
Thanks Kurund!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • OK to clear civicrm_membership_log table?

This forum was archived on 2017-11-26.