View Issue Details

IDProjectCategoryView StatusLast Update
0010370mantisbtcustom fieldspublic2019-09-17 08:23
Reporterjonathh Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status feedbackResolutionopen 
Summary0010370: Max field length not respected.
Description

I applied a max field length for a custom field of a string to 1024 (default of 256) when i enter my text i can indeed enter more characters but when you submit it is truncated.

Also the default value field isn't updated so you couldn't have a 1025 charactor long default value?

TagsNo tags attached.

Relationships

related to 0008518 closedgrangeway Enumerated Custom Field limited to 255 
related to 0026141 resolvedcproensa Use max length property of custom field in inputs 

Activities

jreese

jreese

2009-04-22 10:15

reporter   ~0021625

"It's not a bug, it's a feature..."

Custom fields are unable to have maximum lengths longer than 255 due to the way the custem field schema has been designed/defined. Some database types do not support VARCHAR fields longer than 255 characters, and for some reason MantisBT chose to use a VARCHAR field rather than a TEXT field. I would disagree with that decision, but that's just how it is, unless Paul/Daryn decides to fix that inn their eventual updates to custom fields...

jonathh

jonathh

2009-04-24 09:18

reporter   ~0021657

Man.. that sucks.

Is it hard to change the schema? Would the code that wraps around it need changing? - I think maybe not as everything else respects the size it is just truncated on POST.

We wanted to use it to store a 'client name' drop down. We wont get many clients in a list with that sort of limitation!

Baerlon

Baerlon

2009-10-09 10:26

reporter   ~0023111

Is this a duplicate of 0008518 ?

vboctor

vboctor

2009-10-27 04:10

manager   ~0023394

@jonathh, the following wiki page should help you to achieve what you need. Let us know if it works for you.

Baerlon

Baerlon

2009-10-27 04:24

reporter   ~0023399

@vboctor: Which wiki page do you mean?
This one is empty: http://www.mantisbt.org/wiki/doku.php?id=mantisbt:issue:10370

Issue History

Date Modified Username Field Change
2009-04-22 09:46 jonathh New Issue
2009-04-22 10:15 jreese Note Added: 0021625
2009-04-22 10:15 jreese Status new => feedback
2009-04-24 09:18 jonathh Note Added: 0021657
2009-10-09 10:26 Baerlon Note Added: 0023111
2009-10-27 04:07 vboctor Relationship added related to 0008518
2009-10-27 04:10 vboctor Note Added: 0023394
2009-10-27 04:24 Baerlon Note Added: 0023399
2019-09-17 08:23 dregad Relationship added related to 0026141