By Finn Hyttel on Monday, 09 October 2017
Replies 15
Likes 0
Views 1K
Votes 0
Hello KL,

Yesterday we bought PayPlans and have this morning upgraded our PayPlans in a test on one of our development sites.

We go this error:

1146
Table 'main1_dev2.#__pf_membership_subscription' doesn't exist. We don't use Project Fork any more, it was removed for long time, so I don't understand why this error is coming up in the upgrade.

...and it removed what i have marked in the attached screenshot.

Before we upgrade PayPlans at our live site I would very much like Stack Ideas support to have a look on it

Admin URL is: https://gogreen-portals.com/dev2/administrator/
Username and password is the same as you have for our live site.

We are using Fastspring as our payment gateway and have developed a Fastspring plugin, which you maybe can use at Stack Ideas as one of your plugins.

There have gone a lot of configuration and setup to our Fastspring and PayPlans which I really hope we can reuse in our upgraded version of PayPlans.

Please make sure that you only use DEV2, lour development site for this, up to we know that the upgraded PayPlans is working. We don't want any problems at our live site, where we are running several campaigns.

Thank you,

Best,
...Finn
Hello,

I have checked your site and backend is working fine , but on frontend this error is coming, can you please tell me if any customization done on your site.

you are using payplans version 3.3.6 at your dev site , if any customization then take backup otherwise changes will lost after updating payplans.
·
Monday, 09 October 2017 12:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Manisha,

To be quite honest with you I would like to overwrite all customization if I knew an alternative way of adding:

Maximun Extra Team Members
Team Members Included
Price Of Exstra Team Members

The present version which we downloaded this morning from Stack Ideas is; com_payplans_full_pro_3.5.5_joomla, so we don't have version com_payplans_full_pro_3.5.6_joomla

But even we installed com_payplans_full_pro_3.5.5_joomla I only see version 3.3. Please also see the attached screenshots.

This is our customization:


4 PayPlan
Template Override
- Plan Layout Override
o /public_html/templates/rt_anacron/html/com_payplans/plan/default_plan.php
o /public_html/templates/rt_anacron/html/com_payplans/plan/default.php
o /public_html/templates/rt_anacron/html/com_payplans/plan/default_group.php
o /public_html/templates/rt_anacron/html/com_payplans/plan/default_login.php
o /public_html/templates/rt_anacron/html/com_payplans/plan/default_login_plan.php
- Subscription Layout Override
o /public_html/templates/rt_anacron/html/com_payplans/subscription/default_view.php
o /public_html/templates/rt_anacron/html/com_payplans/subscription/default_subscription_action.php
o /public_html/templates/rt_anacron/html/com_payplans/subscription/default_order_cancel.php
o /public_html/templates/rt_anacron/html/com_payplans/subscription/default_display.php
- Invoice Layout Override
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default_confirm.php
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default_confirm_details.php
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default_plan_details.php
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default_invoice_action.php
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default_discount.php
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default_complete.php
o /public_html/templates/rt_anacron/html/com_payplans/invoice/default.php
- Order Layout Override
o /public_html/templates/rt_anacron/html/com_payplans/order/default_terminate_confirm.php
o /public_html/templates/rt_anacron/html/com_payplans/order/default_terminate.php
- Payment Layout Override
o /public_html/templates/rt_anacron/html/com_payplans/payment/default_pay.php
o /public_html/templates/rt_anacron/html/com_payplans/payment/default_complete_error.php
o /public_html/templates/rt_anacron/html/com_payplans/payment/default_complete_cancel.php

- There are other folder override but the most important is above overrides
o /public_html/templates/rt_anacron/html/com_payplans/user
o /public_html/templates/rt_anacron/html/com_payplans/support

PayPlan Components
- /public_html/components/com_payplans/controllers/payment.php

