sqlite has no runtime referencial integrity checks, hence you don't get the error. Mysql points out that there is a referential integrity issue in the database.
2013/1/4 samuel bonilla <[email protected]> > I'm developing an application based in movuca ( > https://github.com/rochacbruno/Movuca) with sqlite works fine, but when I > use mysql generates this error .. > > I'm doing something wrong? > > > El jueves, 3 de enero de 2013 20:30:53 UTC-5, samuel bonilla escribió: > >> this is the error >> >> <class '_mysql_exceptions.**IntegrityError'> (1452, 'Cannot add or >> update a child row: a foreign key constraint fails (`samuel$otra`.`article_ >> **category`, CONSTRAINT `article_category_ibfk_1` FOREIGN KEY >> (`parent_id`) REFERENCES `article_category` (`id`) ON DELETE CASCADE)') >> >> help me please.... >> > -- > > > > --
