Limitation of number of list values in custom fields

mfarc

Joined: 2005-02-14
Posts: 2
Posted: Mon, 2005-02-14 14:32

Hi all,

I want to add some choices values in five custom fields.
I see there are limitation of number of values (choices) for
custom fields and. Also there is limitation of the number of custom fields.

I add 13 choices for first picklist without problems.
Autore (custom field):
nome1 (first choice)
nome2
...
nome13

When I add others 14 choices for second custom field the choices are
truncated after some value and the field don't accept others values.
Finalita (custom field):
fin1
fin2
... (trunc)

When i save the list is incomplete.
Also after is no possible to add others new custom fields.

Can you help me?
Thank you very much in advance ...


Gallery URL (optional): http://myserver/gallery2/
Gallery version: 2 Alpha-4
Webserver (with version): Apache 2.0.46
Datatabase (with version): MySql 3.23.52-nt
PHP version: 4.3.4
Graphics Toolkit(s): NTPBM
Operating system: Win 2000 pro
Web browser/version: FireFox 1.0 / Explorer 6

 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Mon, 2005-02-14 16:52

the limit isn't a particular number of choices, but the total length of the text for all the choices, which must fit into the database column. currently the whole list is stored together.. this would need to be refactored to store each entry in a separate row to allow a longer list. you can file a feature request on sourceforge for this.
there is no limit on the number of custom fields that i know of.

 
mfarc

Joined: 2005-02-14
Posts: 2
Posted: Mon, 2005-02-14 17:45

thanks for your answer.

The limit of custom fields is linked with the length of the text of choices.
When the database column is full I think it's impossible to define new custom field with new choices.

How much is the length limit for all choices of all custom fields?
255 char?

My problem is that the number of custom field is 5 and for all I have a list of choices.
I use this configuration for my Gallery v 1.4.x version with a custom php script that fill a list menu with choices for the custom fields.

I think this implementation you suggest is very good and too important.
thanks for your suggestion.