Problems with foreign key

Problems with foreign key

El Forum
Guest

05-14-2009, 05:19 PM

[eluser]DarthVinsus[/eluser]
Hello people, how can I solve this problem with codeigniter?

Code:
A Database Error Occurred

Error Number: 1451

Cannot delete or update a parent row: a foreign key constraint fails (`censo_ap`.`usuario`, CONSTRAINT `Refrol20` FOREIGN KEY (`rol_id`) REFERENCES `rol` (`rol_id`))

DELETE FROM `rol` WHERE `rol_id` = '2'

Messages In This Thread

Problems with foreign key - by El Forum - 05-14-2009, 05:19 PM

Problems with foreign key - by El Forum - 05-14-2009, 06:01 PM

Problems with foreign key - by El Forum - 05-15-2009, 02:18 AM

Problems with foreign key - by El Forum - 05-15-2009, 08:58 AM

Problems with foreign key - by El Forum - 05-15-2009, 09:10 AM

Problems with foreign key - by El Forum - 05-15-2009, 11:07 AM

Problems with foreign key - by El Forum - 05-15-2009, 12:20 PM

Problems with foreign key - by El Forum - 05-15-2009, 09:50 PM