Basically it seems we hit the limit of how much data that can be written into the leads âDescriptionâ field. Over time sales reps write of course data into it as one communicates with clients and records what has been said, agreed too, what actions taken etc.
So today I wanted to add a comment to a potential client/lead and getting this error.
Since our server has been installed with Plesk which we use to partition our server into various business functions I first contacted Plesk on their support forum (Link Plesk support thread: Simple URL Shortener), and received this answer:
Applied their suggestion but to no avail.as server server wonât accept more data in description field and hits me wit the âRequest-URI Too Longâ error
Do you guys know about this issue (With too long/too much data in the lead description field), and how to solve this and increase the allowed length?
You would go to Studio, and attempt to change the Lead Description fieldâs data type from TEXT (max 16k characters in utf8mb4) to LONGTEXT (max 1G characters in utf8mb4). If necessary, increase those Apache âadditional directivesâ to accommodate the larger max field data size, maybe 1M (256K characters) to start. Try this, and let us know how this worked for you.
So how/where do you actually do that @chris001 ?
I can only find this in the studio and there is not an option to change the data type to âLONGTEXTâ:
If the problem is with the URI in the web request, itâs not with the field size in the database.
But the real issue, I would say, is figuring out why this is going in the URI in a GET request, when it should obviously be going in a POST request where this limit would not be an issue. But as far as I know SuiteCRM uses POST, did you change or add anything?
Nothing.
I have just entered a lot of recorded client history contact information into the âdescriptionâ field. Now yesterday I wanted to add a new line of information because we just had meeting with this client and SuiteCRM and/or the server refuses to allow more data in that field.
I can without any issues remove or edit the older text entered into that field. It just pukes with that error message if I attempt to add more text into the âDescriptionâ field. So it clearly shows that I hit the max limit for how much you can type into that box/field.
Can you share the URI in the request (get it from the browserâs dev tools, network tab), after removing any sensitive or private information? You can also omit the big description text as long as we can have a look at the name of the argument.
That would be it, except that that URI is not very long, and the server is not returning an error on that one⊠I would like to have a look at the URI causing trouble. Maybe thereâs no way to get it easily, I donât know.
Canât it be the data that is sent to the description field in the DB?
I mean that is what generates the âURIâ error when you try to add more info to it.
The URI is the actual stuff you see in the browser, if the data is in there, itâs visible, as in a GET request, like http://my.site.com/?field1=something&field2=looooooooooooooong
But SuiteCRM doesnât usually send data like that, it uses POST requests, which (I believe) shouldnât trigger server errors mentioning long URIâs.
I would recommend that you keep looking for Apache configurations (donât forget to restart web server after editing config files), I donât think this is a SuiteCRM issue.
But that did not have any effect at all. Iâm kind of out of ideas Iâd must admit.
Well remember that it is the amount of data in the leads âDescription fieldâ it is actually complaining about. I cannot simple add more text in that field. I can remove/edit all data/text up to this point. But adding a few more lines of text and it pukes all over it.
I will attempt and check it later and come back when I had some time to check the live logs and do a test too. (E.g. looking at the server logs on the same time as I attempt to add more text in the description field.).
