Created
March 30, 2015 08:24
-
-
Save jaguerra/6a2f9e7149be93afd750 to your computer and use it in GitHub Desktop.
Check and migrate all HTML cObjects from the database while upgrading to TYPO3 CMS 6.2
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT sys_template.config, REPLACE(config, ' HTML', ' TEXT') | |
FROM `sys_template` | |
INNER JOIN pages ON pages.uid = sys_template.pid | |
WHERE `config` REGEXP BINARY 'HTML' | |
AND sys_template.deleted = 0 AND sys_template.pid >= '0' | |
AND pages.deleted = 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE sys_template | |
SET config = REPLACE(config, ' HTML', ' TEXT') | |
WHERE `config` REGEXP BINARY 'HTML' | |
AND sys_template.deleted = 0 AND sys_template.pid >= '0' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment