Sebastian, 

all the greater than 7.2.x.log.resources file are empty. The only ones I found to contain some information are the two ones below (7.1.2.log.resources and 06.00.00.log.resources). I have taken the files from the installation zip PasswordReset.ascx and PasswordReset.ascx.cs and replaced the current ones (which were identical). When I run Cathal's sp, user cannot login and also the email fails to sent. The current sp which we have for UpdateUser and allows login and password email (without successful update) is:

ALTER PROCEDURE [dbo].[UpdateUser]

@UserID         int,

@PortalID        int,

@FirstName        nvarchar(50),

@LastName        nvarchar(50),

@IsSuperUser    bit,

@Email          nvarchar(256),

@DisplayName    nvarchar(100),

@UpdatePassword    bit,

@Authorised        bit,

@RefreshRoles    bit,

@LastIPAddress    nvarchar(50),

@IsDeleted        bit,

@LastModifiedByUserID int

AS

UPDATE dbo.Users

SET

FirstName = @FirstName,

LastName = @LastName,

IsSuperUser = @IsSuperUser,

Email = @Email,

DisplayName = @DisplayName,

UpdatePassword = @UpdatePassword,

LastIPAddress = @LastIPAddress,

LastModifiedByUserID = @LastModifiedByUserID,

LastModifiedOnDate = getdate()

WHERE  UserId = @UserID

IF @PortalID IS NULL

BEGIN

UPDATE dbo.Users

SET

IsDeleted = @IsDeleted

WHERE  UserId = @UserID

END

ELSE

BEGIN

UPDATE dbo.UserPortals

SET

Authorised = @Authorised,

RefreshRoles = @RefreshRoles,

IsDeleted = @IsDeleted

WHERE  UserId = @UserID

AND PortalId = @PortalID

END

Upgrade error files:

7.1.2.log.resources

System.Data.SqlClient.SqlException (0x80131904): Ambiguous column name 'ModuleId'.

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)

ClientConnectionId:91c6785d-61d3-420f-bbc1-ffb8bed81543

CREATE PROCEDURE dbo.[GetRecycleModules]

@PortalID int

AS

SELECT  OwnerPortalID, PortalID, vw_Modules.TabID, vw_Modules.TabModuleID, 

        vw_Modules.ModuleID, ModuleDefID, vw_Modules.ModuleOrder, vw_Modules.PaneName, vw_Modules.ModuleTitle, 

        vw_Modules.CacheTime, vw_Modules.CacheMethod, vw_Modules.Alignment, vw_Modules.Color, vw_Modules.Border, 

        vw_Modules.IconFile, AllTabs, vw_Modules.Visibility, vw_Modules.IsDeleted, vw_Modules.Header, 

        vw_Modules.Footer, StartDate, EndDate, vw_Modules.ContainerSrc, vw_Modules.DisplayTitle, 

        vw_Modules.DisplayPrint, vw_Modules.DisplaySyndicate, vw_Modules.IsWebSlice, vw_Modules.WebSliceTitle, 

        vw_Modules.WebSliceExpiryDate, vw_Modules.WebSliceTTL, InheritViewPermissions, IsShareable, 

        IsShareableViewOnly, DesktopModuleID, DefaultCacheTime, ModuleControlID, 

        BusinessControllerClass, IsAdmin, SupportedFeatures, ContentItemID, 

        [Content], ContentTypeID, ContentKey, Indexed, StateID, 

        vw_Modules.CreatedByUserID, vw_Modules.CreatedOnDate, LastContentModifiedOnDate, vw_Modules.UniqueId, 

        vw_Modules.VersionGuid, vw_Modules.DefaultLanguageGuid, vw_Modules.LocalizedVersionGuid, vw_Modules.CultureCode, 

        TabModules.LastModifiedByUserID, TabModules.LastModifiedOnDate

FROM    vw_Modules INNER JOIN

        TabModules ON vw_Modules.TabModuleID = TabModules.TabModuleID

WHERE  PortalId = @PortalID

ORDER BY ModuleId

and 06.00.00.log.resources

System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "dbLB623", table "dbo.Folders", column 'FolderID'.

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   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)

ALTER TABLE dbo.[Files] ADD

CONSTRAINT [FK_Files_Portals] FOREIGN KEY ([PortalId]) REFERENCES dbo.[Portals] ([PortalID]),

CONSTRAINT [FK_Files_Folders] FOREIGN KEY ([FolderID]) REFERENCES dbo.[Folders] ([FolderID]) ON DELETE CASCADE