CiviCRM Community Forums (archive)

I've installed the latest CiviCRM with Joomla, and am just testing it so far, barely using it at all.  I've twice had problems with extra tables created and having our hosting company suspend our account because we've exceeded our table usage limit.

The first time it happened, I immediately removed all CiviCRM tables to get our site back online, and assumed the extra tables came from enabling logging.

I reinstalled CiviCRM, enabled logging again, and checked the table count, and it was still reasonable for a few days.

Overnight, the table count ballooned again, and the account was suspended again.  In the list of tables shown by the host at the time of their scan, each civicrm_ table has three extra associated tables:

civicrm_acl   123.84 KB
civicrm_acl_after_delete   0.04 KB
civicrm_acl_after_insert   0.04 KB
civicrm_acl_after_update   0.04 KB

But by the time I logged in to phpmyadmin to resolve the issue, those extra tables were gone.

I haven't set up any cron jobs yet, and I can't think of anything I did through the admin interface to trigger those tables to temporarily show up overnight, but disappear by the time I logged in.  Does anyone know what's going on?  This is a serious problem for us.  Thanks for any help!

Aha, that makes sense!

Are the triggers created only when logging is enabled?

Thanks so much!