I am trying to remove Free subscriptions of members of 2004 and 2005 I can select them by search users/search by date this gives me 180 users. 2005 gives me 957 members, question is does anyone know a way to remove the subscriptions on block rather than doing a 1000 individually? I want to keep the memberships and give them the chance to renew their subscriptions, the reason is that I made a mistake at the beginning of giving them a free 10 year subscription and a lot of these have gone stale and cannot be contacted. I think it could be done with a sql command something like remove from members field subscriptions less than 2005, obviously the proper syntax is something I'm not familiar with, although I could run it in phpMyAdmin. Appreciate it if anyone can spare a bit of time to help. Thanks
First, I would back up your database. Then run an sql query something like that below changing the product id to match your free product and the year you want. This way you'll make sure you are getting the right results prior to updating the table to delete those records. But rather than delete them I would just set their status to inactive or something else.... delete is forever. SELECT amember_members.login, amember_payments.product_id FROM amember_payments, amember_members WHERE amember_payments.member_id=amember_members.member_id AND year(amember_members.added)=2005 AND amember_payments.product_id = 2 Good luck.