[#3734] Member expired after renewal

We have several members having the same issue after they renew subscriptions using PayPal. What happened was their membership expired, then the members logged in and reactivate their membership. However, CBSubs didn't update the expiry date to the following year (or rather, update it to the current expiry date). This cause CBSubs to immediately changed the membership status as 'Expired' again and the members receive the expiry email.

This has happened few times and we received complaints from our members. I'm attaching the screenshot of the log.



Can you help to find out why? If you need to log in to the backend, I will PM you the username/password.

Sounds like IPN never was received and PDT probably misconfigured (not returning parameters or wrong URL). Please review your PayPal account configuration and ensure you're receiving IPNs properly within CBSubs > Notifications. If IPNs aren't working and PDT failed (user browsed away, closed browser, etc..) then CB would never know a purchase was made.

If IPN/PDT is misconfigured, then the issue will happen for all PayPal renewals and not just some of them. If PDT failed for the reason you mentioned (user closed browser, etc), is there some kind of error logged in CBSubs?

Which table holds the raw IPN data? I couldn't find it yesterday, probably missed it because I know CBSubs keeps record of raw IPN.

If IPN/PDT is misconfigured, then the issue will happen for all PayPal renewals and not just some of them.

If IPN isn't configured properly and you're only using PDT then it's possible only some users are returning to your site, which is how CBSubs would know the purchase completed. You need to review CBSubs > Notifications and ensure you're receiving PayPal IPNs properly.

If PDT failed for the reason you mentioned (user closed browser, etc), is there some kind of error logged in CBSubs?

No, they never went back to the site so CBSubs never received any information in regards to the transaction. This assumes IPN isn't working properly.

Which table holds the raw IPN data? I couldn't find it yesterday, probably missed it because I know CBSubs keeps record of raw IPN.

You don't need to go to the database table. Just go to CBSubs > Notifications.

krileon wrote: If IPN isn't configured properly and you're only using PDT then it's possible only some users are returning to your site, which is how CBSubs would know the purchase completed. You need to review CBSubs > Notifications and ensure you're receiving PayPal IPNs properly.

What's the indicator that IPN is not received? I checked notifications for this member and column 'Username' and 'Full name' are empty while the rest of the columns are ok. The raw data has variable $_GET missing (compared to other PayPal notification records). Does it mean CBSubs sent toe correct data to PayPal but somehow PayPal didn't return the userID?

I'll also double check PayPal settings again.

UPDATE:
I checked notifications for PayPal gateway and found that some members have both IPN (Log type = IPN, Verification = VERIFIED) and PDT (Log type = PDT, Verification = SUCCESS) records while some others only have IPN records.

PDT is when the user returns to the site. IPN is when PayPal sends a POST to the site with the payment information. Are the ones not working right missing a PDT?