Displaying 1 result from an estimated 1 matches for "psyguideorg_development".
2006 Jun 21
1
Migration with foreign key won''t work
...When running it, everything goes well up to the foreign keys. I get the
following error:
-- add_foreign_key_constraint(:artists, :artist_type_id, :artist_types,
:artist_type, {:on_delete=>:restrict, :on_update=>:cascade})
rake aborted!
Mysql::Error: Can''t create table
''./psyguideorg_development/#sql-b0_14.frm'' (errno: 150): ALTER TABLE
artists ADD CONSTRAINT artists_ibfk_artist_type_id FOREIGN KEY
(artist_type_id) REFERENCES artist_types (artist_type) ON UPDATE CASCADE
ON DELETE RESTRICT
I can''t see where''s the problem... Can anybody help me, please?
Thanks...