Issue Bug Closed

#15993Database Analyser :: Update required tables :: COMPARE

Toralf Lenz 04/06/06, 11:16 updated 04/12/06, 21:06

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.