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@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/

List info: http://lists.roundcube.net/users/