Project

General

Profile

Actions

Bug #93534

open

Insufficient database type for (several) title properties

Added by Florian Wessels over 3 years ago. Updated 12 days 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"Resolved2024-06-13

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

Actions
Actions #1

Updated by Benni Mack 11 months ago

  • Sprint Focus set to On Location Sprint
Actions #2

Updated by Georg Ringer 19 days ago

  • Status changed from New to Accepted
Actions #3

Updated by Georg Ringer 19 days ago

  • Related to Bug #92320: Metadata extraction (saving them) crash when meta title is too long added
Actions #4

Updated by Christian Kuhn 12 days ago

  • Related to Task #104098: Auto-create DB fields from TCA columns for type "input" added
Actions #5

Updated by Christian Kuhn 12 days ago

  • Description updated (diff)
Actions #6

Updated by Christian Kuhn 12 days ago

Actions #7

Updated by Gerrit Code Review 12 days ago

  • Status changed from Accepted to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/84751

Actions

Also available in: Atom PDF