Issue Bug Closed

#14513general problems with fulltext keys in tables (extension manager failures)

old_jmziem 01/27/05, 18:18 updated 08/12/06, 14:19

Description

if you use dbal(or even the old t3 system) the mapping of keys generate within
typo3\em\index.php funtion checkDBupdates()
->linked within install->getDatabaseExtra(…)
is simply wrong. the sql wrapper classes (class.db*, class.sql_*) only knows primary keys, [unique] keys and nothing else.

so if you add a fulltext key within your table, this extension manager ALWAYS want’s to update the table, and it produces ALWAYS a table error – of course.

create an extension, and add within the ext_tables.sql within the table a fulltext index over a text field. this ALWAYS reproduced that error.

the problem itself came (i think) from field $diff:
em->index.php line 3576 (function checkDBupdates) where the getDatabaseExtra() stores the fulltext key as “unknown” and so as “FIELD” instead of key mark.
so the diff always failed.

i didn’t understand the confusing system within the sql wrapper which tests and extracts all keys… so i couldn’t fix it alone.
(issue imported from #M718)

Reviews 0

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