MySQL Forums
Forum List  »  InnoDB

Re: mysql error code:150
Posted by: Noah Goodrich
Date: December 21, 2007 11:34PM

Gavy,

Verify the data types that you have assigned the suburb_id field in both the suburb and the properties_details tables.

Most likely you have mismatched data types. For example:

CREATE TABLE suburb (
suburb_id int(10) signed PRIMARY KEY auto_increment
)

CREATE TABLE properties_details (
suburb_id mediumint(11) unsigned,
FOREIGN_KEY (suburb_id) REFERENCES suburb(suburb_id)
)

Any of the three mismatched I demostrated (length, specific type, or signed vs. unsigned) could cause your problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
20597
December 13, 2007 01:18AM
Re: mysql error code:150
9078
December 21, 2007 11:34PM
6110
May 15, 2008 07:40AM
6150
August 29, 2008 07:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.