Set a subscription to never expire for some member

Is it possible to set the subscriptions for some members to never expire? For example, for normal members they have to renew their membership every 1 year. However, we also have honorary members who are given the membership and theirs will never expire.

Without creating a new plan, is it possible to achieve this by, for example, setting the expiry date to NULL (through SQL) or 0000-00-00 00:00:00 (through backend panel)? Or what's the maximum year we can assign to the expiry date? Can I set it to, for example, year 2999?

CB: 1.4
CBSubs: 1.1.2
Joomla: 1.5.23
PHP: 5.2.16

I guess you can manually make this date change.

However, I would just create a new CBSubs plan and manually add the VIP user to it from backend. The plan does not have to appear at all in frontent proposals.

This way you can filter your VIP users easily in backend CB User Manager.
And if you want you can give them nice VIP badge (like your Professional badge on your profile here on Joomlapolis).

Hi Nick,

A new plan is the most elegant solution, I agree.

If I set the expiry date to 0000-00-00 00:00:00, will the cron job set the status to Expired? I believe when set to NULL, it will be treated like lifetime subscription. Am I correct?

apdt wrote: Hi Nick,

A new plan is the most elegant solution, I agree.

If I set the expiry date to 0000-00-00 00:00:00, will the cron job set the status to Expired? I believe when set to NULL, it will be treated like lifetime subscription. Am I correct?

No sure really - would need to test it (and maybe see what the expiration date is set to for lifetime plan subscribers).
I would suggest some date in the future (maybe 10 years ahead?).

I would still suggest the VIP plan approach - much easier to manage really.