I wondered if anyone could take a look at the following error messages generated during an upgrade from 04.00.03 to 04.05.03?  Everything went well except for three errors and I am only concerned about the last one so I wondered if anyone cared to comment on how to fix it, if it even needs fixing and what might fail if it is not fixed.  Other than these errors, things are running fine. 

Thanks much,
Weezy

04.04.00: Error: HelpURL
04.05.01: Error: Access to the path 'D:\DotNetNuke_2\Website\RSS.aspx.vb' is denied. (Probably no big deal and it's likely my fault at any rate.)
This is the one I am concerned about: 04.00.04: 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

Hi Mitch:

Thanks for answering.  I just tried to run that script and it said "Could not find stored procedure 'dbo.TransferUsersFromFlatProfile'." so then I dug around to find the script that creates TransferUsersFromFlatProfile and can't seem to find it.  Any idea where it's at?

No, I haven't seen any errors, but this is a pretty empty install.  I have about ten users with no additional profile info and I can browse them fine and did a couple of updates as well.

Thanks again.

Weezy

Mitch:

Sorry about that, I should have said that earlier, the strored procedure is definitely dropped at the end  of the script, but I figured there must be some place it was created, so I did a search in all files for "TransferUsersFromFlatProfile" in the upgrade .zip file and then on the entire DNN folder but could not find it.

Yeah, it seems to work fine and I kind of think this is what it was for (which happens to not apply in my case):

If you had an older DNN install, that script would move things from the older flat table structure into the new relational table.  Since I started this install at 4.something, when I upgraded to 4.03.05 this script was moot.  So I am going to proceed and maybe this will help someone down the road.

Thanks again.

Weezy