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):

  1. Open phpMyAdmin
  2. Navigate to payplans_subscription table
  3. Click SQL tab
  4. 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

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *