Skip to content

Instantly share code, notes, and snippets.

@jaguerra

jaguerra/check.sql

Created March 30, 2015 08:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jaguerra/6a2f9e7149be93afd750 to your computer and use it in GitHub Desktop.
Save jaguerra/6a2f9e7149be93afd750 to your computer and use it in GitHub Desktop.
Download ZIP
Check and migrate all HTML cObjects from the database while upgrading to TYPO3 CMS 6.2
Raw
check.sql
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
Raw
upgrade.sql
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