On Friday 03 November 2006 10:45, Tom Brown wrote:

I found the user record in the mwuser table. Is it possible to delete this record without causing problems elsewhere in the application?

I got some help from #mediawiki. As long as the user has not created any edits, it is safe to delete the user. This worked out great for me 'cause this was just a test user. So, I was able to delete the user without a problem.

Thanks, Tom

PS: I'd still like to know if the failed blocking a user using a username is known bug or not.

Tom Brown wrote:

I created a user that I now want to remove. The FAQ says I cannot delete a user (why?) but I can block the user. So, I tried to block the user and got this error:

Query failed: ERROR: invalid input syntax for type cidr

I entered a username instead of an ip address to block. The username was used in place of the ip address and the php code tried to put the username into the ipb_address field of the ipblocks table which, is of type cidr. So, the insert fails. Any ideas on fixing this? I did not see a bug for this in bugzilla. It is a postgresql backend, if that makes a difference.

Looks like the postgres schema is wrong, so it won't work.

I found the user record in the mwuser table. Is it possible to delete this record without causing problems elsewhere in the application?

Maybe, maybe not. Try it and see.

-- brion vibber (brion @ pobox.com)