Upgrading from Classic Snitz to MVC Snitz

HuwR

HuwR

Forum Administrator
• 0 Comments

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.
If you are unable to run the SQL below, please post in the Forums before attempting the upgrade.

Code:

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
Here

Comments

type danger upgrade class install text href function j clang HAVE partial Content config web application subfolder use modal data javascript p btn CultureInfo name script file template folder hide require div view src main css snitz code FORUM_CONFIG_NEW true Database be window open Plugin a site Edit root load
Blog Archives
Categories