Ok... Network Solutions finally got me back up last Friday 1/29. Their issues are ongoing so I have given them a few more days to work out their problems before attempting the upgrade again.
This morning, after performing manual backups, I performed the 4.8.3 to 4.9.5 upgrade without incident. I spent quite a bit of time examining my sites after the upgrade and all looked very well.
Then I got brave enough to attempt the 4.9.5 to 5.2.2 jump again. I performed all manual backups again and kicked off the 5.2.2 upgrade....
Same exact problems as before... VERY FRUSTRATING. My symptoms are the same... missing modules, cannot access modules definition admin page, cannot access skins admin page, cannot access languages admin page.
Only good news this time is that I have actual errors in the log. The following are the errors as reported in the upgrade log DURING the upgrade:
05.01.00 Error
05.02.00 Error
FileModuleCachingProvider_05.02.01_Install
MemoryModuleCachingProvider_05.02.01_Install
I believe that the module caching errors were due to missing web.config entries and I am fairly confident that I have taken care of those. Here are the entries in the upgrade log...
___________________________________________________
05.01.00
System.Data.SqlClient.SqlException: The transaction log for database 'troylampley' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
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)
/* Change primary key of EventLog Table */
/****************************************/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
BEGIN
--Note this name does NOT have an object qualifier in 4.x upgrades
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
--Note this name does have an object qualifier in 5.x installs
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
--Some scenarios have the primary key as PK_EventLog
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLog'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLog
ALTER TABLE dbo.EventLog
ADD LogEventID bigint NOT NULL IDENTITY (1, 1)
ALTER TABLE dbo.EventLog
ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END
___________________________________________________
05.02.00
System.Data.SqlClient.SqlException: Invalid column name 'LogEventID'.
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.PurgeEventLog
AS
;WITH logcounts AS
(
SELECT
LogEventID,
LogConfigID,
ROW_NUMBER() OVER(PARTITION BY LogConfigID ORDER BY LogCreateDate DESC) AS logEventSequence
FROM dbo.EventLog
)
DELETE dbo.EventLog
FROM dbo.EventLog el
JOIN logcounts lc ON el.LogEventID = lc.LogEventID
INNER JOIN dbo.EventLogConfig elc ON elc.ID = lc.LogConfigID
WHERE elc.KeepMostRecent <> -1
AND lc.logEventSequence > elc.KeepMostRecent
___________________________________________________
Errors when accessing the skins, languages, modules admin pages are the same as the previous attempt to upgrade.
How do I fix this? Do I just give up on DNN 5? Any and all help is most appreciated!
Troy