Issue Bug Closed

#18781field tablename in sys_refindex too short

Vladimir Podkovanov 05/14/08, 09:15 updated 08/12/10, 13:16

Description

When I’m using intermediate table in IRRE relations
I’m getting such error

caller t3lib_DB::exec_INSERTquery

ERROR Duplicate entry ‘77e032659be3cf41758181f06f337bd3’ for key 1

lastBuiltQuery INSERT INTO sys_refindex
(
tablename,
recuid,
field,
flexpointer,
softref_key,
softref_id,
sorting,
deleted,
ref_table,
ref_uid,
ref_string,
hash
) VALUES (
’tx_sfterminals_person_attrcat_rel_attr_rel’,
’26’,
’attr_id’,
’‘,
’‘,
’‘,
’0’,
’0’,
’tx_sfterminals_attr’,
’16’,
’‘,
’77e032659be3cf41758181f06f337bd3’
)

I’ve traced that to the fact that table name tx_sfterminals_person_attrcat_rel_attr_rel doesn’t fit into field in sys_refindex and this cause wrong handling of ref index so duplication error occures. If the field enlarged there is no error.

(issue imported from #M8399)

Reviews 0

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