Bug #15480
closed
fields in sys_refindex too short
0%
Description
There are some fields in sys_refindex, that are too short to hold the given data. This is no problem with mysql because it ignores this failures silently, but postgresql (using dbal) complains about that and throws errors.
example:
INSERT INTO "sys_refindex" ( "tablename", "recuid", "field", "flexpointer", "softref_key", "softref_id", "sorting", "ref_table", "ref_uid", "ref_string", "hash" ) VALUES ( 'tx_templavoila_tmplobj', '3', 'fileref', '', 'typolink', 'b2186e761677186132bff6a1dc8eedee:0', '-1', '_FILE', '0', 'fileadmin/templates/impressum_tmpl_05.html', '705087ea69f40ffd9c8a31f2b9809b9c' )
ERROR: value too long for type character varying(40)
in this case the error is caused by ref_string (42 characters)
(issue imported from #M2352)
Updated by Karsten Dambekalns almost 19 years ago
Yes, definitely a problem. Kasper, any reason this is used that way? We could either set the field size higher or always insert a substring, if this is all we need anyway.
Updated by Kasper Skårhøj almost 19 years ago
This is fixed in the next update to CVS from me.