Hallo Zusammen,
was ich auch mache, aus irgendeinem Grund schaffe ich es nicht ein Typo3 System ohne Probleme zu aktualisieren. Folgende Situation:
Typo3 Update von 4.3.3 auf 4.5.2
Ausgangs System:
MySQL 5.0,
Zeichensatz = utf8,
Kollation der Verbindung = utf8_general_ci
Kollation der einzelnen Spalten der Tables = latin1_swedish_ci
Sonderzeichen stehen wie folgt in der DB: „ä“
FE und BE im T3 4.3.3: Alles wird korrekt dargestellt.
localconf:
<?php
$TYPO3_CONF_VARS['SYS']['sitename'] = 'New TYPO3 site';
// Default password is "joh316" :
$TYPO3_CONF_VARS['BE']['installToolPassword'] = 'xxx';
$typo_db_extTableDef_script = 'extTables.php';
## INSTALL SCRIPT EDIT POINT TOKEN - all lines after this points may be changed by the install script!
$TYPO3_CONF_VARS['BE']['installToolPassword'] = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$typo_db_username = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$typo_db_password = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$typo_db_host = 'localhost'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['sitename'] = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['encryptionKey'] = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['BE']['disable_exec_function'] = '0'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['gdlib_png'] = '0'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['im_combine_filename'] = 'composite'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['im_version_5'] = 'im6'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['TTFdpi'] = '96'; // Modified or inserted by TYPO3 Install Tool.
$typo_db = 'db323400928'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['compat_version'] = '4.3'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 12-04-10 14:54:30
// Updated by TYPO3 Core Update Manager 12-04-10 14:54:44
$TYPO3_CONF_VARS['SYS']['curlUse'] = '1'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 12-04-10 14:55:07
$TYPO3_CONF_VARS['EXT']['extConf']['static_info_tables'] = 'a:2:{s:7:"charset";s:5:"utf-8";s:12:"usePatch1822";s:1:"1";}'; // Modified or inserted by TYPO3 Extension Manager.
$TYPO3_CONF_VARS['FE']['compressionLevel'] = '5'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 11-05-10 16:16:35
// Updated by TYPO3 Extension Manager 25-05-10 14:37:11
@include(PATH_typo3conf.'urltoolconf_realurl.php'); // RealUrl-Configuration inserted by extension aeurltool
$TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['EXT']['noEdit'] = '0'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 07-06-10 16:56:10
// Updated by TYPO3 Extension Manager 11-06-10 09:39:16
$TYPO3_CONF_VARS['SYS']['no_pconnect'] = '1'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['BE']['compressionLevel'] = '5'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 08-07-10 14:18:04
// Updated by TYPO3 Extension Manager 08-07-10 14:23:36
$TYPO3_CONF_VARS['SYS']['useCachingFramework'] = '1'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 08-07-10 14:28:54
// Updated by TYPO3 Extension Manager 10-02-11 16:26:34
?>
Typo3 Update:
MySQL Dump und import in eine neue leere MySQL 5.0 DB.
Aufbau, Kollation, etc., 1:1 wie in der alten DB
T3 Update über Installtool.
Localconf der neuen Version:
<?php
$TYPO3_CONF_VARS['SYS']['sitename'] = 'New TYPO3 site';
// Default password is "joh316" :
$TYPO3_CONF_VARS['BE']['installToolPassword'] = 'xxx';
$typo_db_extTableDef_script = 'extTables.php';
## INSTALL SCRIPT EDIT POINT TOKEN - all lines after this points may be changed by the install script!
$TYPO3_CONF_VARS['BE']['installToolPassword'] = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$typo_db_username = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$typo_db_password = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$typo_db_host = 'localhost'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['sitename'] = 'xxxx'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['encryptionKey'] = 'xxx'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['BE']['disable_exec_function'] = '0'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['gdlib_png'] = '0'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['im_combine_filename'] = 'composite'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['im_version_5'] = 'im6'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['GFX']['TTFdpi'] = '96'; // Modified or inserted by TYPO3 Install Tool.
$typo_db = 'db363973913'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['compat_version'] = '4.5'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 12-04-10 14:54:30
$TYPO3_CONF_VARS['EXT']['extConf']['static_info_tables'] = 'a:2:{s:7:"charset";s:5:"utf-8";s:12:"usePatch1822";s:1:"1";}'; // Modified or inserted by TYPO3 Extension Manager.
// Updated by TYPO3 Core Update Manager 12-04-10 14:54:44
$TYPO3_CONF_VARS['SYS']['curlUse'] = '1'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 12-04-10 14:55:07
// Updated by TYPO3 Extension Manager 11-05-10 15:53:35
$TYPO3_CONF_VARS['FE']['compressionLevel'] = '5'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 11-05-10 16:16:35
// Updated by TYPO3 Extension Manager 25-05-10 14:37:11
@include(PATH_typo3conf.'urltoolconf_realurl.php'); // RealUrl-Configuration inserted by extension aeurltool
$TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['EXT']['noEdit'] = '0'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 07-06-10 16:56:10
// Updated by TYPO3 Extension Manager 11-06-10 09:39:16
$TYPO3_CONF_VARS['SYS']['no_pconnect'] = '1'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['BE']['compressionLevel'] = '5'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 08-07-10 14:18:04
// Updated by TYPO3 Extension Manager 08-07-10 14:23:36
$TYPO3_CONF_VARS['SYS']['useCachingFramework'] = '1'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Extension Manager 10-02-11 16:26:34
// Updated by TYPO3 Install Tool 08-04-11 15:06:11
// Updated by TYPO3 Extension Manager 08-04-11 15:06:36
$TYPO3_CONF_VARS['INSTALL']['wizardDone']['tx_coreupdates_installsysexts'] = '1'; // Modified or inserted by TYPO3 Upgrade Wizard.
// Updated by TYPO3 Upgrade Wizard 08-04-11 15:06:36
// Updated by TYPO3 Extension Manager 08-04-11 15:13:36
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;\' . LF . \'SET CHARACTER SET utf8;\' . LF . \'SET SESSION character_set_server=utf8;'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['SYS']['UTF8filesystem'] = '1'; // Modified or inserted by TYPO3 Install Tool.
$TYPO3_CONF_VARS['BE']['versionNumberInFilename'] = '0'; // Modified or inserted by TYPO3 Install Tool.
// Updated by TYPO3 Install Tool 12-04-11 12:16:14
?>
Typoscript
page.config.locale_all = de_DE.utf8
page.config.metaCharset = utf-8
page.config.additionalHeaders = Content-Type:text/html;charset=utf-8
Ergebnis: Im Backend und Frontend werden alle Sonderzeichen falsch dargestellt bzw. nicht umgewandelt. (...haben wir eine perfekte Lösung...)
Was habe ich vergessen? Oder wo könnte der Fehler liegen?
Typo3 4.5 zwingt ja zur forcecharset utf-8, aber das kann es nicht sein, da die alte Version schon darauf eingestellt war.
Vielleicht weiß jemand Rat. Würde mich freuen!
P.S. Aus Gründen der Übersichtlichkeit, habe ich die extList aus den beiden localconfs entfernt.