Does anybody know if there's a way to change all users subscription end dates? I just imported a big list of customers from Paypal and I didn't make the end date far enough from today's date (it's actually not a membership, but a lifetime product deliver). Thanks! Allan
Hi Allan! Run the following in the SQL Monitor: UPDATE amember_payments SET expire_date = '2037-01-01'; This will update all users without exception for Lifetime subscription until that date with one click and a few seconds. However if you want to relate the update with the member_id then you must cange the Query a bit adding the WHERE clause with some more logic. DO NOT FORGET TO REBUILD THE DATABASE AFTERWARDS. Otherwise they will be set to have the status as expired, happening because of the unwanted $member[data][status] field. By rebuilding the database, it will get recalculate everything and every member record will function fine.
Hi Draj, Thanks a lot for your answer! However, call me a total newbie, but I have no idea how to get to the "SQL Monitor" you speak of to run that line of code. Can you point me in the right direction? Thanks! Allan
Hi! Download the NaviCat program. You will find more details in my other thread regarding tuning mysql server. Install it according to instructions. Lots of docs are available there. This will also serve for you on a long term a lot of help like backups, etc. In the NaviCat, you will find the SQL Monitor. You can use any sql administration utility like phpadmin instead of NaviCat. Well, NaviCat is exactly for people like you, user-friendly... Feel free to ask again, if you have problems.