Mountain View 1600, CA 94043
+1 650-253-0000
name@example.com
Web
Site
Search
Register
Login
DNN Home
Services
-
DotNetNuke Support
-
CRM Systems
DNN
-
DotNetNuke Modules
-
Module Downloads
-
Module Upgrade Policy
DNN Support
-
Module Update News
-
Knowledge Base
-
License Management
-
Invoice History
Module Downloads
Blog
Store
Contact Us
-
About Us
Search
Home
1
2
3
4
5
Home
Support
Subscriptions M...
Deleting user with Subscription - re-adding that user for reoccurring payment
Previous
Next
6/18/2021 6:11 AM
jordan Marsh
Joined: 2/12/2018
Posts: 3
Deleting user with Subscription - re-adding that user for reoccurring payment
(N/A)
Hi,
Have come across an issue with a site admin deleting a user in DNN with a subscription, they have re added the user via DNN, the Payment has reoccurred via PayPal and the user role has not extended its expiry date for that user.
In the subscription module, the payment log shows the Invoice ID for the most recent payment but with no email address or name.
Is there a way to re add the deleted user to the subscription?
7/6/2021 12:20 PM
jordan Marsh
Joined: 2/12/2018
Posts: 3
Re: Deleting user with Subscription - re-adding that user for reoccurring payment
(N/A)
For those who come across this issue, to re-add the user to the subscription requires some sql scripts and playing with Database Tables.
For emergencies only.
1. Manually re-add the deleted user via DNN
2. in Database table, Edit DBO.Users.
3. Find the re-added user, then edit the Username & Email address (you just need to change these values, i put.old on all fields.
4. run this SQL - update the VALUES field, match the UserID with the old user ID or the end numbers on the reoccuring payment Invoice ID.
SET IDENTITY_INSERT dbo.Users ON
INSERT INTO dbo.Users (UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, LastIPAddress, IsDeleted, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, PasswordResetToken, PasswordResetExpiration)
VALUES (UserID, 'Username', 'FirstName', 'Lastname', 0, 0, 'EmailAddress', 'Full name', 0, NULL, 0, 1, NULL, 1, NULL, NULL, NULL);Go
SET IDENTITY_INSERT dbo.Users OFF
GO
This will readd the user to DBO.Users.
5. Edit DBO.UserPortals table.
6. Add in a new row with the same UserID & PortalID as the portal your website is on.
7. in your DNN website, you should be able to see the user in the list. Now add the subscription role and
must
have an expiry date
to the user so the subscription module can renew it.
This will allow the user to reset their password & login.
7/6/2021 12:38 PM
DNN Module Support
Joined: 8/28/2006
Posts: 2065
Re: Deleting user with Subscription - re-adding that user for reoccurring payment
(Australia)
Thanks for sharing this information. Much appreciated.
Page 1 of 1
Previous
Next
Home
Support
Subscriptions M...
Deleting user with Subscription - re-adding that user for reoccurring payment