Yea that log file is blank
alright so here are the errors in the Event Viewer... FIRST I saw an error with PortalLanguages so I checked that and yep in the latest sql script it's
if not exists(select * from PortalLanguages where PortalID=@PortalID)
so I changed that to
if not exists(select * from {databaseOwner}{objectQualifier}PortalLanguages where PortalID=@PortalID)
Than reran the upgrade and now these are the errors it reported
During Updgrade
ERROR 1:
AssemblyVersion: 5.2.1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /CFDDNN/Install/Install.aspx?mode=upgrade
AbsoluteURL: /CFDDNN/Install/Install.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.38 Safari/532.0
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 0ae9e35a-1dc3-48e8-a7de-2d10a7e117e6
InnerException: Invalid object name 'PortalLanguages'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Data.SqlClient.SqlException: Invalid object name 'PortalLanguages'. 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String ProcedureName, Object[] commandParameters) at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication(Version version, Boolean writeFeedback)
Source:
Error 2:
AssemblyVersion: 5.2.1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /CFDDNN/Install/Install.aspx?mode=upgrade
AbsoluteURL: /CFDDNN/Install/Install.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.38 Safari/532.0
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: eb357c75-ae97-45f0-a5dc-fa3827996a67
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Services.Upgrade.Upgrade.RemoveModule
StackTrace:
Message: System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Services.Upgrade.Upgrade.RemoveModule(String DesktopModuleName, String TabName, Int32 ParentId, Boolean TabRemove) at DotNetNuke.Services.Upgrade.Upgrade.RemoveCoreModule(String DesktopModuleName, String ParentTabName, String TabName, Boolean TabRemove) at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication()
Source:
After Upgrade I get this in the EventViewer a lot
nnerException: The stored procedure 'dbo.DNNTBL_GetWorkflows' doesn't exist.