Author Topic: Problem with duplicate contacts and civicrm_acl_cache table (missing) (Read 2100 times)

jeff porter · May 29, 2008, 09:22:14 pm

Duplicate contacts query (which takes a little over 7 minutes to run for 5,100 contacts btw) is now no longer working when you try to merge contacts. Looks like a table is missing? (confirmed that it does not exist in the db). Any thoughts?

------------
Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => UPDATE IGNORE civicrm_acl_cache SET contact_id = 13 WHERE contact_id = 5227 [nativecode=1146 ** Table 'fpwr_civicrm20.civicrm_acl_cache' doesn't exist]
    [type] => DB_Error
    [user_info] => UPDATE IGNORE civicrm_acl_cache SET contact_id = 13 WHERE contact_id = 5227 [nativecode=1146 ** Table 'fpwr_civicrm20.civicrm_acl_cache' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE IGNORE civicrm_acl_cache SET contact_id = 13 WHERE contact_id = 5227 [nativecode=1146 ** Table 'fpwr_civicrm20.civicrm_acl_cache' doesn't exist]"]
)

Matt2000 · May 30, 2008, 01:29:12 pm

Since it's a cache table, it's ok to be empty. You can simply recreate it. Here's the definition for 2.0 :

Code: [Select]

CREATE TABLE `civicrm_acl_cache` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID',
  `contact_id` int(10) unsigned default NULL COMMENT 'Foreign Key to Contact',
  `acl_id` int(10) unsigned NOT NULL COMMENT 'Foreign Key to ACL',
  `modified_date` date default NULL COMMENT 'When was this cache entry last modified',
  PRIMARY KEY  (`id`),
  KEY `index_acl_id` (`acl_id`),
  KEY `FK_civicrm_acl_cache_contact_id` (`contact_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;

jeff porter · May 30, 2008, 05:26:47 pm

Thanks for your help - i recreated it no problem - just curious how it got deleted...

Matt2000 · May 30, 2008, 05:30:17 pm

Various documentation will instruct you to TRUNCATE this table as a troubleshooting step. Perhaps you accidentally DROP 'ed it once instead?

CiviCRM Community Forums (archive)

News:

Author Topic: Problem with duplicate contacts and civicrm_acl_cache table (missing) (Read 2100 times)

jeff porter

Problem with duplicate contacts and civicrm_acl_cache table (missing)

Matt2000

Re: Problem with duplicate contacts and civicrm_acl_cache table (missing)

jeff porter

Re: Problem with duplicate contacts and civicrm_acl_cache table (missing)

Matt2000

Re: Problem with duplicate contacts and civicrm_acl_cache table (missing)