Project

General

Profile

Actions

Bug #23009

closed

Installtool bug with escape-signs in ['SYS']['setDBinit']

Added by Sabine Deeken over 14 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2010-06-27
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.4
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

when using the installtool "all configuration" typo3 by itself changes something in
['SYS']['setDBinit']

before:
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8'.chr(10).'SET CHARACTER SET utf8'.chr(10).'SET SESSION character_set_server =utf8'.chr(10).'SET character_set_connection = utf8'.chr(10).'';

after:
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8\'.chr(10).\'SET CHARACTER SET utf8\'.chr(10).\'SET SESSION character_set_server =utf8\'.chr(10).\'SET character_set_connection = utf8\'.chr(10).\'';

the effect is ugly: all umlauts broken in backend. no chance to fix it from installtool. grrrr.
as I am rather a designer than a programmer I was glad to find an old version of localconf.php and repair it by editor

(issue imported from #M14882)


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #21501: Install Tool duplicates values of textarea fieldsClosedSteffen Kamper2009-11-09

Actions
Is duplicate of TYPO3 Core - Bug #22964: Wrong handling of entries in textarea fields in install tool - may break installationClosedSteffen Kamper2010-06-22

Actions
Actions #1

Updated by Chris topher over 14 years ago

That's indeed an ugly bug.

Please test Steffen's patch "12514_v3.diff" from #21501.
If it works for you, please post your +1 to the thread on Core List, so that the bug fix can be integrated quickly.
See here, what to do: http://typo3.org/teams/core/core-mailinglist-rules

Actions #2

Updated by Chris topher over 14 years ago

By the way: Your SQL commands miss a ; at the end of each line.
Furthermore you only need to set the first command and character_set_server =utf8. The others then don't do anything else. For details see here:
http://wiki.typo3.org/index.php/UTF-8_support#Issues_with_.5BsetDBinit.5D

Actions #3

Updated by Sabine Deeken over 14 years ago

Steffens patch works.
I also took away the other commands.
Thank You!

Actions #4

Updated by Chris topher over 14 years ago

You're welcome!

Resolved as duplicate of #22964.

Actions #5

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF