Lifetime Subscription Expiry date

Discussion in 'Troubleshooting' started by Yvonne, Feb 14, 2012.

  1. Yvonne

    Yvonne New Member

    Joined:
    Jun 15, 2008
    Messages:
    2
    Hi
    I'm using Amember v 3.1.2 and wondering if there is an easy way I can extend the lifetime subscription expiry date.
    When we stopped charging for membership I mass subscribed all members to a new free lifetime product not realising the expiry date in my amember version was 31/12/2012. I don't really want to extend each one manually so is there anything else I can do?
    Thanks
    Yvonne
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    You can do this in phpMyAdmin. Run this query:
    update amember_payments set expire_date = '2037-12-31' where expire_date = '2012-12-31'
  3. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Needless to say, please backup database before doing any actions.
  4. Yvonne

    Yvonne New Member

    Joined:
    Jun 15, 2008
    Messages:
    2
    Thanks I'll give it a try after I have made a back up.

Share This Page