Defect #24006

Add character limitation on description field for MySQL

Added by Helder Manuel Torres Vieira about 1 year ago. Updated about 1 year ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
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:

mysql_2.png (26.6 KB) Helder Manuel Torres Vieira, 2016-10-05 20:13

mysql_1.png (183 KB) Helder Manuel Torres Vieira, 2016-10-05 20:13

mysql_3.png (254 KB) Helder Manuel Torres Vieira, 2016-10-05 20:13

mysql_4.png (242 KB) Helder Manuel Torres Vieira, 2016-10-05 20:13

add_description_limit_mysql_adapter.diff Magnifier (666 Bytes) Helder Manuel Torres Vieira, 2016-10-05 20:14


Related issues

Related to Redmine - Feature #19869: Consider increasing the size limit of description and not... Closed
Related to Redmine - Defect #20127: The description column in the issues table is too short (... Closed

History

#1 Updated by Toshi MARUYAMA about 1 year ago

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

#2 Updated by Jean-Philippe Lang about 1 year 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.

#3 Updated by Go MAEDA about 1 year ago

  • Related to Defect #20127: The description column in the issues table is too short (MySQL) added

#4 Updated by Go MAEDA about 1 year ago

  • Status changed from New to Closed
  • Resolution set to Fixed

Resolved in r15905 (#20127).

Also available in: Atom PDF