Bug #44911
closedTranslation of sys_category record throw SQL error
100%
Description
If I try to translate a category record (sys_category table), I get the following SQL error:
Table 'dev_typo3_6.tx_taxonomy_domain_model_concept' doesn't exist
A SQL error occurred. This may indicate a schema mismatch between TCA and the database. Try running database compare in the Install Tool.
I compare the database with TCA and everything is fine. This table doen't exist.
I looked into t3lib/stddb/tca_sys_category.php and find the following configuration at line 47:
'foreign_table' => 'tx_taxonomy_domain_model_concept',
'foreign_table_where' => 'AND tx_taxonomy_domain_model_concept.uid=###REC_FIELD_l10n_parent### AND tx_taxonomy_domain_model_concept.sys_language_uid IN (-1,0)'
For my option, this definition is wrong. If I change it to the following code, if works fine:
'foreign_table' => 'sys_category',
'foreign_table_where' => 'AND sys_category.uid=###REC_FIELD_l10n_parent### AND sys_category.sys_language_uid IN (-1,0)'
It looks like a copy and past error in the process of renaming the category extension to include it into the TYPO3 core.