CiviCRM Community Forums (archive)

L.S>,

When I try to import a databse extract of a Joomla website that uses CiviCRM 2.2.7, PhpMyadmin returns the following error:

SQL-query:

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` ) ,
CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY ( `contact_id` ) REFERENCES `civicrm_contact` ( `id` ) ON DELETE CASCADE ,
CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY ( `acl_id` ) REFERENCES `civicrm_acl` ( `id` ) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;

MySQL retourneerde: Documentatie
#1005 - Can't create table 'EXAMPLE_NAME.civicrm_acl_cache' (errno: 150) (<a href="server_engines.php?engine=InnoDB&amp;page=Status&amp;token=b692474db454eb54cf6a4bcde86e4e5d">Details...</a>)

This also happenened when I wanted to transfer a site from an online testing domain to a live domain. Can anyone please help me out with this?

There is no full error text other than the image I posted below:

(http://www.woosh.nl/images/temp/phpmyadmin.png)

The strange thing is that, when I exclude the CiviCRM tables from the database dump, the installation runs smoothly. Apparantly there is something in the CiviCRM-tables that cause this error. Googling the error line didn't give any results.