Studio issue

đź’¬ General Discussion
1

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

2

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.

3

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

4

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.

5

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

6

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.