Issue Bug Closed

#93534Insufficient database type for (several) title properties

Florian Wessels 02/17/21, 13:36 updated 10/05/26, 20:25

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

Reviews 1

Files 1

History 913

  1. Gerrit Code Review pushed patch set 1 for main to change 84751 status Accepted Under Review <span data-processor="relativetime" data-value="2024-06-18T09:30:39+00:00" > 06/18/24, 09:30 </span>

  2. Georg Ringer commented and changed status New Closed <span data-processor="relativetime" data-value="2026-10-05T20:25:35+00:00" > 10/05/26, 20:25 </span>

    fixed with #110770 for main (15). as this can be easily changed by an integrator this won’T be changed in v14