Roland
Member
Hi Rob, hi Hugh,
for me as I have big tables (30,000 books) it is important to keep the database as small as possible. I designed the field sizes eyplicitly to the values that are needed. E.g. there are fields with a size of one byte only.
My problem is, that fabrik changes the field size of elements when I edit the element in the backend. The "maximum length" that can be defined by fabrik seems to be ignored. Even when I explicitly set the value "maximum length" to 120 - fabrik changes the database field to "varchar(255)".
Additionally it always changes the settings "Standard value" from empty to "Null" and the field "Null" from "no" to "yes".
That means after each modification of an element, I have to set back my fields with phpMyAdmin. Quite often, to preserve my fields, I directly edit the values in the table fabrik_elements by phpMyAdmin to be sure that my fields will not be changed.
It would be a great deal if fabrik would set the field size to size of the "Maximum length" but leave all other values as they are.
Roland
for me as I have big tables (30,000 books) it is important to keep the database as small as possible. I designed the field sizes eyplicitly to the values that are needed. E.g. there are fields with a size of one byte only.
My problem is, that fabrik changes the field size of elements when I edit the element in the backend. The "maximum length" that can be defined by fabrik seems to be ignored. Even when I explicitly set the value "maximum length" to 120 - fabrik changes the database field to "varchar(255)".
Additionally it always changes the settings "Standard value" from empty to "Null" and the field "Null" from "no" to "yes".
That means after each modification of an element, I have to set back my fields with phpMyAdmin. Quite often, to preserve my fields, I directly edit the values in the table fabrik_elements by phpMyAdmin to be sure that my fields will not be changed.
It would be a great deal if fabrik would set the field size to size of the "Maximum length" but leave all other values as they are.
Roland