Sebastian:
I renamed the skin and container and they did default to the minimal one. The icons where there so I guess I need to track that down in Telerik. I also tried to access the modules that were not working or available before and they still all crashed or were not there.
So I then moved on to the log. Although I did not get any failures on the update page, I did have one pretty big log on the 5.00.01.log. But the previous and subsequent log files were empty. Here is about 25% of the log file starting at the top. I didn't want to just dump it all at once. Let me know if you have any suggestions.
System.Data.SqlClient.SqlException: There is already an object named 'GetPermissionsByFolder' in the database.
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)
CREATE PROCEDURE dbo.GetPermissionsByFolder
AS
SELECT PermissionID,
PermissionCode,
PermissionKey,
PermissionName
FROM dbo.Permission
WHERE PermissionCode = 'SYSTEM_FOLDER'
ORDER BY PermissionID
System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.GetPermissionsByTabID', because it does not exist or you do not have permission.
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)
/* Update GetPermissionsByTab Procedure */
/****************************************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[GetPermissionsByTabID]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
DROP PROCEDURE dbo.GetPermissionsByTabID
System.Data.SqlClient.SqlException: There is already an object named 'vw_SearchItems' in the database.
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)
CREATE VIEW dbo.[vw_SearchItems]
AS
SELECT
si.SearchItemID,
m.PortalID,
tm.TabID,
m.ModuleID,
si.Title,
si.Description,
si.Author,
si.PubDate,
si.SearchKey,
si.Guid,
si.HitCount,
si.ImageFileId,
u.DisplayName AS 'AuthorName'
FROM dbo.SearchItem AS si
LEFT OUTER JOIN dbo.Users AS u ON si.Author = u.UserID
INNER JOIN dbo.Modules AS m ON si.ModuleId = m.ModuleID
INNER JOIN dbo.TabModules AS tm ON m.ModuleID = tm.ModuleID
System.Data.SqlClient.SqlException: There is already an object named 'UpdateServer' in the database.
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)
CREATE PROCEDURE dbo.UpdateServer
@ServerName nvarchar(50),
@CreatedDate datetime,
@LastActivityDate datetime
AS
DECLARE @ServerID int
SET @ServerID = (SELECT ServerID FROM dbo.WebServers WHERE ServerName = @ServerName)
IF @ServerID IS NULL
BEGIN
-- Insert
INSERT INTO dbo.WebServers (
ServerName,
CreatedDate,
LastActivityDate
)
VALUES (
@ServerName,
@CreatedDate,
@LastActivityDate
)
END
ELSE
BEGIN
-- Update
UPDATE dbo.WebServers
SET LastActivityDate = @LastActivityDate
WHERE ServerName = @ServerName
END