I am getting this error when creating a new User Error: 1452: Cannot add or update a child row: a foreign key constraint fails (`dev_table/profiles`, CONSTRAINT `designers_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION) Query: INSERT INTO `profiles` (`type`, `id`, `modified`, `created`) VALUES (1, '4b40e490-c524-43a0-9407-058c4adcd75b', '2010-01-03 11:40:16', '2010-01-03 11:40:16')
My profiles table is linked to my User->id so when I delete a user it drops their profile too thru the db, not using cakes cascads anywhere in the site. All my models have 'dependent' => false There is no designers??? Relationship. I checked my table relations and no such name exists,I have no model Designer. Not sure where this relationship is coming from. Any ideas where to look? I know there is not much info for anyone to go on but I don't know where to look to even find this designers_ibfk_1 since its not even a key in the sql db. Thanks, Dave Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
