This might help to restore your database:
Just go to this post:
http://forum.yetanotherf...from-Godaddy-users.aspx

and replace your the changed code. It just restores your previous database.
Try new, have fun!

Just to verify for other people, the first post does indeed work. I had a problem when I changed my password on the database to gain access to it (as I forgot it), the forum went down. If this happens, just update the yafnet.config file with the new password (or just look in the original one to see what the password is before you access the database). I changed out the code with the code from the first post. There was a "GO" at the end and I left that in (don't know if that makes a difference). I waited about a hour and the "Most users online" is now working. I also test registered a new user (because some people were having that problem) successfully. Thanks!!!

OK - after restoring to an older database and losing lots of posts - I figured I'd put my "working" code here in case someone needs it! In the first line, put your database name where the ------------ are.



USE [--------------]
GO

/****** Object: Trigger [yaf_Active_insert] Script Date: 11/25/2008 18:52:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER yaf_Active_insert
ON dbo.yaf_Active
FOR INSERT
AS
BEGIN
DECLARE @BoardID INT,
@count INT,
@countStr NVARCHAR(255),
@dtStr NVARCHAR(255),
@max INT,
@maxStr NVARCHAR(255)
-- Assumes only one row was inserted - shouldn't be a problem?
SELECT @BoardID = BoardID
FROM inserted
SELECT @count = COUNT(DISTINCT IP)
FROM yaf_Active WITH (nolock)
WHERE BoardID = @BoardID
SELECT @maxStr = CAST(VALUE AS NVARCHAR)
FROM yaf_Registry
WHERE BoardID = @BoardID
AND Name = N'maxusers'
SELECT @max = CAST(@maxStr AS INT)
SELECT @countStr = CAST(@count AS NVARCHAR)
SELECT @dtStr = CONVERT(NVARCHAR,Getdate(),126)
IF @@ROWCOUNT = 0
BEGIN
INSERT INTO yaf_Registry
(BoardID,
Name,
VALUE)
VALUES (@BoardID,
N'maxusers',
CAST(@countStr AS NTEXT))
INSERT INTO yaf_Registry
(BoardID,
Name,
VALUE)
VALUES (@BoardID,
N'maxuserswhen',
CAST(@dtStr AS NTEXT))
END
ELSE
IF @count > @max
BEGIN
UPDATE yaf_Registry
SET VALUE = CAST(@countStr AS NTEXT)
WHERE BoardID = @BoardID
AND Name = N'maxusers'
UPDATE yaf_Registry
SET VALUE = CAST(@dtStr AS NTEXT)
WHERE BoardID = @BoardID
AND Name = N'maxuserswhen'
END
END
GO

Anyone home?

Funny - about 4 hours later - it started working!

THANKS SO MUCH for ALL of your help!

It's been fun talking to myself!!!!!