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' #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) any help appreciated. thanks
