- Posts: 11
- Thank you received: 0
how to avoid a second entry in subscribers when adding an existing user to plan?
- new pro
- Topic Author
- Offline
- New Member
-
5 years 1 month ago - 5 years 1 month ago #134613
by new pro
how to avoid a second entry in subscribers when adding an existing user to plan? was created by new pro
Hi Tuan,
When I add an existing user (registered but not subscribed) to a plan, how to avoid a second entry in the joslv_osmembership_subscribers table?
This is what happened to me:
I added a user from the front end but forgot putting her into a plan. This creates a registered user in users table and a non subscribed user in the subscribers table.
When I realized my mistake, I used the front end again, and picked her from the user list (see first attached image) . I noticed the form didn't populate the user's first name, last name, and email from the existing user. I had to type again. I don't mind to type it again but I suspect this might be the beginning of my problem.
Then after I set her plan and saved. I saw there were two entries in the Membership List on the front end. (see 2nd attachment)
I traced the two entries in the back end, and found them in the subscribers table. (see 3rd attachment.)
When I add an existing user (registered but not subscribed) to a plan, how to avoid a second entry in the joslv_osmembership_subscribers table?
This is what happened to me:
I added a user from the front end but forgot putting her into a plan. This creates a registered user in users table and a non subscribed user in the subscribers table.
When I realized my mistake, I used the front end again, and picked her from the user list (see first attached image) . I noticed the form didn't populate the user's first name, last name, and email from the existing user. I had to type again. I don't mind to type it again but I suspect this might be the beginning of my problem.
Then after I set her plan and saved. I saw there were two entries in the Membership List on the front end. (see 2nd attachment)
I traced the two entries in the back end, and found them in the subscribers table. (see 3rd attachment.)
Attachments:
Last edit: 5 years 1 month ago by new pro. Reason: try to move the attachment
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
- new pro
- Topic Author
- Offline
- New Member
-
5 years 1 month ago - 5 years 1 month ago #134653
by new pro
Replied by new pro on topic how to avoid a second entry in subscribers when adding an existing user to plan?
Tuan, thank you for your reply.
You are suggesting me to do it from back end Membership Pro->Subscription, which works. I could have also done it from database.
However, my goal is to let the manager to manage it from front end only, as she didn't know much about Joomla.
I have a few suggestions on front end:
1. add an configuration in Add Subscription screen, to set a default plan. This will reduce my kind of mistakes.
2. in Subscription Management menu, allow manager to select (filter) users without a plan. This way, front-end manager can delete those entries without a plan. Right now, only users with a plan show up in Subscription Management menu; therefore, the manager would have to ask me to delete those entry without a plan from back end.
(add a new filter "Without a Plan" in the red box in the screenshot)
You are suggesting me to do it from back end Membership Pro->Subscription, which works. I could have also done it from database.
However, my goal is to let the manager to manage it from front end only, as she didn't know much about Joomla.
I have a few suggestions on front end:
1. add an configuration in Add Subscription screen, to set a default plan. This will reduce my kind of mistakes.
2. in Subscription Management menu, allow manager to select (filter) users without a plan. This way, front-end manager can delete those entries without a plan. Right now, only users with a plan show up in Subscription Management menu; therefore, the manager would have to ask me to delete those entry without a plan from back end.
(add a new filter "Without a Plan" in the red box in the screenshot)
Attachments:
Last edit: 5 years 1 month ago by new pro. Reason: correct typo
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
- new pro
- Topic Author
- Offline
- New Member
-
- Tuan Pham Ngoc
- Offline
- Administrator
-