Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

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
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676

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,

PasswordResetToken=@passwordResetToken,

PasswordResetExpiration=@passwordResetExpiration,

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
 
nectar

Joined: 4/14/2005
Posts: 232

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
										
 
									

								

							

						

					

						

							

								

									

										cathal connolly
									

								

							

								

							

								
cathal connolly's Avatar		
							

								
www.cathal.co.uk
Joined: 4/9/2003

									Posts: 9676
								

							

						

							

								

									

										
									

										

											

												

													

														
													

												

											

										

									

								

							

								

									

										

											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
										
 
									

								

							

						

					

						

							

								

									

										nectar
									

								

							

								
Joined: 4/14/2005

									Posts: 232
								

							

						

							

								

									

										
									

										

											

												

													

														
													

												

											

										

									

								

							

								

									

										

											
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
										
 
									

								

							

						

					

						

							

								

									

										Sebastian Leupold
									

								

							

								

							

								
Sebastian Leupold's Avatar		
							

								
Sebastian Leupold's Avatar		
							

								
Sebastian Leupold's Avatar		
							

								
Sebastian Leupold's Avatar		
							

								
www.dnnwerk.de
Joined: 3/8/2004

									Posts: 46212
								

							

						

							

								

									

										
									

										

											

												

													

														
													

												

											

										

									

								

							

								

									

										

											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
										

									

										 
									

								

							

						

					

				

			

				

					

						

							

								

									 Page 2 of 3
								

									Previous123Next 
								

							

						

					

				

			

				
			

				

					

						

							

								

									

										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. 
    
  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. 
    
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
    4. 
    
  4. No Flaming or Trolling. 
    5. 
    
  5. 
    No Profanity, Racism, or Prejudice. 
    6. 
    
  6. 
    Site Moderators have the final word on approving / removing a thread or post or comment.
    7. 
    
  7. 
    English language posting only, please.
    8. 












  

    

    

    

    

    

    

    

  

  

  
  

  

  	

		
	

	
What is Liquid Content?

  	Find Out
  

  

  	

		
	

	
What is Liquid Content?

  	Find Out
  

  

  	

		
	

	
What is Liquid Content?

  	Find Out