[Skip to main content](#vessel-content) # hikasubscription Error ## - **[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")** - [![iconvisual's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30593-iconvisual "View iconvisual's Profile") Topic Author - [ Offline](/forum/user/30593-iconvisual) Less More - Posts: 58 - Thank you received: 0 - - 6 years 5 months ago - 6 years 5 months ago [\#319086](#319086) by [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile") *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#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")* was created by *[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")* -- 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 - [ ![Capture_2020-05-14.PNG](/forum/attachment/49358) ](/forum/attachment/49358 "...2020-05-14.PNG") [ ](/forum/attachment/49358?download=1 "...2020-05-14.PNG") - [ ![Capture1.PNG](/forum/attachment/49359) ](/forum/attachment/49359 "Capture1.PNG") [ ](/forum/attachment/49359?download=1 "Capture1.PNG") Last edit: 6 years 5 months ago by [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 5 months ago [\#319131](#319131) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319131 "-- 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")* 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" Code: $this->getPageInfoTotal($from . $filters . $order, '*'); by Code: $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. The following user(s) said Thank You: [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")** - [![iconvisual's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30593-iconvisual "View iconvisual's Profile") Topic Author - [ Offline](/forum/user/30593-iconvisual) Less More - Posts: 58 - Thank you received: 0 - - 6 years 5 months ago [\#319154](#319154) by [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile") Replied by *[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319154 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 5 months ago [\#319167](#319167) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319167 "-- 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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")** - [![iconvisual's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30593-iconvisual "View iconvisual's Profile") Topic Author - [ Offline](/forum/user/30593-iconvisual) Less More - Posts: 58 - Thank you received: 0 - - 6 years 5 months ago [\#319297](#319297) by [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile") Replied by *[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319297 "-- 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")* Hi, Thank you will re-post in another forum. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")** - [![iconvisual's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30593-iconvisual "View iconvisual's Profile") Topic Author - [ Offline](/forum/user/30593-iconvisual) Less More - Posts: 58 - Thank you received: 0 - - 6 years 5 months ago [\#319518](#319518) by [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile") Replied by *[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319518 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 5 months ago [\#319551](#319551) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319551 "-- 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")* 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 : Code: 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")** - [![iconvisual's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30593-iconvisual "View iconvisual's Profile") Topic Author - [ Offline](/forum/user/30593-iconvisual) Less More - Posts: 58 - Thank you received: 0 - - 6 years 4 months ago [\#319944](#319944) by [iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile") Replied by *[iconvisual](/forum/user/30593-iconvisual "View iconvisual's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319944 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 4 months ago [\#319954](#319954) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[hikasubscription Error](/forum/58-hikasubscription/899854-hikasubscription-error#319954 "-- 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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzU4LWhpa2FzdWJzY3JpcHRpb24vODk5ODU0LWhpa2FzdWJzY3JpcHRpb24tZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.260 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)