Re: CakePHP2.0.1 - Problem with saving HABTM

I Have already checked, and all table are already well related. Same
column type INT(11) and InnoDB powered. But I still have the
problem... :S
What to do now? The code I am using works if I use cakephp1.3....

On 2 Nov, 17:51, Jeremy Burns <jeremybu...@me.com> wrote:
> Use InnoDB. As John says, it won't let you create RI between fields with different types (and it's very precise) and you get transactions thrwn in for good measure.
>
> On 2 Nov 2011, at 16:14, Jon Bennett wrote:
>
>
>
>
>
>
>
> >> I've had some similar trouble with 2.0
> >> turned out the fields in the DB were not the same type.
> >> id on one table was a bigint and the foreign key on the relationship table was a regular integer.
> >> atenciosamente,
>
> > With MySQL you can catch these errors at db schema level if you use
> > foreign key constraints, as you can't connect columns of different
> > types.
>
> > --
> > Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help others with their CakePHP related questions.
>
> > To unsubscribe from this group, send email to
> > cake-php+unsubscribe@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

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