cake-php@googlegroups.com
[Top] [All Lists]

SQL Error?

Subject: SQL Error?
From: Rodrigo Cortés
Date: Mon, 6 Sep 2010 08:09:40 -0700 PDT
Nice tool but i have a problem:

The app works fine on cakeapp but when i download the sql code and try
to execute it on my local server i get this error:

"consulta SQL:
ALTER TABLE  `torneos` ADD FOREIGN KEY ( id ) REFERENCES  `matchups`
(  `torneo_id` ) ;

MySQL ha dicho:
#1005 - Can't create table 'sc2la.#sql-84c_1f2' (errno: 150)"

this is my app:
http://cakeapp.com/sqldesigners/sql/roco3d

it seems that is trying to create a foreign key from a parent table
instead from a child.

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@xxxxxxxxxxxxxxxx
To unsubscribe from this group, send email to
cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

<Prev in Thread] Current Thread [Next in Thread>
  • SQL Error?, Rodrigo Cortés <=