Defect #24006
Add character limitation on description field for MySQL
| Status: | Closed | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due 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)
mysql_1.png (183 KB)
mysql_3.png (254 KB)
mysql_4.png (242 KB)
add_description_limit_mysql_adapter.diff 
(666 Bytes)
Related issues
History
#1
Updated by Toshi MARUYAMA over 5 years ago
- Related to Feature #19869: Consider increasing the size limit of description and note columns for tickets added
#2
Updated by Jean-Philippe Lang over 5 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.
#3
Updated by Go MAEDA over 5 years ago
- Related to Defect #20127: The description column in the issues table is too short (MySQL) added
#4
Updated by Go MAEDA over 5 years ago
- Status changed from New to Closed
- Resolution set to Fixed