Page 1 of 1

Custom field and lengths

Posted: Mon Dec 09, 2013 4:06 pm
by ruffmeister
Script URL:
Version of script: latest
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

Hi there,

We have had an issue before and have had to recreate the the custom2 field data.

we use custom2 as a drop down list for all customers so we can then do stats based on custom2 field. If the number in that list gets too large we cannot edit the field any more and it all then appears in one long list and thus we have to recreate all the data. Is there a way to increase the amount that the custom2 field can use / is that data stored in SQL directly so i can edit in there?

Re: Custom field and lengths

Posted: Mon Dec 09, 2013 5:08 pm
by Klemen
I don't think I understand exactly what is happening?

The field type in MySQL is "mediumtext" so it should handle a lot of data (more than 16 million chars in a string).

My guess is something is wrong in the settings file (hesk_settings.inc.php). The line starting with 'custom2' should have all available values listed in

Code: Select all

value=>'(here)'
Where (here) is a list of available options separated by

Code: Select all

#HESK#
, for example:

Code: Select all

option1#HESK#option2#HESK#option3