Filter assigned categories limit

  • Posts: 1027
  • Thank you received: 11
  • Hikashop Business
6 years 1 month ago #288699

-- HikaShop version -- : 3.2.2
-- Joomla version -- : 3.8.5
-- PHP version -- : 7.0

Hello!

Is there a limit to how many categories i can assign a filter to? And if there is how can i change/remove it?
Cause hikashop won't let me add more than 20-25 categories and i have to create more than one filters that way.

Thank you in advance

Attachments:

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

  • Posts: 81484
  • Thank you received: 13062
  • MODERATOR
6 years 1 month ago #288700

Hi,

If you open the structure of the hikashop_filter table via your PHPMyAdmin, you can see that the filter_category_id column is of the type "VARCHAR 255".
And HikaShop stores in there the id of the categories you select, separated by commas.
But you're limited to 255 characters due to the type of the column.
Change the type of the column to "text" and you"ll be able to store around 65 000 characters in the field.
We use by default varchar(255) because that's more efficient (for the database MySQL queries) and it's usually enough for 99% of the merchants.
But you can change the type of the column, that's not a problem. It will still work even after the updates.

The following user(s) said Thank You: verzevoul

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

Time to create page: 0.059 seconds
Powered by Kunena Forum