0

Error at the line 32266: ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Query: CREATE TABLE wp73_wc_download_log ( download_log_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, timestamp datetime NOT NULL, permission_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned DEFAULT NULL, user_ip_address varchar(100) COLLATE utf8mb4_general_ci DEFAULT '', PRIMARY KEY (download_log_id), KEY permission_id (permission_id), KEY timestamp (timestamp), CONSTRAINT fk_wp73_wc_download_log_permission_id FOREIGN KEY (permission_id) REFERENCES wp73_woocommerce_downloadable_product_permissions (permission_id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

MySQL: Can't create table wisetech_wp510.wp73_wc_download_log (errno: 150 "Foreign key constraint is incorrectly formed")

Please, this problem was generated in trying to import WordPress database into live server (phpmyadmin). Please, who knows what is wrong with the quoted line? Thanks

Shadow
  • 33,525
  • 10
  • 51
  • 64
Wisdom
  • 1

0 Answers0