TYPO3数据库从流体含量迁移到通量 [英] TYPO3 Database migration from fluidcontent to flux

问题描述

我想通过去除过时的流体含量从流体含量转换为通量. 如此处 https://github.com/FluidTYPO3/fluidcontent/issues/424

I want to switch from fluidcontent to flux by removing the obsolete fluidcontent. As mentioned in here https://github.com/FluidTYPO3/fluidcontent/issues/424,

您必须将tt_content表中所有fluidcontent对象的CType从fluidcontent_content更改为extensionnamewithoutunderscores_templatenamewithoutunderscores. 是否可以使用迁移脚本或SQL语句?

you have to change the CType for all fluidcontent objects in the tt_content table from fluidcontent_content to extensionnamewithoutunderscores_templatenamewithoutunderscores. Is there a migration script or a SQL statement available for this?

没有Undescores的表名是文件名.为什么和在哪里需要flux:form的ID?

The tablename without Undescores is the filename. Why and where do i need the id of the flux:form?

推荐答案

同事制作了一条SQL语句，该语句将所有fluidcontent CTypes转换为正确的通量值:

A colleague made a SQL statement, which converts all fluidcontent CTypes to the correct flux value:

UPDATE tt_content 
 SET CType = LOWER(REPLACE(REPLACE(tx_fed_fcefile, 'YourNamespace.YourExtension:', 'flux_'), '.html', ''))
 WHERE CType = 'fluidcontent_content';

您只需要更改YourNamespace.YourExtension.您可以在tx_fed_fcefile行中找到YourNamespace.YourExtension的正确措词.

You only have to change YourNamespace.YourExtension. You can find the right wording for YourNamespace.YourExtension in the tx_fed_fcefile row.

由于某些原因，我不得不将CType替换为flux_templatenamewithoutunderscores而不是extensionnamewithoutunderscores_templatenamewithoutunderscores

For some reasons i had to replace the CType to flux_templatenamewithoutunderscores not to extensionnamewithoutunderscores_templatenamewithoutunderscores

这篇关于TYPO3数据库从流体含量迁移到通量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！