Studio issue

suiteCRM 7.5.3

Hi All

I have a large number of fields to add to the projects module layout form and find that I hit what seems to be a limit.

All fields add with no problem
When using the layout system it becomes a bit sluggish and unresponsive.
I get to a limit of adding fields and I am unable to continue to add any more.

I have removed a number of check box fields and replaced them with multi select one to reduce the number of fields I need however I still seem to hit the limit.

I have tried:-

Other browsers
Creating the panels and filters in other areas
Changing themes

I was wondering if the field this information is stored in, in the mysql database might have reached a limit.

Any ideas? I’m not sure if its a bug or there is something I am missing

Thank you

Are you sure it’s a limit? What if it is some detail in one of the fields that SuiteCRM doesn’t handle well?

Can you find anything in the logs to give you a clue?

You could also add the fields from custom files instead of using Studio. This will probably be quicker for so many fields.

Thank you for the reply.

I’m not sure there is a limit but I have redesigned a large amount of the form with the same result.
It isn’t specific to any one field, after the redesign the form reached a “limit” and I couldn’t added any field.
I looked in the metadata file and seems like it is all in order i could be wrong the size is around 62kb.

I will look into creating an custom view if the new shorter version I am working on does’t work.

I have looked in the logs but there is nothing but cron errors in there.

Chris

Apologies for going off on a tangent, but if Studio is having trouble handling so much stuff, I really pity your users… : - )

Can’t you redesign that database? Find some pattern between the fields and group them as separate items in a related table?

I don’t know your dataset, but peeking at the screenshot you posted earlier, I would say you could try having a separate entity called “room”, and so each room would be a row in a related table, with its own notes fields, etc. Things would look much tidier.

Thanks for your comments. I have done a small amount of data normalising already. The info is based on new house builds and as such has quite a lot of data collection to do with as it cover the whole build. Although I am able to create data tables and create this in the backend fairly well my limitation is time and frontend ability. My background is more dotnet so quite a leap over to php.

I think if this time I come across the same issue I will look at creating by own module/view.

Thanks again

Hi

Have now found a solution.

php was throwing a max_input_vars error.

Solution

In the php.ini file I had to change the default limit on max_input_vars from 1000 to 10000. Not sure what the implication of this might be but I will change this back at a later date to see what effect this has.