[Skip to main content](#vessel-content)

#   Search engine in subscription list not working?

##

- **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")**
- [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author
- [ Offline](/forum/user/23273-oloccina)

Less More

- Posts: 224
- Thank you received: 8
-
-

7 years 1 month ago [\#311123](#311123) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile")  *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311123 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")* was created by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")*

Hello,
when I input a username in the search field in the subscriptions list I always get an empty result.
I have checked and the user is indeed there with an active subscription.

It seems the search engine only works for the "subscription data" column, which in my case is not really useful because it just contains a random value.
I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?

Thank you

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

7 years 1 month ago [\#311133](#311133) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311133 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

Hello

We will look into it.
Are you trying to look for the username or the user address.
Since subscription is linked to HikaShop users, the search can look faster on HikaShop userd fields (such as the email)

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")**
- [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author
- [ Offline](/forum/user/23273-oloccina)

Less More

- Posts: 224
- Thank you received: 8
-
-

7 years 1 month ago [\#311137](#311137) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile")  Replied by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311137 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

I also tried to search the user email but is still not working for me

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

7 years 1 month ago [\#311142](#311142) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311142 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

Hi,

Try changing the code: Code:

$searchMap = array( 'subscription.subscription_id', 'subscription.subscription_data', );

to:
Code:

$searchMap = array( 'subscription.subscription_id', 'subscription.subscription_data', 'hk_user.user_email', 'j_users.username', 'j_users.name', );

in the file administrator/components/com_hikaserial/views/subscription/view.html.php
That should allow you to search for the name, username and email addresses of the subscriptions.

The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")**
- [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author
- [ Offline](/forum/user/23273-oloccina)

Less More

- Posts: 224
- Thank you received: 8
-
-

7 years 1 month ago [\#311161](#311161) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile")  Replied by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311161 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

Done,
when testing a search for username (the username does exist in the list, I can see it)

Joomla throws out this error
Unknown column 'hk_user.user_email' in 'where clause'

The subscriptions list page remains blank with the error message even when reloading it,
it goes back to the normal list view when I change the edit you suggested in the code to the original code

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

7 years 1 month ago [\#311165](#311165) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311165 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

Hi,

This would indicate that you don't have the same code I have in that file. Could you tell us which version of HikaSerial you're using ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")**
- [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author
- [ Offline](/forum/user/23273-oloccina)

Less More

- Posts: 224
- Thank you received: 8
-
-

7 years 1 month ago [\#311179](#311179) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile")  Replied by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311179 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

I am using the latest version
Hikaserial 3.0.1
Hikashop 4.2.1
Joomla 3.9.11

I have sent you the access details a couple of days ago for another issue I had and you are looking into it, in case you want to acces the website/files directly

Thank you

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")**
- [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author
- [ Offline](/forum/user/23273-oloccina)

Less More

- Posts: 224
- Thank you received: 8
-
-

7 years 1 month ago -  7 years 1 month ago [\#311225](#311225) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile")  Replied by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311225 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

I have to close access to the live site for security reasons,
but I attach here my file
administrator/components/com_hikaserial/views/subscription/view.html.php

in case you need it for testing

Last edit: 7 years 1 month ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

7 years 1 month ago [\#311230](#311230) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Search engine in subscription list not working?](/forum/14-hikaserial/898312-search-engine-in-subscription-list-not-working#311230 "Hello, when I input a username in the search field in the subscriptions list I always get an empty result. I have checked and the user is indeed there with an active subscription.  It seems the search engine only works for the &quot;subscription data&quot; column, which in my case is not really useful because it just contains a random value. I need to be able to search mainly usernames, is this a bug or you plan to implement it in the future?  Thank you")*

Hello,

Thank you for the file ; I was able to see that you do have the latest version.
But in order to add a search on an extra table, it requires a bit more than the declaration of the field for the searchMap.
I will work on the modifications to add that directly in the HikaSerial next release.

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk4MzEyLXNlYXJjaC1lbmdpbmUtaW4tc3Vic2NyaXB0aW9uLWxpc3Qtbm90LXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.063 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
