hikasubscription Error

  • Posts: 58
  • Thank you received: 0
4 years 6 months ago #319086

-- HikaShop version -- : 4.2.2 business
-- HikaSerial version -- : 3.1.0
-- Joomla version -- : 3.9.6
-- PHP version -- : 7.2.30
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'hk_user.user_email' in 'where clause'

Hi
We are using
php version: 7.2.30
joomla version: 3.9.6
hikshop version: 4.2.2 business
hikaserial version: 3.1.0

Subscription works as planned. The user group is changed to subscriber group after changing the setting. The user makes a payment through payal recurring payment. Everything works thank you for the plugin but when a user cancel automatic renewal from their account through the front end there is error on the backend when we try to view the subscription.
Please find the attached images that will help to better understand the error.

Thank you

Attachments:
Last edit: 4 years 6 months ago by iconvisual.

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
4 years 6 months ago #319131

Hello,

The only place where I can find the the reference of "hk_user.user_email" is the search in the subscription listing.
It would mean that you have to replace in the file "administrator/components/com_hikaserial/views/subscription/view.html.php"

$this->getPageInfoTotal($from . $filters . $order, '*');
by
$this->getPageInfoTotal($from . $joins . $filters . $order, '*');
Please confirm if it solves your issue so we can include it as a fix in the component.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: iconvisual

Please Log in or Create an account to join the conversation.

  • Posts: 58
  • Thank you received: 0
4 years 6 months ago #319154

Thank you. Looks like it works.
I have another issue when i have two products in my cart as below:

product a subscription product - under warehouse a - shipping method a.
and product b normal product - under warehouse b - shipping method b.

paypal recurring payment restricted to shipping method a.
eway payment restricted to shipping method b.

on the payment step it shows no payment method found. So cannot checkout.
Is there a way to have different payment method like different shipping method for products in certain warehouse.
Any help would be appreciated.

Thank you

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
4 years 6 months ago #319167

Hello,

You need to create a new forum thread for that issue ; because it's related to the way that HikaShop handles the payment methods.
I can't do anything in HikaSubscription for that kind of issue ; the only setting we have is the request for the "recurring payment plugin" that you want to set optional.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 58
  • Thank you received: 0
4 years 6 months ago #319297

Hi,

Thank you will re-post in another forum.

Please Log in or Create an account to join the conversation.

  • Posts: 58
  • Thank you received: 0
4 years 6 months ago #319518

Hi
Sorry to be a pain but i really need this to work. Is there a way for customer to unsubscribe once the purchase a subscription product.
From my account section there is cancel auto renewal button But this does not change the subscription status. To test this i made a test order which will charge me daily and hit the cancel automatic renewal button. There was no charge the next day but i got charged again the following day. e.g. on 19th i purchased the product and hit cancel automatic renewal, on transaction on 20th but account charged on 21st. Does that make sense. Am i doing something wrong or is the way it is suppose to work.

Thank you

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
4 years 6 months ago #319551

Hello,

The Paypal recurring plugin is using the same API than the HikaShop paypal (classical) plugin.
That API do allow to create a subscription and receive notifications regarding its updates ; but the API do not have the access to cancel a subscription ; only the Paypal dashboard will propose that.
When a customer ask for the cancel of a subscription, he should see a message telling :

PAYPAL_RECURRING_CANCEL_INSTRUCTIONS="You need to login to your Paypal account and cancel the subscription in the preapproved payments"

Paypal REST might be able to create subscription and handle the cancellation via the API too ; but for what we saw, it requires to create the plans and subscriptions directly in the Paypal Dashboard (or use the API to create them).
That Subscription API do have the same limitations than the Stripe API ; thus the same reason why we are not fan regarding an implementation which would generate a lof of restrictions (and potentially bugs) regarding the way than customer could buy subscriptions.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 58
  • Thank you received: 0
4 years 5 months ago #319944

Hi,
I logged into paypal account as a customer and cancelled the subscription. I was hopping that the system will fire a notification email to the admin about the subscription status [cancellation] but did not get any email. Can you please let me know if this is the way it should work or there is something wrong.

Thank you

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
4 years 5 months ago #319954

Hello,

Paypal should process an IPN and call your website to mark the subscription as cancelled.
Can you please verify that you received that IPN and that the corresponding subscription is not marked a "auto renew" anymore ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.071 seconds
Powered by Kunena Forum