Active Subscription Stripe Status But Expired Account on Live Site

Hello,

I am really sorry to come back to you but it seems that I don't succeed in fixing this issue.

Since the last changes, I haven't had any error rate for the Stripe Webhook, everything seems to work perfectly and in my CBSubs area, I don't have any error logs but the problem keeps repeating, which is starting to cause us serious financial difficulties.

The same issue happened multiple times since my last post, which is that members are still active on Stripe but expired on the site without knowing why.

For example, I have a member which had her subscription automatically renewed on April 27th but expired, on the site only (still active on Stripe) on April 30th without any payment failure at all.

Sadly, it is happening for many others as well.

Would you have any idea as to how it can be resolved or any avenues which might be worthwhile to explore ?

I thank you again for your precious help and I hope you will have a beautiful and peaceful day,
Mathias


Edit : On a sidenote, just right now, I was being reminded that members have also reported another issue starting to appear after the latest J5 and CB upgrades, which is that when they want to pay their membership, it is shown "€ 0" even though the two plans we have are not free and we didn't seem to have the problem back then. It is shown this amount but in reality, the right payments are being made and are the ones mentioned in both CBSubs Plans. It doesn't seem to cause any issue but I am sharing in case this is relevant to the past issue I mentioned, as I don't know if this can be or not. Moreover, I don't seem to have issue with the new webhook since I have a 0% error rate and 100% success rate on Stripe but after having created the new menu item for it, when going to the page, I have this "No valid “do” action selected." even though I selected one (basket notification page) and don't know if this means there any issue with it.Thank you !

Are the webhooks in the Stripe webhook history log for the subscription on the 27th reporting they successfully reached your install? We output a response for every webhook. It should report back to Stripe with "webhook process: success" and if it didn't then the webhook did not reach CBSubs. Not having errors does not mean it reached CBSubs it's possible a redirect can occur and report a 200 success so no error will be thrown at Stripe, which is why our Stripe webhooks always report their status.

but after having created the new menu item for it, when going to the page, I have this "No valid “do” action selected."

I'm not sure what you mean by this? Going to what page? The Stripe webhook URL?

Please PM backend super user login credentials and will review your configuration. See link in signature to directly PM me. Will adjust your CBSubs menus if necessary to ensure CBSubs is reachable. Joomla can get real annoying here with it hijacking URLs and routing away so it's vital we be sure that Stripe webhook URL is reachable. It should just be a blank page and not show errors of any kind.

Hello Kyle,

Thanks again so much for your precious and quick help, I really appreciate it 

Here's what I have in Stripe webhook logs for the subscription on the 27th (and others as well) :

• charge.succeeded : code 200 (ok) - webhook skipped: nothing to do
• payment_intent.succeeded : code 200 (ok) - webhook skipped: nothing to do
• invoice.payment_succeeded : code 200 (ok) - webhook skipped: waiting for charge

So with this result, I guess Stripe cannot reach CBSubs if I understand correctly ?

The only "webhook process: success" I saw that I got recently were for unsubscriptions and refund (customer.subscription.deleted and charge.refunded).

To clarify what I meant, the menu item ID I had in the endpoint URL I had to mention to Stripe to create the new webhook was related to the Profile Page and was for members only. So as you kindly suggested, I created a new public menu item configured with "CB > Plugin > CB Paid Subscriptions > Basket Notification Page".

The alias is "webhook" so I went to mysite.com/webhook and I have what I've shared with you, a text message displayed on the page saying,

No valid “do” action selected.

Even though, I did selected a "do" action, which is "basket notification page". 

But when I go to the webhook endpoint URL such as " site.com/index.php?option=com_comprofiler&view=pluginclass&Itemid=1297&plugin=cbpaidsubscriptions&cbpgacctno=2&do=gw&result=notify&format=raw ", then I have a blank page. 

I hope I've been clearer in my explanations and I thank you again for your very kind help and support.

PS : I tried deleting the new webhook menu item I created (with display basket notifications), so the endpoint url changed again for the profile page menu item as it was the case originally. In researching a bit, I found out I had multiple menu items for profile page and the one the endpoint url was connecting with was the one for members only. I then changed this menu item and simply changed it to an alias menu item pointing to the cb-profile in CB menu which is public. So now the endpoint url changed again and connects with the cb-profile menu item. I updated it in the webhook on Stripe. I'll see if that works like this, hoping it will.

Mathias

So with this result, I guess Stripe cannot reach CBSubs if I understand correctly ?

Those all have responses so it's reaching CBSubs fine.

invoice.payment_succeeded : code 200 (ok) - webhook skipped: waiting for charge

This is probably the recurring payment. Seams like the payment didn't get instantly charged and required some further verification. There should be a "charge.succeeded" webhook after that to pay the invoice. Is the one that was skipped related to the same payment? The data in the webhook should let you link them all together. I recommend finding the payment for that users subscription and looking through the logs at Stripe itself as it gives a full trail of logs to see exactly what webhooks were associated with that payment. Something isn't being communicated to CBSubs and am unsure why.

The alias is "webhook" so I went to mysite.com/webhook and I have what I've shared with you, a text message displayed on the page saying,

That's working as expected then. The menu item isn't meant to actually be fully functional, but provides a way through Joomla's routing to the webhook URLs generated in gateways.

PS : I tried deleting the new webhook menu item I created (with display basket notifications), so the endpoint url changed again for the profile page menu item as it was the case originally. In researching a bit, I found out I had multiple menu items for profile page and the one the endpoint url was connecting with was the one for members only. I then changed this menu item and simply changed it to an alias menu item pointing to the cb-profile in CB menu which is public. So now the endpoint url changed again and connects with the cb-profile menu item. I updated it in the webhook on Stripe. I'll see if that works like this, hoping it will.

No further changes were necessary your webhook menu item was working fine.

Am working on updating CBSubs Stripe to latest API version and will go through retesting the entire recurring subscription process.

What is your plan price and duration? If there's an initial price and duration different from regular price and duration please provide that as well. I currently have CBSubs Stripes updated to latest APIs (minimal changes as we're basically already compatible). I've tested simple 1 month recurring at $10 and appears working fine in my tests so far.