All recurring members expired 2012-12-31

Discussion in 'Troubleshooting' started by mmehrle, Jan 1, 2013.

  1. mmehrle

    mmehrle Member

    Joined:
    Mar 16, 2009
    Messages:
    37
    I am running amember 3.1.6PRO. For some reason the author of amember used 2012-12-31 as the RECURRING expiration date and that means that since last night all my recurring members have been set to expired. Huge problem. So this is what I have been doing as of now:
    1. I an the following SQL update code: select * from amember_payments where expire_date = '2036-12-31'; (I am using 2036 as that changes the subscription to RECURRING - 2037 changes it to LIFETIME.
    2. Changed 2012-12-31 to 2036-12-31 in product_inc.php.
    3. Changed all occurrences of 2012-12-31 to 2036-12-31 in paypal_r.inc.php
    HOWEVER, this does NOT fix one huge problem, which is that all members that were mistakenly expired on 2012-12-31 are still shown to be expired! Which means nobody can log into my posts now. I have no idea how to fix this. This is a catastrophe and any help would be appreciated.
  2. mmehrle

    mmehrle Member

    Joined:
    Mar 16, 2009
    Messages:
    37
    Correction - the SQL update I ran was the following: update amember_payments set expire_date = '2036-12-31' where expire_date = '2012-12-31';
  3. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279

Share This Page