2011/11/06 13:56 +1000, Edward avanti
#1451 - Cannot delete or update a parent row: a foreign key constraint
fails (`vmail`.`domain_admins`, CONSTRAINT `domain_admins_ibfk_1` FOREIGN
KEY (`domain_id`) REFERENCES `virtual_domains` (`id`) ON DELETE CASCADE)
In table domain_admins
We have aded an internal domain, its assigned the latest id ( 20433), we
have safeguards in our portal that stop domains with id less than 5 from
being deleted, the table doesnt show "3" so it is not used, but when I try
alter the table it fails:
update virtual_domains set id='3' where id='20433'
