Cant import into table because of the foreign key
Posted: 13. November 2015 10:12I receive this error when i try to insert into my table.
When i delete the foreign key and make it again the error is moved to next constraint. This is strange and i think it is not normal. What you think?
I use: XAMPP 1.8.1 [PHP: 5.4.7]
Query failed: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`erp`.`info_query`, CONSTRAINT `info_query_ibfk_10` FOREIGN KEY (`ime_potrebitel`) REFERENCES `users` (`uid`))
When i delete the foreign key and make it again the error is moved to next constraint. This is strange and i think it is not normal. What you think?
I use: XAMPP 1.8.1 [PHP: 5.4.7]