PayPlan Plugins
FastSpring Payment Plugin for PayPlan
- /public_html/plugins/payplans/fastspring/*



I can back the above up, but I am not sure if it will overwrite anything in our new version of PayPlans - version 3.5.5 which will make any problems for this new version.

...Finn
·
Monday, 09 October 2017 14:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

You have template overriding, which will not lost after updating payplans, but change in core file also , so please take backup of site before update.

As your site is at payplans 3.3.6 , so you need to install 3.5.5 using installer you have downloaded for payplans 3.5.5 , after installing PayPlans 3.5.5 , you need to download installer for payplans 3.6.3, install it.

Let me know if you have any confusion.
·
Monday, 09 October 2017 15:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

We have tried to update our live site, but it is not working. The installation take place and the migration and backup - everything shows it is successful but we are still on version 3.3.

Please see the attached screenshots.

Please help us out.

...Finn
·
Tuesday, 10 October 2017 16:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Please check now payplans is updated to version 3.5.5 , now you can install payplans 3.6.3.
Let me know if still it's not working.
·
Wednesday, 11 October 2017 01:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Manisha,

We thought it was a good idea to test 3.5.5 before we upgraded our live site to 3.6.3.

We did the following two tests for the two below subscriptions:

From here; https://www.gogreen-portals.com/gogreen-portals-plans

Basic; https://www.gogreen-portals.com/component/payplans/plan/login/2?Itemid=116
Essential; https://www.gogreen-portals.com/component/payplans/plan/login/3?Itemid=116

Straight away without deploying any overwrites - First part is working including the EasySocial form, when we submit the form the front-end goes into white meaning the Fastspring gateway is not coming up as before the upgrade to 3.5.5. The new user are registered in EasySocial. The user are also registered in PayPlans with; "No Status"

Deploying the template overwrites and the - /public_html/components/com_payplans/controllers/payment.php overwrite - First part is working including the EasySocial form, when we submit the form the front-end goes into white meaning the Fastspring gateway is not coming up as before the upgrade to 3.5.5. The new user are registered in EasySocial. The user are also registered in PayPlans with; "No Status"

You can see the four test suscriptions in the attached screenshot.

This is the last test URL where it goes into white screen; https://www.gogreen-portals.com/component/payplans/invoice/confirm/8O56WJCMA6TD

Please help us out to get the Fastspring payment gateway working like it did before upgrade to 3.5.5

Thank you.

...Finn
·
Wednesday, 11 October 2017 10:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

First we need to verify whether this issue also happen in our original code. Please take backup of your customization and then revert the customization, so we can continue to check this issue.
·
Wednesday, 11 October 2017 12:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Manisha,

The first test we did was without the overwrites.

The below is from my above previous support ticket.

Straight away without deploying any overwrites - First part is working including the EasySocial form, when we submit the form the front-end goes into white meaning the Fastspring gateway is not coming up as before the upgrade to 3.5.5. The new user are registered in EasySocial. The user are also registered in PayPlans with; "No Status"

So there is no need to revert because we have already tested it.

...Finn
·
Wednesday, 11 October 2017 13:19
·
0 Likes
·
0 Votes
·
0 Comments
·
ok, i'll check this issue and update you.
·
Wednesday, 11 October 2017 16:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Manisha,

How are you doing?

We have ongoing campaigns and today we release three major share sales and Ambassadors campaigns, so it would be could to have our PayPlans Plans and Fastspring working.

I tested it again this morning and I got this error;

1146
Table 'main1_gogreen.#__pf_membership_subscription' doesn't exist

As explained earlier we uninstalled Project Fork for long time ago so the above table should not be missing at all.

I also discovered that the plans in the attached screenshot can't be published after we upgraded PayPlans from 3.3 to 3.5.5.

I hope you will have some good news for me later today.

I wish you and the Stack Ideas Team a great day in KL.

...Finn
·
Friday, 13 October 2017 09:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

We have checked your site and found that this issue is coming due to your custom code. #__pf_membership_subscription this table is not related to payplans , it's created by you for customization. That's why this giving the error.
Override template path : JoomlaFolder/templates/rt_anacron/html/com_payplans/invoice/default_confirm.php
http://take.ms/S02BG

Please try to after changing template to protostar, and it's working fine.
http://take.ms/EnceI

Don't modify your template overriding and core file in payplans , try consult with your developer to fix your current customization issue, because our support policy do not cover customization issue, thanks for understand.

Let me know if you have any query.
·
Friday, 13 October 2017 12:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Manisha,

Thank you for your reply.

I have tried to open your take.ms screenshot but the URL are not working please send them to me as a files.


...Finn
·
Friday, 13 October 2017 13:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Finn,

I've attached these 2 screenshot in my reply.
·
Friday, 13 October 2017 15:13
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post