[RCU] Fw: Cannot delete user...

Claudio Kuenzler napsty at gmail.com
Tue Jul 7 13:37:31 CEST 2009


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"


On Tue, Jul 7, 2009 at 1:15 PM, Glenn Seymour <glennsey at yahoo.co.uk> 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 (`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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/users/attachments/20090707/16944019/attachment-0001.html>
-------------- next part --------------
_______________________________________________
List info: http://lists.roundcube.net/users/


More information about the users mailing list