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…