Problem: WooCommerce Checkout page’s processing speed is REALLY slow (45-120 seconds to complete a transaction –> from after clicking Place Order button on Checkout page until /order-received/ Thank You page loads). After researching, the biggest culprit is the MySQL wp_postmeta table. Which has ~1 million rows. Solution: Add Keys (INDEXes) to particular tables like the…
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…
Goal: Generate 8 different monthly member reports for Califaep.org’s PayPlans-powered Joomla membership site. Solution: I’ve chosen Fabrik to query the database, display member content, filter info, and generate CSV files. Background: Califaep uses PayPlans to register members, and is using JomSocial’s custom fields to capture specific information during the registration process. Unfortunately, JomSocial’s custom fields data…