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?
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.