1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Cleanly remove a user via SQL?

Discussion in 'Troubleshooting and Problems' started by Beanjam, Jan 25, 2016.

  1. Beanjam

    Beanjam Active Member

    I have a user I created today for testing and want to delete it but nothing happens. I can't edit anything or delete it. The little progress thing in the top right pops up for a second and disappears.

    No problem editing other users, so I have no idea what's happening here and just want to kill it off.

    What SQL can I use to kill all trace of it? The user does not have any content etc as I've only been using it to test group permissions.
  2. melbo

    melbo Well-Known Member

    Not sure but it really seems like you might have some upload and install problems (considering your earlier css issues). I've not encountered this so don't really know how to help you troubleshoot. If you can delete user A you should be able to delete user B unless B is admin protected. if the user you are trying to delete is an admin, drop them from admin and try again.
  3. Beanjam

    Beanjam Active Member

    I ended up deleting the user from these tables:


    I hope that's all I need to do.

    They weren't an admin so no idea what what was happening, first time I've seen that.
  4. Tracy Perry

    Tracy Perry Well-Known Member

    Hopefully you took a DB backup. It is NOT recommended to delete users directly from the DB as there are many other tables that inter-relate with them. You should have submitted a ticket and had the Dev's check out the issue because that is NOT normal and you probably have something else going on.
  5. Beanjam

    Beanjam Active Member

    Yes, I have a backup.. and Melbo this is a different forum to that other one I posted about.

    There shouldn't be much interrelating going on as it was a fresh user.

Share This Page