How to delete a member

I have the same problem as lavalle. After we upgraded to version 9.0 the check box "delete member" is gone!

Please help!

Yes, there is no delete feature in the current version 9.0; having downloaded it 3 separate times.

I decided to go in to the (SQL Server) database and DELETE all rows in all TABLEs with that Author_ID.

I am in the process of writing an SQL script to task this; may post it later on.

--- UPDATE:

Here's the SQL Script (an SQL Server stored procedure...);
Pass it either the AuthorID or UserName.


CREATEPROCEDURE [dbo].prcAuthorDelete
(
    @authorID int = 0
    ,@Username nvarchar(25) = ''
)
AS

IF (@authorID < 1 AND @userName = '')
    RETURN -1

DECLARE @count int

IF (@authorID > 0)
BEGIN
    SELECT @count = count(*)
    FROM tblAuthor
    WHERE Author_ID = @authorID

    IF (@count <> 1)
        RETURN -1
END

IF (@Username <> '')
BEGIN
    SELECT @count = count(*)
        FROM tblAuthor
        WHERE Username = @Username

    IF (@count <> 1)
        RETURN -1
    ELSE
        SELECT @authorID = Author_ID
            FROM tblAuthor
            WHERE Username = @Username
END

IF (@authorID < 1)
    RETURN -1


DELETE FROM tblThread
WHERE Author_ID = @authorID


DELETE FROM tblPollVote
WHERE Author_ID = @authorID


DELETE FROM tblPollVote
WHERE Author_ID = @authorID

DELETE FROM tblPollVote
WHERE Author_ID = @authorID


DELETE FROM tblPMMessage
WHERE Author_ID = @authorID


DELETE FROM tblPermissions
WHERE Author_ID = @authorID


DELETE FROM tblEmailNotify
WHERE Author_ID = @authorID


DELETE FROM tblBuddyList
WHERE Author_ID = @authorID


DELETE FROM tblAuthor
WHERE Author_ID = @authorID


RETURN 0
GO




Edited by macspudster - 25 July 2007 at 8:51pm

Nick-V wrote: Sounds dangerous to me !!! It works on my database...I'd wait for a proper fix if I were you.

I tell the way to do it on the first page