- Posts: 151
- Thank you received: 12
[SOLVED] Covid-19 Suspend membership renewal
- Trevor Smith
- Topic Author
- Offline
- Premium Member
Less
More
4 years 4 days ago #133059
by Trevor Smith
Covid-19 Suspend membership renewal was created by Trevor Smith
Hi
As our sports club has to shut down due to the virus it has been decided to suspend membership renewals untll 1st September. (They were due on 1st April)
I have changed the renewal date on the plans but is there an easy way to change the renewal date on the individual subscriptions?
The plans are annual and non-recurring.
Best regards
Trevor
As our sports club has to shut down due to the virus it has been decided to suspend membership renewals untll 1st September. (They were due on 1st April)
I have changed the renewal date on the plans but is there an easy way to change the renewal date on the individual subscriptions?
The plans are annual and non-recurring.
Best regards
Trevor
Please Log in or Create an account to join the conversation.
- Trevor Smith
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 151
- Thank you received: 12
4 years 4 days ago #133062
by Trevor Smith
Replied by Trevor Smith on topic [SOLVED] Covid-19 Suspend membership renewal
I have solved the problem by running a SQL query:
Stay safe
Trevor
Code:
UPDATE `jos_osmembership_subscribers` SET `to_date` = '2020-08-31 23:59:59' WHERE `jos_osmembership_subscribers`.`to_date` LIKE "2020-03-31%"
Stay safe
Trevor
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
4 years 3 days ago #133075
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic [SOLVED] Covid-19 Suspend membership renewal
Ah, Yes. That's the right solution for your use-case
Tuan
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.