When I try to run the script in the pinned thread "Lists Error Fix - Advanced Hosts Only!" I get this error:
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'dbo.Lists'. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DECLARE @ModuleDefID int SELECT @ModuleDefID = ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Forum' IF @ModuleDefID > 0 BEGIN DELETE FROM dbo.Lists WHERE DefinitionID = @ModuleDefId END DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'ThreadStatus' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'Emailformat' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'GroupView' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'ForumMemberName' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'ForumThreadRate' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'TrackingDuration' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'DisplayPosterLocation' DELETE FROM dbo.Lists WHERE DefinitionID = 0 AND ListName = 'ForumType' INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ThreadStatus', '0', 'NoneSpecified', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ThreadStatus', '1', 'Unanswered', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ThreadStatus', '2', 'Answered', 0, 0, 3, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ThreadStatus', '3', 'Informative', 0, 0, 4, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('Emailformat', '0', 'Text', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('Emailformat', '1', 'HTML', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('GroupView', '0', 'AllExpanded', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('GroupView', '-1', 'AllCollapsed', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('GroupView', '1', 'AsLastViewed', 0, 0, 3, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumMemberName', '0', 'Username', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumMemberName', '1', 'DisplayName', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '0', 'Rate0', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '1', 'Rate1', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '2', 'Rate2', 0, 0, 3, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '3', 'Rate3', 0, 0, 4, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '4', 'Rate4', 0, 0, 5, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '5', 'Rate5', 0, 0, 6, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '6', 'Rate6', 0, 0, 7, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '7', 'Rate7', 0, 0, 8, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '8', 'Rate8', 0, 0, 9, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '9', 'Rate9', 0, 0, 10, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumThreadRate', '10', 'Rate10', 0, 0, 11, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '0', 'Today', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '3', 'PastThreeDays', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '7', 'PastWeek', 0, 0, 3, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '14', 'PastTwoWeek', 0, 0, 4, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '30', 'PastMonth', 0, 0, 5, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '92', 'PastThreeMonth', 0, 0, 6, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '365', 'PastYear', 0, 0, 7, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '-1', 'LastVisit', 0, 0, 8, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('TrackingDuration', '3650', 'AllDays', 0, 0, 9, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('DisplayPosterLocation', '0', 'None', 0, 0, 0, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('DisplayPosterLocation', '1', 'ToAdmin', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('DisplayPosterLocation', '2', 'ToAll', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumType', '0', 'Normal', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumType', '1', 'Notification', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumType', '2', 'Link', 0, 0, 3, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '0', 'PublicModerated', 0, 0, 1, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '1', 'PublicModeratedPostRestricted', 0, 0, 2, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '2', 'PublicUnModerated', 0, 0, 3, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '3', 'PublicUnModeratedPostRestricted', 0, 0, 4, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '4', 'PrivateModerated', 0, 0, 5, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '5', 'PrivateModeratedPostRestricted', 0, 0, 6, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '6', 'PrivateUnModerated', 0, 0, 7, @ModuleDefId) INSERT INTO dbo.Lists (ListName, Value, Text, ParentID, Level, SortOrder, DefinitionID) VALUES ('ForumBehavior', '7', 'PrivateUnModeratedPostRestricted', 0, 0, 8, @ModuleDefId)
am I doing something worng? also I have SQL server access is there a SQL script that I can run on the server?
Thanks in advance
Melih