I looked at the contents of the two files.
The first error looks like a problem migrating the users but I might be mistaken. I know that my original installation of DNN used DNNSQLMembershipProvider and the new installation uses AspNetSqlMembershipProvider. Perhaps the problem comes from my choice in the Web.config that I made. I would really need to research how this works but I am pretty new to ASP.NET and the DNN world. I can easily imagine that the application believes that the AspNetSqlMembershipProvider tables are in the DB and the application tries to migrate.
The second error doesn't give much info.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
(04.00.04.log)
This is what is in the first 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 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)
This is what is in the second:
Error: HelpURL
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *