Defect #24006: Add character limitation on description field for MySQL - Redmine

Actions

Copy link

Defect #24006

closed

Add character limitation on description field for MySQL

Added by Helder Manuel Torres Vieira almost 9 years ago. Updated over 8 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Issues

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Fixed

Affected version:

3.3.0

Description

Defect Description¶

On the actual version as in the las trunk, when trying to create a new description with more than 65536 characters, Redmine answers with an error 500.

This happens when the adapter ActiveRecord of MySQL is used, as the field description is of type :text and the maximum limit that it accepts is 65536 as i explain on the next link: https://www.packtpub.com/books/content/working-rails-%E2%80%93-activerecord-migrations-models-scaffolding-and-database-completion

With this patch this problem is solved as it adds a validation in case of the adapter being MySQL.

Attached Screenshots:¶

Files

Download all files

mysql_2.png (26.6 KB) mysql_2.png		Helder Manuel Torres Vieira, 2016-10-05 20:13
mysql_1.png (183 KB) mysql_1.png		Helder Manuel Torres Vieira, 2016-10-05 20:13
mysql_3.png (254 KB) mysql_3.png		Helder Manuel Torres Vieira, 2016-10-05 20:13
mysql_4.png (242 KB) mysql_4.png		Helder Manuel Torres Vieira, 2016-10-05 20:13
add_description_limit_mysql_adapter.diff (666 Bytes) add_description_limit_mysql_adapter.diff		Helder Manuel Torres Vieira, 2016-10-05 20:14

Related issues

Actions

Copy link

Updated by Toshi MARUYAMA almost 9 years ago

Related to Feature #19869: Consider increasing the size limit of description and note columns for tickets added

Actions

Copy link

Updated by Jean-Philippe Lang almost 9 years ago

I'd rather increase the size of the description column for Mysql (as it was already done for wiki pages) in order to have the same behaviour as other DBMS. I'm assigning #20127 to 3.4.0.

Actions

Copy link