+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Can't save document (/showthread.php?tid=722)
Can't save document - Guido1982 - 09-14-2017
I'm getting a
Sorry! Attempt to access restricted file.
We are looking for this file path: modules//.php
When trying to save a Document. No idea what this could be. Anyone have any clues?
Hm, I shortened the title and all was well.
RE: Can't save document - joebordes - 09-14-2017
Ah, MySQL Strict
This is one of the many things I have pending. We have dedicated a lot of time to making coreBOS work corretly with MySQL Strict mode. The one thing we haven't gotten around to yet is controlling the length of the fields.
In MySQL strict mode, if you try to insert a text into a varchar field that is longer than what fits there, you get an error and the whole process is aborted.
Suppose you have a field defined as varchar(5) and try to insert there STRING, the insert will fail. Before MySQL strict you got your string truncated: STRIN
What needs to be done is to calculate the length of all fields in the database, write that into the vtiger_field table and then add validations accordingly before you try to save.
anyone up to the challenge?