10 Jun
2009
10 Jun
'09
4:21 a.m.
If we look at the message again, (`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) And put it into words: The contrainst names fs_lcr/lcr affecting field carrier_id, and referencing the id field of the carriers table, fails. In other words, the value you have for carrier_id does not match any value of id in the carriers table. Math On 10-Jun-09, at 12:13 AM, Diego Viola wrote:
(`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)