Having installed a fresh but early version of DNN 4.0.3, I then attempted to upgrade to DNN 4.5.5 by FTPing in the unzipped 4.5.5 upgrade files over the 4.0.3 files. During hte upgrade I got 2 error messages. When I examined the log files I found 3 log files contained data. All are presented below. Can someone tell me a fix please?
Upgrading DotNetNuke
Current Assembly Version: 04.05.05
Current Database Version: 04.00.03
00:00:00.015 - Executing Script: Upgrade.SqlDataProvider
Success
Upgrade Status Report
00:00:00.109 - Upgrading to Version: 4.5.5
00:00:00.125 - Executing Script: 04.00.04.SqlDataProvider
Error! (see 04.00.04.log for more information)
00:00:02.390 - Executing Script: 04.00.05.SqlDataProvider
Success
00:00:02.390 - Executing Script: 04.00.06.SqlDataProvider
Success
00:00:02.406 - Executing Script: 04.00.07.SqlDataProvider
Success
00:00:02.406 - Executing Script: 04.03.00.SqlDataProvider
Success
00:00:02.437 - Executing Script: 04.03.01.SqlDataProvider
Success
00:00:02.484 - Executing Script: 04.03.02.SqlDataProvider
Success
00:00:02.578 - Executing Script: 04.03.03.SqlDataProvider
Success
00:00:02.796 - Executing Script: 04.03.04.SqlDataProvider
Success
00:00:02.828 - Executing Script: 04.03.05.SqlDataProvider
Success
00:00:03.046 - Executing Script: 04.03.06.SqlDataProvider
Success
00:00:03.265 - Executing Script: 04.03.07.SqlDataProvider
Success
00:00:03.437 - Executing Script: 04.04.00.SqlDataProvider
Error! (see 04.04.00.log for more information)
00:00:04.531 - Executing Script: 04.04.01.SqlDataProvider
Success
00:00:04.609 - Executing Script: 04.05.00.SqlDataProvider
Success
00:00:05.937 - Executing Script: 04.05.01.SqlDataProvider
Success
00:00:06.046 - Executing Script: 04.05.02.SqlDataProvider
Success
00:00:06.562 - Executing Script: 04.05.03.SqlDataProvider
Success
00:00:06.718 - Executing Script: 04.05.04.SqlDataProvider
Success
00: - Executing Script: 04.05.05.SqlDataProvider
Success
00:00:07.015 - Performing General Upgrades
Upgrade Complete
Click Here To Access Your Portal
http://sbdasia.net/Install/Install.aspx?mode=upgrade26/07/2007 11:24:08 AM
03.01.01.log
System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Invalid column name 'DisplayName'.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
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 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE procedure dbo.GetList
@ListName nvarchar(50),
@ParentKey nvarchar(150),
@DefinitionID int
AS
If @ParentKey = ''
Begin
Select DISTINCT
E.[ListName],
E.[Level],
E.[DefinitionID],
E.[ParentID],
(SELECT MAX([SortOrder]) FROM Lists WHERE [ListName] = E.[ListName]) As [MaxSortOrder],
(SELECT COUNT(EntryID) FROM Lists WHERE [ListName] = E.[ListName] AND ParentID = E.[ParentID]) As EntryCount,
IsNull((SELECT [ListName] + '.' + [Value] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [Key],
IsNull((SELECT [ListName] + '.' + [Text] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [DisplayName],
IsNull((SELECT [ListName] + '.' + [Value] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [ParentKey],
IsNull((SELECT [ListName] + '.' + [Text] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [Parent],
IsNull((SELECT [ListName] FROM Lists WHERE [EntryID] = E.[ParentID]),'') As [ParentList]
From Lists E (nolock)
where ([ListName] = @ListName or @ListName='')
and (DefinitionID = @DefinitionID or @DefinitionID = -1)
Order By E.[Level], E.[DisplayName]
End
Else
Begin
DECLARE @ParentListName nvarchar(50)
DECLARE @ParentValue nvarchar(100)
SET @ParentListName = LEFT(@ParentKey, CHARINDEX( '.', @ParentKey) - 1)
SET @ParentValue = RIGHT(@ParentKey, LEN(@ParentKey) - CHARINDEX( '.', @ParentKey))
Select DISTINCT
E.[ListName],
E.[Level],
E.[DefinitionID],
E.[ParentID],
(SELECT MAX([SortOrder]) FROM Lists WHERE [ListName] = E.[ListName]) As [MaxSortOrder],
(SELECT COUNT(EntryID) FROM Lists WHERE [ListName] = E.[ListName] AND ParentID = E.[ParentID]) As EntryCount,
IsNull((SELECT [ListName] + '.' + [Value] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [Key],
IsNull((SELECT [ListName] + '.' + [Text] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [DisplayName],
IsNull((SELECT [ListName] + '.' + [Value] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [ParentKey],
IsNull((SELECT [ListName] + '.' + [Text] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [Parent],
IsNull((SELECT [ListName] FROM Lists WHERE [EntryID] = E.[ParentID]),'') As [ParentList]
From Lists E (nolock)
where [ListName] = @ListName And
[ParentID] = (SELECT [EntryID] From Lists Where [ListName] = @ParentListName And [Value] = @ParentValue)
Order By E.[Level], E.[DisplayName]
End
04.00.04.log
System.Data.SqlClient.SqlException: Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
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)
/* Transfer Profile */
/*********************/
If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
BEGIN
--Create Temp Table
CREATE TABLE dbo.FlatProfile (
[UserID] [int] ,
[PortalID] [int],
[Username] [nvarchar] (256) NULL ,
[FirstName] [nvarchar] (256) NULL ,
[LastName] [nvarchar] (256) NULL ,
[Street] [nvarchar] (256) NULL ,
[Unit] [nvarchar] (128) NULL ,
[City] [nvarchar] (256) NULL ,
[Country] [nvarchar] (256) NULL ,
[Region] [nvarchar] (256) NULL ,
[PostalCode] [nvarchar] (128) NULL ,
[Telephone] [nvarchar] (128) NULL ,
[Cell] [nvarchar] (128) NULL ,
[Fax] [nvarchar] (128) NULL ,
[Website] [nvarchar] (256) NULL ,
[IM] [nvarchar] (256) NULL,
[PreferredLocale] [nvarchar] (128) NULL ,
[TimeZone] [nvarchar] (256) NULL,
[LastUpdatedDate] [datetime]
)
--Extract from Profile Blob to Temp Table
INSERT INTO dbo.FlatProfile
SELECT
dbo.users.userid,
dbo.userportals.portalid,
dbo.users.username,
dbo.users.firstname,
dbo.users.lastname,
dbo.GetProfileElement('Street',PropertyNames,PropertyValuesString) Street,
dbo.GetProfileElement('Unit',PropertyNames,PropertyValuesString) Unit,
dbo.GetProfileElement('City',PropertyNames,PropertyValuesString) City,
dbo.GetProfileElement('Country',PropertyNames,PropertyValuesString) Country,
dbo.GetProfileElement('Region',PropertyNames,PropertyValuesString) Region,
dbo.GetProfileElement('PostalCode',PropertyNames,PropertyValuesString) PostalCode,
dbo.GetProfileElement('Telephone',PropertyNames,PropertyValuesString) Telephone,
dbo.GetProfileElement('Cell',PropertyNames,PropertyValuesString) Cell,
dbo.GetProfileElement('Fax',PropertyNames,PropertyValuesString) Fax,
dbo.GetProfileElement('Website',PropertyNames,PropertyValuesString) Website,
dbo.GetProfileElement('IM',PropertyNames,PropertyValuesString) IM,
dbo.GetProfileElement('PreferredLocale',PropertyNames,PropertyValuesString) PreferredLocale,
dbo.GetProfileElement('TimeZone',PropertyNames,PropertyValuesString) TimeZone,
aspnet_profile.LastUpdatedDate
FROM dbo.Users
inner join dbo.userportals on dbo.users.userid = dbo.userportals.userid
inner join aspnet_users on dbo.users.username = aspnet_users.username
inner join aspnet_profile on aspnet_profile.userid = aspnet_users.userid
where dbo.userportals.portalid = PortalID
--Move to UserProfile Table
EXECUTE dbo.TransferUsersFromFlatProfile N'FirstName'
EXECUTE dbo.TransferUsersFromFlatProfile N'LastName'
EXECUTE dbo.TransferUsersFromFlatProfile N'Unit'
EXECUTE dbo.TransferUsersFromFlatProfile N'Street'
EXECUTE dbo.TransferUsersFromFlatProfile N'City'
EXECUTE dbo.TransferUsersFromFlatProfile N'Region'
EXECUTE dbo.TransferUsersFromFlatProfile N'PostalCode'
EXECUTE dbo.TransferUsersFromFlatProfile N'Country'
EXECUTE dbo.TransferUsersFromFlatProfile N'Telephone'
EXECUTE dbo.TransferUsersFromFlatProfile N'Fax'
EXECUTE dbo.TransferUsersFromFlatProfile N'Cell'
EXECUTE dbo.TransferUsersFromFlatProfile N'Website'
EXECUTE dbo.TransferUsersFromFlatProfile N'IM'
EXECUTE dbo.TransferUsersFromFlatProfile N'TimeZone'
EXECUTE dbo.TransferUsersFromFlatProfile N'PreferredLocale'
--Drop temp objects
DROP TABLE dbo.FlatProfile
DROP PROCEDURE dbo.TransferUsersFromFlatProfile
END
04.04.00.log
Error: HelpURL