Hello, we're running into an issue on our site where we are intermittently losing users even though they are subscribed to the site. The payments are shown in our CB Subs subscription system but the users are not showing as users in Joomla or Community Builder.
This is for the site
www.marylandshallissue.org
. It's running CB 2.4.0.
Joomla is 3.9.1
PHP is 7.1.26
Relevant plugins:
Community Builder
CB Paid Subscriptions
CBJuice 2
Kunena Forums
The site also users a few other extensions:
JoomCareer
MijiShop
JEvents
Regular Labs
There are a few other extensions/modules related to the template/editor/modules, but nothing that should affect users.
I was able to find additional users who were missing by looking at payments made in the payment basket part of CB Subs. Here’s the breadcrumbs to follow the trail.
Finding missing users.
• In CB Subs admin portal, look at Payment Baskets and find where users are ‘—‘ by shorting on Username column.
• Look at the payment basket ID
• Run a SQL query against the cbsubs_payment_baskets table
• SELECT id, user_id FROM `dto85_cbsubs_payment_baskets` WHERE id IN (1206, 1830, 2400, 2483)
• Run a SQL query against the comprofiler table
• SELECT * FROM `dto85_comprofiler` WHERE user_id IN (2147, 3798, 3331, 3721)
None of the resulting user ID show up in the user table.
Any help with this would be greatly appreciated. Is there a way to restore these lost users and get a list of those that should have had active memberships so we can reach out to them and recover gracefully?