Erro 256, foreign key constraint fails

This topic is locked

Erro 256, foreign key constraint fails	7/14/2011 4:58:10 PM
PHPRunner General questions
A Anderson author Hi I would like request your help, I developed a project in PHPRunner 5.3 with MySql, I did the bank related, when I delete any record that is already related to other appears this error: "Cannot delete or update a parent row: a foreign key constraint fails (`banco`.`tabela`, CONSTRAINT `fk_produtos_subcategorias` FOREIGN KEY (`id_moveis_subcategorias`) REFERENCES `moveis_subcategorias` (`id_moveis_subcategorias`) ON DELETE NO ACTION ON )." I would like to know how to treat this message and put another message. On the demo 3 on this site on the page "orders_list" have been made the examples that I want! http://livedemo.asprunner.net/phprunner/livedemo3/orders_list.php


	Sergey Kornilov admin 7/15/2011
	It looks like you trying to insert a value into a field that doesn't allow that i.e. into autoincrement field. I would suggest to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.