If you are upgrading from Classic ASP version of Snitz, you SHOULD run the SQL script below against your forums database, this is to fix some inconsistencies found in some versions of the classic forum.
delete from FORUM_CONFIG_NEW where ID is null;
WITH CTE AS
(
SELECT *
,ROW_NUMBER() OVER
(PARTITION BY C_VARIABLE
ORDER BY C_VARIABLE,ID ASC
) AS RowNum
FROM FORUM_CONFIG_NEW
)
DELETE FROM CTE WHERE RowNum > 1 -- uncomment this row for the final DELETE
Alter Table dbo.FORUM_CONFIG_NEW Add Id_new Int Identity(1, 1)
Alter Table dbo.FORUM_CONFIG_NEW Drop Column ID
Exec sp_rename 'dbo.FORUM_CONFIG_NEW.Id_new', 'ID', 'Column'
ALTER TABLE dbo.FORUM_CONFIG_NEW ADD CONSTRAINT
PK_FORUM_CONFIG_NEW PRIMARY KEY CLUSTERED
(
ID
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
When you have run the above script. you can install the files using the instructions