Project

General

Profile

Actions

Bug #93534

open

Insufficient database type for (several) title properties

Added by Florian Wessels about 3 years ago. Updated 9 months ago.

Status:
New
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

Actions #1

Updated by Benni Mack 9 months ago

  • Sprint Focus set to On Location Sprint
Actions

Also available in: Atom PDF