Reg - Help needed with Custom Field size

[Santosh Chandrashekhar Sheelvant]

Dear All,

I have created a CUSTOM FIELD with a TEXT AREA type and my requirement is to allot maximum number of characters to be entered.

Currently the permitted number of characters for TEXT AREA is 255 Characters.

Please let me know if I can increase it to my requirements?

and also is it not possible to restrict the CUSTOM FIELD specific to one project rather than making it applicable with all the projects?

Awaiting your response

--
Regards-

Santosh C Sheelvant

[Amit Khullar]

I dont think this is possible as of now,it requires some code change.
Probably 1.9 might have a fix for this or if there is any hot fix then
any can post it here for others also.

~ak

[Francisco Mancardi]

changes will be done on 1.9, no official fix for other versions will be
created

[Amit Khullar]

Hi fman,

I have a request here , probably we should really consider this issue
for the next 1.8.5 patch since it really creates a bottleneck for
saving data more than 255 char. This would help all our existing users
in upgrading there systems with this change who cant immediately
upgrade to 1.9 / until its out. I think you can discuss this with
Martin / Schlundus / others to take a stance on this, it would be
really commendable if we do it in 1.8.x release.

Cheers
Amit

[Martin Havlat]

Amit,
I understand your reason. I would like to state why not:
- unknown dependence on performance for MySQL
- this 1.8.x should be stable version and CF is complex functionality.
There could be hidden dependencies. I prefer to be sure that everything
works ok.
We have one experience from history. It is version 1.6.3 developed by
Asiel. This version is not compatible with 1.7 version and users hate us
for that. For example you can see a review note on SF.net.

I feel better if we introduce it before final 1.9 release because we
have a space for testing. It looks frigid I know.

Martin

[Martin Havlat]

Amit,
I understand your reason. I would like to state why not:
- unknown dependence on performance for MySQL
- this 1.8.x should be stable version and CF is complex functionality.
There could be hidden dependencies. I prefer to be sure that everything
works ok.
We have one experience from history. It is version 1.6.3 developed by
Asiel. This version is not compatible with 1.7 version and users hate us
for that. For example you can see a review note on SF.net.

I feel better if we introduce it before final 1.9 release because we

have a space for testing. It looks frigid I know. I hope that we will
move ahead with 1.9 early. I also welcome if you or somebody create
unofficial 1.8 patch for that.

Martin

[Amit Khullar]

Figured out a patch for the increasing the Custom field size of type
Text Area to 4000 char...

DB Update: ( Below statements for MYSQL Only)
ALTER TABLE /*prefix*/cfield_design_values MODIFY COLUMN value varchar
(4000) NOT NULL default '';
ALTER TABLE /*prefix*/cfield_execution_values MODIFY COLUMN value
varchar(4000) NOT NULL default '';
ALTER TABLE /*prefix*/cfield_testplan_design_values MODIFY COLUMN
value varchar(4000) NOT NULL default '';


ALTER TABLE /*prefix*/custom_fields MODIFY COLUMN possible_values
varchar(4000) NOT NULL default '';
ALTER TABLE /*prefix*/custom_fields MODIFY COLUMN default_value varchar
(4000) NOT NULL default '';

Then update the lines below in cfield_mgr.class.php

1: var $max_length_value=4000;
2: var $max_length_possible_values=4000;
3: const TEXTAREA_MAX_SIZE = 4000;

Still testing this for bugs....


Regards

Amit Khullar

[Francisco Mancardi]

Amit

get code from cvs head and compare

[Francisco Mancardi]

Amit :

I've written official solution for 1,9, use only code already commited
HEAD CVS
There are also changes on config.inc.php

regards