Data transfer to a new database

Hello,I had big problems with my Joomla database. In the end, I had to rebuild the page with a new database. I was able to successfully export the tables cbsubs_* and comprofiler* and import them into the new database.What doesn't work, however, is the allocation of payments via Stripe and PayPal. Can you tell me how this mapping works? Stripe and PayPal probably have certain database fields that they send with the payment information. And here there seems to be a mistake on my part.Can we solve the problem? 

Many thanks
Jens. 

What about payments specifically isn't working? As long as you transferred over your cbsubs_ tables all your CBSubs configuration should be fine. Did you change domain names? As that will be a problem for recurring payments.

The domain name has remained the same. The problem is actually the recurring payments. Subscriptions in CBSubs are not renewed.
I received the following message from PayPal:

Check your server that handles PayPal's instant payment confirmations (IPN). IPNs sent to the following URL(s) will not be received:

[REMOVED]/index.php?option=com_comprofiler&view=pluginclass&plugin=cbpaidsubscriptions&cbpgacctno=1&cbpbasket=693&do=gw&result=notify&cbpid=cbp647d890eeb671067682435&format=raw

[REMOVED]/index.php?option=com_comprofiler&view=pluginclass&plugin=cbpaidsubscriptions&cbpgacctno=1&cbpbasket=598&do=gw&result=notify&cbpid=cbp633da4183cf52636967337&format=raw

If you don't know this URL, you may be using a service provider that uses IPN on your behalf. Please contact your service provider with the above information. If this issue persists, it may be that IPNs are disabled for your account.

What can I do?

PayPal is unable to reach your site for whatever reason. If you've some sort of firewall or security in place be sure you're allowing PayPal through. Be sure the cbpgacctno in the URL (which is currently 1) matches the id of your payment gateway in CBSubs as that tells CBSubs what gateway needs to process the notification.

Thank you for the tips. I have no firewall or a similar component. The cbpgacctno is correct.
Here's what I found out:

• There are no new baskets saved since the database import
• The displayed basket 598 is a recurring subscription
• The displayed basket 693 does not exist. This must be a one-time payment ("day access") that was created on that day.

If I go to this subscription (there is!) and click on the payment basket ID (there is only a ___ to be seen) and click on "Pending carts" there, this error message comes:

An error has occurred.1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Pending' )' at line 2

 How can I fix this error?

• The displayed basket 598 is a recurring subscription

That one should work fine then.

• The displayed basket 693 does not exist. This must be a one-time payment ("day access") that was created on that day.

Then a subscription at PayPal exists for a basket that doesn't exist on your site.

If I go to this subscription (there is!) and click on the payment basket ID (there is only a ___ to be seen) and click on "Pending carts" there, this error message comes:

That's probably just a bad filter. Log out and back in again.

It sounds like your database copy wasn't successful and you might be missing data somewhere. You didn't really say what your major Joomla database issue was so I've no clue what could've happened to your data exactly. Do new payments work fine? or are those also broken?