CiviCRM Community Forums (archive)

My installation says, and I have verified that, civicrm_acl_cache_contact is missing from the database tables. I have tried and tried to insert the following code into the database but I get an error every time:

CREATE TABLE IF NOT EXISTS `civicrm_acl_contact_cache` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `user_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact (could be null for anon user)',
  `contact_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contact',
  `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke') COLLATE utf8_unicode_ci NOT NULL COMMENT 'What operation does this user have permission on?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_user_contact_operation` (`user_id`,`contact_id`,`operation`),
  KEY `FK_civicrm_acl_contact_cache_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_acl_contact_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I have tried adding SET FOREIGN_KEY_CHECKS=0 before the code and 1 after the code but to no avail. Any ideas on how to fix my problem? This is a Drupal installation and I am getting errors all over the website because of it.

An empty results set has been returned - this is if I try an run a SQL query. If I try and upload it, I get:

{"redirectUrl":null,"reload":null,"refresh":true,"notifications":[{"type":"error","title":"Executing query failed","message":"Can't create table 'xxxxxxx_0.civicrm_acl_contact_cache' (errno: -1)  1005","code":"CREATE TABLE `civicrm_acl_contact_cache` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMEN...","options":false}],"data":{"error":true},"js":["sideBar.loadTables(\"xxxxxx_0\")"]}