Issue Bug Closed

#15480fields in sys_refindex too short

Christian Welzel 01/22/06, 12:34 updated 08/12/06, 14:18

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.