Project

General

Profile

Actions
Copy link

Defect #24006

closed

Add character limitation on description field for MySQL

Added by Helder Manuel Torres Vieira about 8 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:

0%

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

Related to Redmine - Feature #19869: Consider increasing the size limit of description and note columns for ticketsClosed

Actions
Related to Redmine - Defect #20127: The description column in the issues table is too short (MySQL)ClosedJean-Philippe Lang

Actions
Actions
Copy link

Also available in: Atom PDF