Joomla – Find Specific PayPlans Fields In MySQL Database
Goal: Delete ALL PayPlans No-status (status=0) memberships.
In MySQL, locate all PayPlans memberships that have status=0. (The No-status (status=0) memberships are a broken remnant of the previous database migration):
- Open phpMyAdmin
- Navigate to payplans_subscription table
- Click SQL tab
- Run the following script:
SELECT *
FROM `xxxx_payplans_subscription`
WHERE status=0
Also check the following PayPlans tables to make sure a membership is fully deleted:
- xxxx_payplans_invoice
- xxxx_payplans_order
- xxxx_payplans_transaction
- xxxx_payplans_payment