Manually update subscription counters?

[johnmont]

I have about 500 expired subscriptions that I wanted to easily change back to active -- so I did an sql statement to modify the active and expirydate fields in subscriptionlog. However, this does not add them back to the membergroup for which they should be members.

Is there an easy way to do this? It seems as though the sql statement could be quite involved and a bit over my head.

I'd really rather not manually go in to the subscription manager, edit each user, then hit save. Which is how I've found the workaround for the issue.