Re-installing Payplans 4
By Marc on Wednesday, 13 February 2019
Posted in General Issues
Replies 7
Likes 0
Views 548
Votes 0
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?
Hey Marc,

Sorry for the inconvenience caused to you.

# Regarding plan deletion : Let me know which plan is deleted , it's deleted after upgrade or after some time ?

# Regarding email notification and extra subscription problem, in another forum you said it's coming from module , you already correct it.Is it still coming at your end.

# Regarding credit card payments give IPN errors, What kind of error you are talking about. I didn't see any error.

Let me know do you backup of your site before upgrading to pp4, i mean pp 3.7 version backup.
If yes, then better to re-store it , because we change the db structure also for some table in pp4.

Update me with response.
Manisha Ranawat
·
Wednesday, 13 February 2019 12:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Okay.....I have a backup of 3.7 but too much time has passed, so reverting is not an option.

I can give lots of details of the various errors I'm picking up, but even if they were all resolved, I still wouldn't feel confident that other problems weren't lurking around, either from old code (remember we have used PayPlans for more than 10 years, and some of earlier stuff wasn't all good) or database related issues.

That's why I want to do a fresh install - any old code will be removed so I can eliminate it as a source of the problem.
All data will be fresh so no old issues brought forward with it.
Marc
·
Wednesday, 13 February 2019 19:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Marc,

Can you tell me when you upgrade to pp4 from 3.7 version, it few days ago or ?
I'll help you to re-install again.

Update me.
Manisha Ranawat
·
Wednesday, 13 February 2019 20:17
·
0 Likes
·
0 Votes
·
0 Comments
·
Unfortunately no...it was about 3 weeks ago. I did all the basic tests and it seemed to work fine on my test site (I should have tested on a replica of the live site but I used a fresh Joomla/EasySocial install)

After going LIVE we encountered the following key issues, amongst others:

  • Loading the Invoice view from the back-end takes about 6 minutes
  • Making any change on a plan removes all of that plan's association with apps and payment gateways
  • IPN errors from our Payment gateway
  • Wrong details on notification emails
  • Random overnight deletions of subscriptions


I can uninstall Payplans and remove every last trace of it from the system (excl. DB tables), then re-install.
However, if the issues are coming from a DB table being out of sync for some reason, it won't solve the problems.

I guess next step is to try a fresh re-install without touching the data. If that doesn't help then I will have to find a way to rebuild the data itself. Once that is done then any issues will be related to the new version and not some other interference.
Marc
·
Wednesday, 13 February 2019 20:56
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Marc,

Regading these
Loading the Invoice view from the back-end takes about 6 minutes
Making any change on a plan removes all of that plan's association with apps and payment gateways

I've already created ticket for these issue , it will be release in upcoming release asap.

IPN errors from our Payment gateway
Wrong details on notification emails
Random overnight deletions of subscriptions
Regarding these error i've tried to check on your site (https://www.kiwiklub.com), but didn't see any error regarding this.

Can you tell me steps to check this issue or you are checking on your testing site ?

Update me.
Manisha Ranawat
·
Wednesday, 13 February 2019 21:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi again,

Wrong details on notification emails:
I switched off notifications until I can resolve this issue. I will log a seperate ticket for this.

Random overnight deletions of subscriptions
Unfortunately these are random, so its hard to check an example.

IPN errors from our Payment gateway
I'm still investigating this one.
Marc
·
Thursday, 14 February 2019 05:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Marc,

Random overnight deletions of subscriptions
Unfortunately these are random, so its hard to check an example.

Can you check if it's deleting any ongoing subscription.

IPN errors from our Payment gateway
I'm still investigating this one.

ok, Update me on this , so i'll check this issue.

Thank you for understanding !
Manisha Ranawat
·
Thursday, 14 February 2019 10:30
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post