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 (Moderator: Dave Greenberg) »
  • log.* tables Can I delete them? [SOLVED]
Pages: [1]

Author Topic: log.* tables Can I delete them? [SOLVED]  (Read 1535 times)

FrTommy

  • I post frequently
  • ***
  • Posts: 273
  • Karma: 2
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5.32
  • PHP version: 5.3
log.* tables Can I delete them? [SOLVED]
September 09, 2012, 12:23:10 pm
I upgraded to 4.2. Love it so far. but I've ran into a problem. All of a sudden when I create a new contact or event or event template I get an error "DB ERROR: field not found"  I tacked it down and found that it had to do with the logging tables not all being present or missing some fields. If i turn Logging off under the Logging Recaptcha Cache menu item everything works fine with no errors.

My question is this: If I delete (DROP) all the log.* tables then re-enable the logging function will Civi recreate the log.* tables?

I understand I'll lost any history that's contained in the tables and I'm ok with that. I just want to make sure that deleting them and then re-enabling logging will trigger Civi to rebuild the log.* tables fresh so the logging will work again.

« Last Edit: September 11, 2012, 06:07:34 pm by FrTommy »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: log.* tables Can I delete them?
September 10, 2012, 06:54:17 am
Quote from: FrTommy on September 09, 2012, 12:23:10 pm
My question is this: If I delete (DROP) all the log.* tables then re-enable the logging function will Civi recreate the log.* tables?

It should AFAIK. Just make a backup in case.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

FrTommy

  • I post frequently
  • ***
  • Posts: 273
  • Karma: 2
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5.32
  • PHP version: 5.3
Re: log.* tables Can I delete them?
September 10, 2012, 02:53:32 pm
So I dropped all the log.* tables from the db (yes I made a backup, but doesnt' really matter cuz that backup doesn't work either).

I re-enabled logging, clicked save and got a Syntax error. It created maybe 10 log tables. I deleted those and attempted again and got the same error. It created a round 10 log tables (it didnt stop on the stop table, it was a different one)

So I'm just disabling logging for now. May be a bug in the enabling logging for 4.2......

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: log.* tables Can I delete them?
September 11, 2012, 01:47:32 pm
Wondering if you disabled Logging prior to running the 4.2 upgrade? Looking at the code, it seems like it "forces" you to do that (which is a good thing).

In any case - we think that what you did (drop tables and then re-enable Logging) "should" work. What was the syntax error(s) you got during that process? We're a bit suspicious that there might be a PHP timeout issue preventing all the log tables from being created - but I don't think that would cause a syntax error ???
Protect your investment in CiviCRM by  becoming a Member!

FrTommy

  • I post frequently
  • ***
  • Posts: 273
  • Karma: 2
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5.32
  • PHP version: 5.3
Re: log.* tables Can I delete them? [SOLVED]
September 11, 2012, 06:06:49 pm
I was able to find the issue. I enabled the backtrace and debugging and it told me it was from the cdntaxreceipts module I had installed and tested. The table was still in the db but i no longer use the module. I dropped that table and re-enabled the logging and it's working properly now.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • log.* tables Can I delete them? [SOLVED]

This forum was archived on 2017-11-26.