ich bin am aktualisieren meines OTRS 5.0.20 auf die v6.0.2. Dabei konnte ich mich schon bis zum DBUpdate durcharbeiten.
Wenn ich DBUpdate-to-6.pl laufen lasse, bingt er mir folgendes:
Code: Select all
Error: The setting character_set_database needs to be 'utf8'.
Code: Select all
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
Code: Select all
mysql> show session variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show global variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
Code: Select all
SHOW TABLE STATUS FROM otrs;
Ich frage mich, was das Script noch auszusetzen hat? Hat jemand eine Idee?
Vielen Dank für eure Hilfe und Grüße
Chris