#93534Insufficient database type for (several) title properties
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_collectiontitle of sys_category
Possible solution:
a) Set database type to VARCHAR
b) Add validators to the TCA
Reviews 1
Related issues 3
Files 1
History 913
-
Benni Mack changed Sprint Focus On Location Sprint <span data-processor="relativetime" data-value="2023-08-02T14:50:33+00:00" > 08/02/23, 14:50 </span>
-
Georg Ringer changed status
NewAccepted <span data-processor="relativetime" data-value="2024-06-11T20:56:43+00:00" > 06/11/24, 20:56 </span> -
Georg Ringer changed Related to #92320 <span data-processor="relativetime" data-value="2024-06-11T20:57:33+00:00" > 06/11/24, 20:57 </span>
-
Christian Kuhn changed Related to #104098 <span data-processor="relativetime" data-value="2024-06-18T09:16:29+00:00" > 06/18/24, 09:16 </span>
-
Christian Kuhn changed description <span data-processor="relativetime" data-value="2024-06-18T09:18:19+00:00" > 06/18/24, 09:18 </span>
-
Christian Kuhn changed Related to #101553 <span data-processor="relativetime" data-value="2024-06-18T09:29:20+00:00" > 06/18/24, 09:29 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 84751 status
AcceptedUnder Review <span data-processor="relativetime" data-value="2024-06-18T09:30:39+00:00" > 06/18/24, 09:30 </span> -
Benni Mack changed Sprint Focus
On Location Sprint<span data-processor="relativetime" data-value="2025-05-05T19:27:40+00:00" > 05/05/25, 19:27 </span> -
Gerrit Code Review pushed patch set 2 for main to change 84751 <span data-processor="relativetime" data-value="2025-05-07T13:06:15+00:00" > 05/07/25, 13:06 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 84751 <span data-processor="relativetime" data-value="2025-05-08T05:54:46+00:00" > 05/08/25, 05:54 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 84751 <span data-processor="relativetime" data-value="2025-05-08T08:15:53+00:00" > 05/08/25, 08:15 </span>
-
Christian Kuhn changed status
Under ReviewNew <span data-processor="relativetime" data-value="2026-04-21T14:55:17+00:00" > 04/21/26, 14:55 </span> -
Georg Ringer commented and changed status
NewClosed <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