<URGENT> 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 ran the following SQL update code: update amember_payments set expire_date = '2036-12-31' where expire_date = '2012-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
    UPDATE - some friendly soul advised me that it is necessary to click on 'Rebuild DB' in the aMember CP. This supposedly fixes all dirty references after a manual update or a db recovery. Anyway, I did it and thus far it 'seems' that it is working again.

    However, if there are any other places where I need to make date changes to 2036 please let me know.
  3. mmehrle

    mmehrle Member

    Joined:
    Mar 16, 2009
    Messages:
    37

Share This Page