I uploaded the 04.05.03 update package today, having changed web.config. The upgrade process reported a failure in 04.00.04.SqlDataProvider, though everything else ran fine.
The site seems to be working OK, but the failure makes me worry that there's trouble brewing. Can anyone shed any light on the problem?
Here's the contents of the 04.00.04.log file:
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