Enlarge 'field' in table 'sys_refindex' from 40 to 64
In the standard table definitions in typo3/sysext/core/ext_tables.sql, the schema definition for table sys_refindex has the size of the field called field set to varchar(40), but MySQL allows 64 characters (at least since v. 5.5).
We have field-names in our tables, which are longer than 40 characters, and thus have met this problem. It might be that the field was simply truncated previously, but now that we switch to MySQL in strict mode, we get a warning.
We also think that 40 is rather short; 64 would be more appropriate.
The change we propose is to enlarge the field varchar from 40 to 64 in ext_tables.sql:
CREATE TABLE sys_refindex ( ... field varchar(64) DEFAULT '' NOT NULL, ... );
Updated by Kasper Ligaard over 4 years ago
MySQL manual in field sizes, https://dev.mysql.com/doc/refman/5.5/en/identifiers.html