I'm trying to figure out whether your table definitions or your data are at fault. Use the .schema command in the command line tool to dump the schema. Find the two tables * Services_Catalog * countries Questions: 1) Does that database actually use FOREIGN KEYs anywhere ? 2) Are both those tables shown in the schema ? 3) Does either of the two tables use a FOREIGN KEY to the other table ?