Defect #20127

The description column in the issues table is too short (MySQL)

Added by Future Link Corporation pkgsrc team over 1 year ago. Updated 3 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Issues
Target version:3.4.0
Resolution:Fixed Affected version:3.0.3

Description

The description column in the issues table has a data type of TEXT, which has a limit of 65k. We recommend changing this data type to LONGTEXT, as was done for the comment field in the changesets table. As you've done this for the repository commits (#16143) already, please make this change. Otherwise, Redmine throws a 500 error on creating issues with long descriptions.


Related issues

Related to Redmine - Defect #16143: Can't insert too long comment field from repository (MySQL) Closed
Related to Redmine - Defect #24006: Add character limitation on description field for MySQL Closed
Duplicated by Redmine - Defect #18865: Size of text description of the problem Closed
Duplicated by Redmine - Defect #7779: Error 500 when issue description is too long Closed 2011-03-04
Duplicated by Redmine - Feature #19869: Consider increasing the size limit of description and not... Closed
Duplicated by Redmine - Defect #24397: this text in description or note cause an internal server... Closed

Associated revisions

Revision 15905
Added by Jean-Philippe Lang 3 months ago

Raises length of issue description and journals for MySQL (#20127).

History

#1 Updated by Jean-Philippe Lang over 1 year ago

  • Subject changed from The description column in the issues table is too short to The description column in the issues table is too short (MySQL)

#2 Updated by Go MAEDA over 1 year ago

  • Related to Defect #16143: Can't insert too long comment field from repository (MySQL) added

#3 Updated by Go MAEDA over 1 year ago

  • Target version set to Candidate for next major release

#4 Updated by Go MAEDA over 1 year ago

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

#5 Updated by Go MAEDA about 1 year ago

Etienne Massip wrote on #7779#note-1:

PostgreSQL stores issue description in a column with text data type which length is unlimited, so adding a limit would be some kind of regression to PG users.

#6 Updated by Go MAEDA about 1 year ago

  • Duplicated by Defect #18865: Size of text description of the problem added

#7 Updated by Go MAEDA about 1 year ago

  • Duplicated by Defect #7779: Error 500 when issue description is too long added

#8 Updated by Jean-Philippe Lang 4 months ago

  • Target version changed from Candidate for next major release to 3.4.0

#9 Updated by Jean-Philippe Lang 3 months ago

  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Resolution set to Fixed

Issue description and journals changed to LONGTEXT.

#10 Updated by Go MAEDA 3 months ago

  • Related to Defect #24006: Add character limitation on description field for MySQL added

#11 Updated by Toshi MARUYAMA 3 months ago

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

#12 Updated by Toshi MARUYAMA 3 months ago

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

#13 Updated by Go MAEDA 2 months ago

  • Duplicated by Defect #24397: this text in description or note cause an internal server error added

Also available in: Atom PDF