Glenn Seymour wrote:
How does one delete a user from the databases via PHPmyadmin?
I get the following error...
MySQL said: #1451 - Cannot delete or update a parent row: a foreign key
constraint fails
http://bugs.mysql.com/bug.php?id=46293
--
Aleksander 'A.L.E.C' Machniak
How does one delete a user from the databases via PHPmyadmin?
I get the following error...
MySQL said: #1451 - Cannot delete or update a parent row: a foreign key
constraint fails (`roundcubemail/cache`, CONSTRAINT `user_id_fk_cache` FOREIGN
KEY (`user_id`) REFERENCES `users` (`user_id`))
Get the User_ID for the user you want to delete ... for example 49
then
- go to table cache. Delete all entries corresponding to user_id=49
- go to table contacts. Delete all entries corresponding to user_id=49
- go to table identities. Delete all entries corresponding to user_id=49
- go to table