The contents of the file are a bit of a puzzle to me. The first one seems to have failed while migrating the users. The second only has one line. Most things seem to work. But when I try editing the site I get errors.
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 quser.fn_GetVersion(3,2,3)) = 0
BEGIN
--Create Temp Table
CREATE TABLE quser.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 quser.FlatProfile
SELECT
quser.users.userid,
quser.userportals.portalid,
quser.users.username,
quser.users.firstname,
quser.users.lastname,
quser.GetProfileElement('Street',PropertyNames,PropertyValuesString) Street,
quser.GetProfileElement('Unit',PropertyNames,PropertyValuesString) Unit,
quser.GetProfileElement('City',PropertyNames,PropertyValuesString) City,
quser.GetProfileElement('Country',PropertyNames,PropertyValuesString) Country,
quser.GetProfileElement('Region',PropertyNames,PropertyValuesString) Region,
quser.GetProfileElement('PostalCode',PropertyNames,PropertyValuesString) PostalCode,
quser.GetProfileElement('Telephone',PropertyNames,PropertyValuesString) Telephone,
quser.GetProfileElement('Cell',PropertyNames,PropertyValuesString) Cell,
quser.GetProfileElement('Fax',PropertyNames,PropertyValuesString) Fax,
quser.GetProfileElement('Website',PropertyNames,PropertyValuesString) Website,
quser.GetProfileElement('IM',PropertyNames,PropertyValuesString) IM,
quser.GetProfileElement('PreferredLocale',PropertyNames,PropertyValuesString) PreferredLocale,
quser.GetProfileElement('TimeZone',PropertyNames,PropertyValuesString) TimeZone,
aspnet_profile.LastUpdatedDate
FROM quser.Users
inner join quser.userportals on quser.users.userid = quser.userportals.userid
inner join aspnet_users on quser.users.username = aspnet_users.username
inner join aspnet_profile on aspnet_profile.userid = aspnet_users.userid
where quser.userportals.portalid = PortalID
--Move to UserProfile Table
EXECUTE quser.TransferUsersFromFlatProfile N'FirstName'
EXECUTE quser.TransferUsersFromFlatProfile N'LastName'
EXECUTE quser.TransferUsersFromFlatProfile N'Unit'
EXECUTE quser.TransferUsersFromFlatProfile N'Street'
EXECUTE quser.TransferUsersFromFlatProfile N'City'
EXECUTE quser.TransferUsersFromFlatProfile N'Region'
EXECUTE quser.TransferUsersFromFlatProfile N'PostalCode'
EXECUTE quser.TransferUsersFromFlatProfile N'Country'
EXECUTE quser.TransferUsersFromFlatProfile N'Telephone'
EXECUTE quser.TransferUsersFromFlatProfile N'Fax'
EXECUTE quser.TransferUsersFromFlatProfile N'Cell'
EXECUTE quser.TransferUsersFromFlatProfile N'Website'
EXECUTE quser.TransferUsersFromFlatProfile N'IM'
EXECUTE quser.TransferUsersFromFlatProfile N'TimeZone'
EXECUTE quser.TransferUsersFromFlatProfile N'PreferredLocale'
--Drop temp objects
DROP TABLE quser.FlatProfile
DROP PROCEDURE quser.TransferUsersFromFlatProfile
END
04.04.00.log
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Error: HelpURL