The script has already been fixed (as Sebastian indicates) and the current packages have the fixed script (as of 6 hrs ago).

---

Charles Nurse Chief Architect Evoq Content Team Lead, DNN Corp. Want to contribute to the Platform project? - See here

MVP (ASP.NET) and ASPInsiders Member

Not sure if this is related (excuse my newbness), but in Website\Providers\DataProviders\SqlDataProvider\04.00.04.SqlDataProvider line 2369 shows 'dnn_' instead of '{objectQualifier}' , is this correct?

---

    -- Next Get the ApplicationId that corresponds to the ApplicationName
    SET @ApplicationId = (SELECT ApplicationId FROM aspnet_Applications WHERE ApplicationName = @ApplicationName)

    IF @PortalID IS NOT NULL
        BEGIN
            -- Update Authorised Flag before Transferring Users)
            UPDATE {objectQualifier}UserPortals
                SET {objectQualifier}UserPortals.Authorised = AM.IsApproved
                FROM aspnet_Applications A
                    INNER JOIN aspnet_Users AU ON A.ApplicationId = AU.ApplicationId
                    INNER JOIN aspnet_Membership AM ON A.ApplicationId = AM.ApplicationId
                        AND AU.UserId = AM.UserId
                    LEFT OUTER JOIN {objectQualifier}Users U
                        INNER JOIN {objectQualifier}UserPortals UP ON U.UserID = UP.UserId
                        ON AU.UserName = U.Username
                            AND A.ApplicationName = N'dnn_' + CAST(UP.PortalId AS nvarchar)