That does not work for me. I get errors as I said in my post. The specific error is
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'. Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'. 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 ModuleDefinitions WHERE FriendlyName = 'Forum' INSERT INTO Permission(PermissionCode, ModuleDefID, PermissionKey, PermissionName) VALUES('FORUM_MODULE',@ModuleDefID,'FORUMADMIN','Forum Administrator') INSERT INTO Permission(PermissionCode, ModuleDefID, PermissionKey, PermissionName) VALUES('FORUM_MODULE',@ModuleDefID,'FORUMGLBMOD','Global Moderator')
Matthias Schlomann wrote
joiseystud
the answer is in the next post you have quote.