Subscription not renewed after Stripe payement completed

Webhooks is unknown territory for me... I had setup a webhook in the Stripe account config, but only with the home URL of our site. I saw it had failed attempts only.

This would be why you had failed subscription activations then. If the user navigated away from Stripe checkout and didn't let it send them back to your site Stripe had no way to notify CBSubs that a payment was completed.

I removed the existing, and created a new webhook in Stripe with the URL of the menu point you created. Added that Stripe webhook secret in the gateway config in CBSubs.

Use the URL provided within CBSubs > Payment Gateways > Your Stripe Gateway. Be sure to add or replace the Itemid in the URL with &Itemid=1579. You also only need to be sending the webhook events specifically noted on that same CBSubs page. Do not send all events.

I tested several times with adding a new subscription to my profile, going to the Stripe payment page and cancel the payment in Stripe. I would expect to see any webhook attempts there, but it remains empty.

Webhooks will be logged in Stripes webhook history. CBSubs will log them in CBSubs > Notifications if CBSubs needed to process the notification.

I cannot access CB Subs baskets anymore now: when I click the SBSubs menu option baskets, I get an SQL error - see uploaded image

That's a bug with the filters. Log out and back in backend to clear the filter cache and that'll fix it.

Thanks!
Use the URL provided within CBSubs > Payment Gateways > Your Stripe Gateway. Be sure to add or replace the Itemid in the URL with &Itemid=1579. You also only need to be sending the webhook events specifically noted on that same CBSubs page. Do not send all events.
=> so I copied the url in CBSubs > Payment Gateways > Your Stripe Gateway, but replace the item ID 508 in there with 1579, and put that adjusted URL in the Stripe webhook config. I always allready send only the events that areon that same CBSubs page. 

For my understanding: should every payment become visible in the stripe webhook endpoint logs, or only those when the user closes the page and the webhooks need to be used to give feedback to our website? So far I see nothing there, no failed, no succes, even I start a payment and cancel it at the last possible moment in my choosen payment method from Stripe.
Same question for CB Subs notitification: should I see there always webhook loggings for every payment, or only for those were the webhooks were used ?  
Or in other words: how can I know my webhook setup will work now?
See attached 2 screenprints to confirm my settings as per your advise

Great, your configuration looks correct to me.

A webhook will only be logged there if one was needed to be sent. The only Stripe Checkout webhook we're interested in is completed payments. So going to the page and cancelling will not send a webhook since we don't need to know they cancelled it. If the user returns to the site before the webhook does then CBSubs > Notifications will have no use for the notification and will skip it since the return paid the basket.

Hi,here we are again.
I had yesterday 15 Dec 13:54 a customer who renewed his Waterpolo Fee for 2025. In CB Subs I saw afterwards in the logging his normal initiation steps, but then no more sign of him, while in stripe he did pay, he got his confirmation receipt, there was some webhook processing (I think) but nothing happens in CB SUBS. No payment registered, no update of his CB field as per plan specs, no invoice, … 
what I also see in the log, is numerous ‘stripe Stripe IPN fraud attempt. ERROR: signature’ which worries me even more.
your user and password to access our site are still untouched by me… Please advise, thanks, Roland

Also member 3176 new subscription paid 15/12 at 23:47 standard membership . In CB Subs he remained registered but no sign of his payment, I just now subscribed him manually in backend to standard plan.

what I also see in the log, is numerous ‘stripe Stripe IPN fraud attempt. ERROR: signature’ which worries me even more.

This means the IPN signature is failing. Did you configure "Stripe webhook Signing Secret" correctly within your Stripe gateway in CBSubs > Gateways? That can be found with your webhook in your Stripe account. This at least means webhooks are now reaching your site they just aren't processing due to the signing secret either being missing or being incorrect.