CiviCRM Community Forums (archive)

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)

what does it mean ?

I'm getting the exact same error trying to move my database to a web server from my local machine.  In my case, I created a dump from MySQL on my machine (4.1.22) and got this error when I tried to import to data to MySQL on the server (5.0.45).  If I remove the lines for the same table as above, I get it on the next table, too.  This same SQL file has worked fine on other installations.

I'm using version 1.9 of CiviCRM.

Please update this post with the following:
* What version of CiviCRM are you using?
1.9

* Is this a new install? What file are you trying to load?
I's dump from my site in localhost. Everything was ok until I decided to load old version of my database. I drop my database and try
load database from backup and now I am in trouble.   

* What version of MySQL are you running?
5.0.45

A google search on that error returns the following page:
http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html

with this info:
"Cannot create table. If the error message refers to errno 150, table creation failed because a foreign key constraint was not correctly formed."

• I've read all the threads but still found no solution. Must of the topics about mysql 4.1 and index, syntax etc.  I don't have this problem because my version of mysql is 5.
  
• And I thing index, data, syntax of database is correct, because until I drop my database it works well.

I tried that and it's worked but it's strange.