Skip to Main Content

MYSQL ERROR 1005: Can't create table (errno: 150) :: InnoDB

Both tables must be INNODB. The foreign key field must have an index. The foreign key field and the field being referenced must be of the same type. If fields are integer (typical) they must be unsigned.

Most RecentRSS

ArchiveRSS

March 2016 (1)
January 2016 (1)
September 2015 (1)
May 2015 (1)
April 2015 (1)
March 2015 (1)
February 2015 (2)
January 2015 (5)
September 2014 (2)
August 2014 (4)
July 2014 (1)
March 2014 (1)
November 2013 (3)
September 2013 (3)
July 2013 (6)
June 2013 (1)
May 2013 (1)
March 2013 (2)
February 2013 (3)
January 2013 (4)