Project

General

Profile

Actions

Bug #15993

closed

Database Analyser :: Update required tables :: COMPARE

Added by Toralf Lenz over 18 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2006-04-06
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
5
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Typo3@UTF-8:

Set:
$TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8';
$TYPO3_CONF_VARS['SYS']['multiplyDBfieldSize'] = '3'; (database does not support utf-8)

Call:
Database Analyser :: Update required tables :: COMPARE

Changing fields:
(only example!)
ALTER TABLE tx_realurl_uniqalias CHANGE value_alias value_alias text NOT NULL;
Current value: varchar(255) default ''

Write to database:
SQL-Statement (in background) doesn't work if the affected field "value_alias" is indexed. ["KEY bk_realurl02 (tablename,field_alias,field_id,value_alias,expire)"]

MySQL-Error #14798: BLOB/TEXT column '%s' used in key specification without a key length

The error isn't display in the "Install Tool" but can reproduced with "phpMyAdmin" for instance.

Solution:
KEY bk_realurl02 (tablename,field_alias,field_id,value_alias(255),expire)

(issue imported from #M3149)

Actions #1

Updated by Ingmar Schlecht over 18 years ago

It is suggested to not use multiplyDBfieldSize anymore but instead configure your database correctly for the use of UTF-8. Then the database automatically reserves enough space for your fields.

You might want to ask the mailinglists for how to configue MySQL.

cheers
Ingmar

Actions

Also available in: Atom PDF