Paste #595618
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 170119 14:49:01 Error in foreign key constraint of table neutron/l2gatewayconnections: FOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, UNIQUE (l2_gateway_id, network_id) )ENGINE=InnoDB: Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint. Note that the internal storage type of ENUM and SET changed in tables created with >= InnoDB-4.1.12, and such columns in old tables cannot be referenced by such columns in new tables. See http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html for correct foreign key definition. |