Project

General

Profile

Actions

Bug #93534

open

Insufficient database type for (several) title properties

Added by Florian Wessels almost 4 years ago. Updated 5 months ago.

Status:
Under Review
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2021-02-17
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:
On Location Sprint

Description

Setting the title of sys_file_metadata records to (联通智网科技有限公司董事长、总经理辛克铎先生(左一)、上海虹桥商务区管理委员会副主任费小妹女士(左二)、大陆集团中国区总裁兼首席执行官汤恩先生(右一)、闵行区人民政府副区长吴斌先生(右二)共同为联陆智能交通科技(上海)有限公司揭牌) will case a database exception.

Length:

strlen: 345
mb_strlen: 115

Current database field configuration:

  `title` tinytext COLLATE utf8mb4_unicode_ci,

This error affects all records whose properties are stored as `tinytext` in the database. For example:

  • title of sys_file_metadata
  • title of sys_file_reference
  • title of sys_file_collection
  • title of sys_collection
  • title of sys_category

Possible solution:

a) Set database type to VARCHAR
b) Add validators to the TCA


Files


Related issues 3 (2 open1 closed)

Related to TYPO3 Core - Bug #92320: Metadata extraction (saving them) crash when meta title is too longNew2020-09-16

Actions
Related to TYPO3 Core - Task #104098: Auto-create DB fields from TCA columns for type "input"Closed2024-06-13

Actions
Related to TYPO3 Core - Feature #101553: Auto-create DB fields from TCA columnsIn Progress2023-10-13

Actions
Actions

Also available in: Atom PDF