Re: SQL Error Help

When you defined the tables, did you create a referental constraint
between the profiles and users tables?

Or maybe try to look in to the MySQL database "information_schema" in
the table "REFERENTIAL_CONSTRAINTS" for your constraint
"designers_ibfk_1" and see what the definition there tell you.

Then tell us what you got :)
Enjoy,
John

On Jan 3, 8:56 pm, "Dave" <make.cake.b...@gmail.com> wrote:
> 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en