Issue Bug Closed

#15915Database Analyser does not create sys_refindex if multiplyDBfieldSize is set

Andreas Otto † 03/28/06, 09:54 updated 08/12/06, 14:16

Description

Using the “Compare”-function from the Database Analyser fails to create the table “sys_refindex” with the following error message if $TYPO3_CONF_VARS[SYS][multiplyDBfieldSize]=2 is used (the database analyser than tries to create a field of type TEXT instead of VARCHAR):

BLOB/TEXT column ‘ref_string’ used in key specification without a key length

To solve this a length has to be assigned to the key referencing the column “ref_string”.

This happens because MySQL needs to know how many bytes of a BLOB column should be indexed. See [1] for an explanation.

The MySQL version used on the server- or client-side is not relevant here.

This error is likely to happen in other extensions as well when index is used on BLOB columns.

[1]<http: groups.google.com group mailing.database.myodbc msg></http:>

(issue imported from #M3015)

Reviews 0

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