Interesting. So if I would switch to postgresql I would Get double The amount of characters without having to do anything else. 512 characters is still not enough though.
Would I have to change any code in OTRS if I would change to blob? where would I find this code? As far as I understand the field CustomerIDs is created by The xml definition so I would probably have to find it in a table related to xml definitions somewhere. Any idea how to find this field? I will try to make a blob out of it and see what happens. Thank you very much, Regards, Roald Op 26 feb. 2015 00:42 schreef <prmari...@gmail.com> het volgende: > Sorry it's been a long time since I dug into the schema. Also be aware if > I remember correctly the limitation comes from MySQL. VARCHAR fields in > MySQL max out at 256 characters and PostgreSQL maxes out at 512. This could > in theory be resolved by transforming the column into a "TEXT" field which > is essentially a BLOB containing text, but I don't know how well MySQL with > searches of that field type. I know extensive work was done in PostgreSQL > to make it work well for data warehouses, but I doubt much work was done on > it for MySQL since I last looked. > > Sent from my BlackBerry 10 smartphone. > *From: *Roald > *Sent: *Wednesday, February 25, 2015 13:28 > *To: *Development community of OTRS > *Reply To: *Development community of OTRS > *Subject: *Re: [dev] how to change maxlength of a textarea defined in an > xml file? > > I had a suspicion that I would need to do something like that. > > Would you happen to know how to go about this? > > Thank you very much, > With kind regards, > Roald > Op 25 feb. 2015 18:05 schreef "Paul Robert Marino" <prmari...@gmail.com> > het volgende: > >> for that you would have to alter the database schema. >> >> On Wed, Feb 25, 2015 at 6:12 AM, Roald <depja...@gmail.com> wrote: >> > Dear all, >> > >> > I want to make a small adaption to this CustomerSLA module: >> > http://opar.perl-services.de/package/D/DI/DIETMARB/CustomerSLA >> > >> > I would like to increase the amount of accepted characters of the >> > CustomerIDs field. >> > >> > Step one is to increase the Cols and Rows in >> > /opt/otrs/Kernel/Config/Files/CustomerSLA.xml >> > >> > <ConfigItem Name="SLAPreferences###02_CustomerIDs" Required="0" >> > Valid="1"> >> > <Description Translatable="1">List of customer company IDs for >> which >> > this SLA applies.</Description> >> > <Group>CustomerSLA</Group> >> > <SubGroup>Frontend::SLA::Preferences</SubGroup> >> > <Setting> >> > <Hash> >> > <Item >> > Key="Module">Kernel::Output::HTML::SLAPreferencesGeneric</Item> >> > <Item Key="Label">CustomerIDs</Item> >> > <Item Key="Desc">List of customer company IDs for which >> this >> > SLA applies.</Item> >> > <Item Key="Block">TextArea</Item> >> > <Item Key="Cols">50</Item> >> > <Item Key="Rows">3</Item> >> > <Item Key="PrefKey">CustomerIDs</Item> >> > </Hash> >> > </Setting> >> > </ConfigItem> >> > >> > But If I change Cols and Rows the amount of characters when I hit >> Submit in >> > the AdminCustomerSLA window still gets limited to 250 characters. How >> do I >> > increase the max lenght of characters of CustomerIDs ? >> > >> > Thank you very much, >> > With kind regards. >> > Roald >> > >> > _______________________________________________ >> > OTRS mailing list: dev - Webpage: http://otrs.org/ >> > Archive: http://lists.otrs.org/pipermail/dev >> > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev >> _______________________________________________ >> OTRS mailing list: dev - Webpage: http://otrs.org/ >> Archive: http://lists.otrs.org/pipermail/dev >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev >> > > > _______________________________________________ > OTRS mailing list: dev - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/dev > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev > _______________________________________________ > OTRS mailing list: dev - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/dev > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev >
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
