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 "messages". Delete all entries corresponding to user_id=49
now you should be able to delete the user with user_id 49 from the table "users"
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`))
And I cannot get around it!!
please help!
_______________________________________________
List info: http://lists.roundcube.net/users/