Would be a problem to create 180 custom fields

  • Posts: 25
  • Thank you received: 0
8 years 5 months ago #243271

-- HikaShop version -- : 3.5.6
-- Joomla version -- : 3.5.2
-- PHP version -- : 5.4
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields

Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
8 years 5 months ago #243291

Hi,

It's not a problem.
MySQL can handle up to 4000 columns in a table.
Of course, the more columns in the table, the slower the queries are so it's best to try to not have too many of them. But 200 should still be fine unless you have hundred of thousands of entries in the table.

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

  • Posts: 25
  • Thank you received: 0
8 years 5 months ago #243374

Thanks for the answer and i would like to ask you the 180 fields are going to field text fields is there any way that i could create them by mysql o duplicate one 100 times XD

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
8 years 5 months ago #243382

Hi,

You would have to add the columns in the destination table by hand via phpmyadmin and then run an export/import on the hikashop_field table to create the corresponding entries there.
So it's possible if you know your way around in phpmyadmin.

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

Time to create page: 0.061 seconds
Powered by Kunena Forum