Products

Solutions

Learn More

Partners

Community

Blog

About

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...PasswordResetToken != ResetToken when Resetting passwordsPasswordResetToken != ResetToken when Resetting passwords
Previous
 
Next
New Post
10/12/2015 8:41 AM
 

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

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...PasswordResetToken != ResetToken when Resetting passwordsPasswordResetToken != ResetToken when Resetting passwords


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out