As you can see there are many post about a problem gaining access once the subscription is paid. This issue has plagued me since I start subscriptions. Some people -- and my testing -- all gained access immediately. Others it seem waited about 4 or more hours before access was available. But in all the subscriptions I have only two I had to "correct" due to a real processing issue. In most cases by the time I got to respond to the issue, access was working.
The issue is user time vs. server time. Seems that my hosting sever is set to Pacific time and I have the default time zone set to Eastern - a difference of 3 hours. Sound familiar anyone. ??
Well, the issue boils down to the effective time placed in the User Roles table. If you subscripted with the default Eastern Time zone your order would be added based on the current user time -- say 16:00 (4pm), but the server would have a time of 13:00 .... so no access until the server time was 16:00 or 19:00 (eastern).
I have corrected the issue by substracting 1 day from the effective day when added to the UserRoles. This does not effect the access to the site based on the subscription selected, but does ensure the access is immediate.
However, until I have several subscription processed without issue, I will still be watching to ensure access is available.
Thanks to all for your understanding and support
Paul.