[Translations] Translation of big webforms broken

Created on 15 December 2016, about 8 years ago

Updated 8 April 2024, 8 months ago

Problem/Motivation

There's no way to use big webforms on multilingual sites because fails to insert into locales_source.source field elements of the form.

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'source' at row 1 in                                                          [error]
/var/www/html/core/lib/Drupal/Core/Database/Statement.php:59

This because mysql BLOB limited by 64k http://cgit.drupalcode.org/drupal/tree/core/modules/locale/locale.instal...

Proposed resolution

not yet

Remaining tasks

decide how to deal with webform translation on top of config_translation

User interface changes

API changes

Data model changes

🐛 Bug report

Status

Active

Version

6.2

Component

Code

Created by

🇫🇷France andypost

Live updates comments and jobs are added and updated live.

MySQL

Incomplete comments

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 9 months ago →
🇺🇸United States jrockowitz Brooklyn, NY
Comment 8 months ago →
🇨🇦Canada joseph.olstad
Note: this only affects MySQL based systems. Postgres has ridiculously high blob limits and a different abstraction layer. This error does not occur if you're using PostgreSQL, only MySQL. I have not tested SQLite or other systems, I have only tested this scenario on PostgreSQL and MySQL/MariaDB, I found that the situation /problem is only reproducible on MySQL/MariaDB/Persona based systems when using the mysql abstraction layer.

The situation occurs when the webform is equal or larger than 65536 bytes. Sometimes the translations can be longer than the source and thus hit this limit.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024