Patch #34218
open
Increase size of value field in settings
Added by Aleksandar Pavic over 3 years ago.
Updated 3 months ago.
Description
Size of value is text field which is around ~64kb.
In some cases like using some of plugins, errors like this might arise:
Mysql2::Error: Data too long for column 'value' at row 1: UPDATE settings SET value = '---\nprojects:\n 45:\n helpdesk_answer_from:
This patch increases size of text field to larger format.
Files
- Target version set to 6.0.0
Setting the target version to 6.0.0.
We are sure that it is a good ideea to increase the size on the column to such a big value for settings table that is very used? Maybe some plugin developers should store these kind of settings in their own table.
I would like to have more feedback on this before committing.
Currently, both PostgreSQL and SQLite allow 1GB of text. 64 KB for MySQL is quite small compared to those, so I think the upper limit could be increased.
This difference may cause a problem that a plugin works with PostgreSQL and SQLite but does not work with MySQL.
Go MAEDA wrote in #note-4:
Currently, both PostgreSQL and SQLite allow 1GB of text. 64 KB for MySQL is quite small compared to those, so I think the upper limit could be increased.
This difference may cause a problem that a plugin works with PostgreSQL and SQLite but does not work with MySQL.
I don't want to be against of this change, I just wanted to point my concern.
Also available in: Atom
PDF
Updated by 
Updated by