Products

Solutions

Learn More

Partners

Community

Blog

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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/8/2015 6:56 AM
 

you can ignore the hmac fields, they're only added in 8.0.0 (sorry I should have scripting it from 7.4.1 but I just used that example to show you that the fields need to be in the sproc) - the 7.4.1 sproc looks like this:

CREATE PROCEDURE [dbo].[UpdateUser]

@UserID int,

@PortalID int,

@FirstName nvarchar(50),

@LastName nvarchar(50),

@IsSuperUser bit,

@Email nvarchar(256),

@DisplayName nvarchar(100),

@VanityUrl nvarchar(100),

@UpdatePassword bit,

@Authorised bit,

@RefreshRoles bit,

@LastIPAddress nvarchar(50),

@passwordResetToken uniqueidentifier,

@passwordResetExpiration datetime,

@IsDeleted bit,

@LastModifiedByUserID int

AS

UPDATE dbo.Users

SET

FirstName = @FirstName,

LastName = @LastName,

IsSuperUser = @IsSuperUser,

Email = @Email,

DisplayName = @DisplayName,

UpdatePassword = @UpdatePassword,

[email protected],

[email protected],

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,

VanityUrl = @VanityUrl,

IsDeleted = @IsDeleted

WHERE UserId = @UserID

AND PortalId = @PortalID

END

GO


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
10/9/2015 6:46 AM
 

Cathal, thanks for the support so far. After applying the changes to the sp we get the following error when we try to reset a password:

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID:59d79e2c-495b-4cb1-9a66-973577c9e687

AssemblyVersion:7.4.1

PortalId:1

UserId:-1

TabId:756

RawUrl:/Home/tabid/756/ctl/SendPassword/Default.aspx?returnurl=%252fHome.aspx&popUp=true

Referrer:http://xyz.co.uk/Home/tabid/756/ctl/SendPassword/Default.aspx?returnurl=%252fHome.aspx&popUp=true

UserAgent:Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36

ExceptionHash:i9a9TYII4I+v20sgFrb0uA==

Message:Procedure or function 'UpdateUser' expects parameter '@VanityUrl', which was not supplied.

StackTrace:


 

InnerMessage:Procedure or function 'UpdateUser' expects parameter '@VanityUrl', which was not supplied.

InnerStackTrace:

   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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Security.Membership.Data.SqlDataProvider.UpdateUser(Int32 userId, Int32 portalID, String firstName, String lastName, Boolean isSuperUser, String email, String displayName, Boolean updatePassword, Boolean isApproved, Boolean refreshRoles, String lastIpAddress, Boolean isDeleted, Int32 lastModifiedByUserID)
   at DotNetNuke.Security.Membership.AspNetMembershipProvider.UpdateUser(UserInfo user)
   at DotNetNuke.Entities.Users.UserController.UpdateUser(Int32 portalId, UserInfo user, Boolean loggedAction, Boolean clearCache)
   at DotNetNuke.Entities.Users.UserController.ResetPasswordToken(UserInfo user, Boolean sendEmail)
   at DotNetNuke.Modules.Admin.Security.SendPassword.OnSendPasswordClick(Object sender, EventArgs e)
   at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

Source:

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:

Server Name: id19903

 
New Post
10/9/2015 7:05 AM
 
very odd - that error suggests that DNN is not supplying the vanityurl parameter, but that's a part of 7.4.1 - it's almost like your site's database has been updated correctly i.e. the database is an older version than the assembly. Please check the version table and tell me if 7.4.1 is one of the versions

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
10/12/2015 5:02 AM
 

Cathal, 

these are the last three entries in the version table:

VersionId Major Minor Build CreatedDate Name

123 7 3 4 2014-12-20 16:34:20.710 DNNCORP.CE

124 7 4 0 2015-08-02 14:15:14.410 DNNCORP.CE

125 7 4 1 2015-08-02 14:15:17.197 DNNCORP.CE

 
New Post
10/12/2015 6:50 AM
 
please check .log.resources files in /providers/dataproviders/sqldataprovider folder for any install or upgrade errors logged.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
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