Hi

Discussion in 'Troubleshooting' started by bennyuk1, Jan 13, 2017.

Thread Status:
Not open for further replies.
  1. bennyuk1

    bennyuk1 aMember Pro Customer

    Joined:
    Jan 12, 2012
    Messages:
    159
    I need to change he "expire date" on our members subscription to all be the same date, no matter when they started their subscription. I have the payment gateway hard coded to do this but the product expiration date for each user is wrong in amember and needs to be adjusted.

    Is there a SQL command or similar, I can run to overwrite expired dates for all user with a certain subscription?
  2. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    1,659
    Hello,

    You can try to use the following MySQL query to accomplish your task:
    Code:
    UPDATE am_access SET expire_date='2017-08-25' WHERE product_id=1;
    You need to replace 2017-08-25 and 1 in query above with desired values.

    Then log in to admin interface and navigate to
    aMember CP -> Utilities -> Rebuild DB
    and run Rebuild Core Database

    I hope it help.

    Best Regards.
  3. bennyuk1

    bennyuk1 aMember Pro Customer

    Joined:
    Jan 12, 2012
    Messages:
    159
    Many thanks
    caesar likes this.
Thread Status:
Not open for further replies.

Share This Page