Response Time
24 — 48 hours
We have been using Payplans for more than 10 years, but are really struggling with strange problems after updating to PayPlans 4. Plans mysteriously get deleted, wrong information is sent out on email notifications, subscriptions are created and paid without invoices being assigned, credit card payments give IPN errors etc.
Its a complete disaster zone and I absolutely zero confidence in PayPlans at this point in time.
The only solution I can think of to restore sanity to my web community is to do a full re-install of PayPlans, removing any vestiges of old plugins, system files and other history which may be affecting the component.
However, we have more than 15 000 users who all have existing plans, so we need some way to extract the data, scrub it and re-import it into the database.
I have reasonable DB skills and can do the data export/import and scrubbing.
However, I'm not sure of exactly how some of the tables are linked (e.g resources table) or which tables are needed.
The only information I need to retain is the user's current subscription (Plan/status/expiry date):
(eg User ABC has plan X which is paidup and will expiry on dd-mm-yy)
In order to get this data, which DB tables do I need to export?
payplans_invoice
payplans_log
payplans_order
payplans_payment
payplans_resource
payplans_subscription
payplans_user
Am I missing any?
Alternatively, is there any way I can revert back to PayPlans 3.7?
Its a complete disaster zone and I absolutely zero confidence in PayPlans at this point in time.
The only solution I can think of to restore sanity to my web community is to do a full re-install of PayPlans, removing any vestiges of old plugins, system files and other history which may be affecting the component.
However, we have more than 15 000 users who all have existing plans, so we need some way to extract the data, scrub it and re-import it into the database.
I have reasonable DB skills and can do the data export/import and scrubbing.
However, I'm not sure of exactly how some of the tables are linked (e.g resources table) or which tables are needed.
The only information I need to retain is the user's current subscription (Plan/status/expiry date):
(eg User ABC has plan X which is paidup and will expiry on dd-mm-yy)
In order to get this data, which DB tables do I need to export?
payplans_invoice
payplans_log
payplans_order
payplans_payment
payplans_resource
payplans_subscription
payplans_user
Am I missing any?
Alternatively, is there any way I can revert back to PayPlans 3.7?
7 Replies
The replies under this section are restricted to logged in users or users with an active subscription with us
