Re: ERROR 1005: Can't create table (errno: 150)

[Andrey Svitlow]

I have problem with load mysql dump of my site to another site.
Can anyone please suggest a solution?
Mysql 5.0.45-community-nt on Windows

Query:
CREATE TABLE `civicrm_acl` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique table ID',
`domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain owns this contact',
`name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'ACL Name.',
`deny` tinyint(4) NOT NULL default '0' COMMENT 'Is this ACL entry Allow (0) or Deny (1) ?',
`entity_table` varchar(64) collate utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
`entity_id` int(10) unsigned default NULL COMMENT 'ID of the object possessing this ACL',
`operation` enum('All','View','Edit','Create','Delete','Grant','Revoke') collate utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
`object_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The table of the object controlled by this ACL entry',
`object_id` int(10) unsigned default NULL COMMENT 'The ID of the object controlled by this ACL entry',
`acl_table` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
`acl_id` int(10) unsigned default NULL COMMENT 'ID of the ACL or ACL group being granted/revoked',
`is_active` tinyint(4) default NULL COMMENT 'Is this property active?',
PRIMARY KEY (`id`),
KEY `index_acl_id` (`acl_id`),
KEY `FK_civicrm_acl_domain_id` (`domain_id`),
CONSTRAINT `FK_civicrm_acl_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Error occured at:2008-01-12 13:39:30
Line no.:32
Error Code: 1005 - Can't create table '.\site\civicrm_acl.frm' (errno: 150)


CREATE TABLE `civicrm_domain` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Domain ID',
`name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Name of Domain / Organization',
`description` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Description of Domain.',
`email_name` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'The default email name that is used in the from address for all outgoing emails',
`email_address` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'The default email address that is used as the from address for all outgoing emails',
`email_domain` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The domain from which outgoing email for this domain will appear to originate',
`email_return_path` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The domain from which outgoing email for this domain will appear to originate',
`config_backend` text collate utf8_unicode_ci COMMENT 'Backend configuration.',
`config_frontend` text collate utf8_unicode_ci COMMENT 'Frontend configuration.',
PRIMARY KEY (`id`),
UNIQUE KEY `UI_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



Edited 2 time(s). Last edit at 01/12/2008 06:15AM by Andrey Svitlow.