Custom fields limitation

  • Posts: 299
  • Thank you received: 2
9 years 1 month ago #216783

-- url of the page with the problem -- : www.bil-filtertjanst.se
-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.4
-- PHP version -- : 5.4.42
-- Browser(s) name and version -- : N/A

HI,
Is there a limitation in the Display => Custom fields => Values listing?
My client has put in like 332 different machine types under a brand called " case/case ih/international harverster"
Now when she wants to add more and save them they won't be saved.
So I wonder if there is some kind of limitation here on how many items you can put into the values section of the Custom fields?
If there is how can we make a workaround?

Best regards
Micke

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 1 month ago #216819

Hi,

There is no limitation in the number of items you can put in the values.
However, these values are stored in the database in the column field_value of the hikashop_field table which is limited to a certain number of characters by MySQL.
For new installs of HikaShop the type of that column is "longtext" and thus you're likely to never reach the limit of the characters. But for old versions of HikaShop (which you maybe updated), that type is still the old type, which is much smaller.
So you'll want to edit that column in your phpmyadmin and change its type to longtext and you'll be able to add more values.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum