Hi, I'm trying to upgrade from 5.0.1 to 5.1 using the upgrade package. I follow the normal procedure of backups and then overwriting the DNN directroy with the unzipped files. I change release.config to web.config and copy in the SQL connection settings from my old backed up web.config file along with the machinekey. I then browse to my portal and the following error appears:
Installing DotNetNuke
Version: 05.01.00
Installation Status Report
00:00:00.062 - Installing Version: 05.00.00
00:00:00.078 - Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:17.671 - Executing Script: DotNetNuke.Data.SqlDataProvider Error! (see DotNetNuke.Data.log for more information)
00:00:19.468 - Installing MemberRole Provider:
00:00:19.468 - Executing Script: InstallCommon
00:00:20.609 - Executing Script: InstallMembership
00:00:21.515 - Executing Script: InstallProfile
00:00:21.968 - Executing Script: InstallRoles
00:00:22.515 - Upgrading to Version: 05.01.00
00:00:23.734 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:25.046 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:32.046 - Executing Application Upgrades: 05.00.01 Success
00:00:33.203 - Executing Application Upgrades: 05.01.00 Error!
00:00:33.593 - Cleaning Up Files: 05.00.01 Success
00:00:33.609 - Cleaning Up Files: 05.01.00 Success
00:00:33.640 - Updating Config Files: 05.00.01 Success
00:00:33.640 - Updating Config Files: 05.01.00 Success
00:00:33.703 - Performing General Upgrades
00:00:33.796 - Loading Host Settings:
The DotNetNuke.Schema.log contains the following:
################# start DotNetNuke.Schema.log #######################
System.Data.SqlClient.SqlException: The column prefix 'Classification' does not match with a table name or alias name used in the query.
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.GetVendorClassifications
@VendorId int
as
select ClassificationId,
ClassificationName,
'IsAssociated' = case when exists ( select 1 from dbo.VendorClassification vc where vc.VendorId = @VendorId and vc.ClassificationId = Classification.ClassificationId ) then 1 else 0 end
from dbo.Classification
System.Data.SqlClient.SqlException: The column prefix 'Users' does not match with a table name or alias name used in the query.
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.GetSiteLog2
@PortalID int,
@PortalAlias nvarchar(50),
@StartDate datetime,
@EndDate datetime
as
select dbo.SiteLog.DateTime,
'Name' =
case
when dbo.SiteLog.UserId is null then null
else dbo.Users.FirstName + ' ' + Users.LastName
end,
'Referrer' =
case
when dbo.SiteLog.Referrer like '%' + @PortalAlias + '%' then null
else dbo.SiteLog.Referrer
end,
'UserAgent' =
case
when dbo.SiteLog.UserAgent like '%MSIE 1%' then 'Internet Explorer 1'
when dbo.SiteLog.UserAgent like '%MSIE 2%' then 'Internet Explorer 2'
when dbo.SiteLog.UserAgent like '%MSIE 3%' then 'Internet Explorer 3'
when dbo.SiteLog.UserAgent like '%MSIE 4%' then 'Internet Explorer 4'
when dbo.SiteLog.UserAgent like '%MSIE 5%' then 'Internet Explorer 5'
when dbo.SiteLog.UserAgent like '%MSIE 6%' then 'Internet Explorer 6'
when dbo.SiteLog.UserAgent like '%MSIE%' then 'Internet Explorer'
when dbo.SiteLog.UserAgent like '%Mozilla/1%' then 'Netscape Navigator 1'
when dbo.SiteLog.UserAgent like '%Mozilla/2%' then 'Netscape Navigator 2'
when dbo.SiteLog.UserAgent like '%Mozilla/3%' then 'Netscape Navigator 3'
when dbo.SiteLog.UserAgent like '%Mozilla/4%' then 'Netscape Navigator 4'
when dbo.SiteLog.UserAgent like '%Mozilla/5%' then 'Netscape Navigator 6+'
else dbo.SiteLog.UserAgent
end,
dbo.SiteLog.UserHostAddress,
dbo.Tabs.TabName
from dbo.SiteLog
left outer join dbo.Users on dbo.SiteLog.UserId = dbo.Users.UserId
left outer join dbo.Tabs on dbo.SiteLog.TabId = dbo.Tabs.TabId
where dbo.SiteLog.PortalId = @PortalID
and dbo.SiteLog.DateTime between @StartDate and @EndDate
order by dbo.SiteLog.DateTime desc
System.Data.SqlClient.SqlException: The column prefix 'dbo.Files' does not match with a table name or alias name used in the query.
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.[GetModuleSettings]
@ModuleId int
AS
SELECT
SettingName,
CASE WHEN LEFT(LOWER(dbo.ModuleSettings.SettingValue), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM Files
WHERE 'fileid=' + convert(varchar,dbo.Files.FileID) = dbo.ModuleSettings.SettingValue
)
ELSE
dbo.ModuleSettings.SettingValue
END
AS SettingValue
FROM dbo.ModuleSettings
WHERE ModuleId = @ModuleId
System.Data.SqlClient.SqlException: The column prefix 'ScheduleHistory' does not match with a table name or alias name used in the query.
The column prefix 'ScheduleHistory' does not match with a table name or alias name used in the query.
The column prefix 'ScheduleHistory' does not match with a table name or alias name used in the query.
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.PurgeScheduleHistory
AS
DELETE FROM dbo.ScheduleHistory
FROM dbo.Schedule s
WHERE (
SELECT COUNT(*)
FROM dbo.ScheduleHistory sh
WHERE sh.ScheduleID = ScheduleHistory.ScheduleID
AND sh.StartDate >= ScheduleHistory.StartDate
) > s.RetainHistoryNum
AND s.RetainHistoryNum <> -1
AND s.ScheduleID = ScheduleHistory.ScheduleID
################# end DotNetNuke.Schema.log #########################
Any help or suggestions would be greatly appreciated.
Thanks, Donal.