Author Topic: Database Error Code: Can't create table 'civicrm_acl_contact_cache' (Read 770 times)

heimer16 · November 07, 2011, 08:28:30 am

Hi, I'm upgrading civicrm 3.0 to 3.4 on Joomla 1.5 and updating the database, I get this error:

Database Error Code: Can't create table 'civicrm_acl_contact_cache' (errno: 150), 1005
after doing just a little bit if searching it seems this might have something to do with foreign key constraints?
Any help would be appreciated. Thanks

Hershel · November 07, 2011, 11:08:55 am

Yes, the error code 1005 would indicate that: http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html

It's hard to know exactly what the problem is, but it sounds like your 3.0 DB may be missing an index somewhere. Was this site upgraded previously?

One approach to try to get the keys right is to install the same version (3.0 in your case) on a fresh database, then dump just the structure of that DB and the data of your "real" database and then import both of those dumps into a fresh DB. Then try running the upgrade using this DB you just made.

CiviCRM Community Forums (archive)

News:

Author Topic: Database Error Code: Can't create table 'civicrm_acl_contact_cache' (Read 770 times)

heimer16

Database Error Code: Can't create table 'civicrm_acl_contact_cache'

Hershel

Re: Database Error Code: Can't create table 'civicrm_acl_contact_cache'