[Rt-devel] Subject length

Wed Dec 6 16:45:30 EST 2006

Thanks for the respons.

Another thing. I updated my database from rt-2.0.4 to rt-3.4.5. I see,
that the update-scrips don't not change the type of the column data in
the table transactions from character varying(100) to character
varying(255). Now I become the followig error:
value too long for type character varying(100) (/opt/rt3/lib/RT.pm:287)
Dec 4 10:56:09 xxxxxxx RT: RT::Handle=HASH(0xae0afa4) couldn't execute
the query 'INSERT INTO Transactions

It would be grate, if you could insert this in the database
update-scripts.

Thanks

Michael Peer

-----Original Message-----
From: rt-devel-bounces at lists.bestpractical.com
[mailto:rt-devel-bounces at lists.bestpractical.com] On Behalf Of Jesse
Vincent
Sent: Wednesday, 06 December, 2006 21:52
To: Bob Goldstein
Cc: rt-devel at lists.bestpractical.com
Subject: Re: [Rt-devel] Subject length

On Wed, Dec 06, 2006 at 02:43:16PM -0600, Bob Goldstein wrote:
> >
> >Greetings,
> >=20
> >Is there a specific reason, that maximum length of subjects for 
> >tickets are 200 character? Wouldn't it be better if the number of 
> >character is higher or unlimited?
> 
> 
>   Unlimited is  what the body is for. The whole point of a subject
>   (in email, rt, or a general headline in a newspaper) is
>   "microcontent", a very concise summary that you can show
>   in a list and read at a glance.

But nothing bad will happen if you change the field definition in RT and
in the database.

>      bobg
> 
> >=20
> >=20
> >
> >Michael Peer
> >I&CT
> >_______________________
> >EURAC research
> >Viale Druso/Drususallee 1
> >39100 Bolzano/Bozen
> >Italy
> >
> >Email: michael.peer at eurac.edu <mailto:.michael.peer at eurac.edu>=20
> >Website: www.eurac.edu <http://www.eurac.edu/>=20
> >
> >=20
> >
> >------_=_NextPart_001_01C71972.1F271BCF
> >Content-Type: text/html;
> >       charset="us-ascii"
> >Content-Transfer-Encoding: quoted-printable
> >
> ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> 
> ><HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = 
> >charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.5730.11" 
> >name=3DGENERATOR></HEAD> <BODY> <DIV><SPAN 
> >class=3D072095919-06122006><FONT face=3D"Trebuchet MS"=20 
> >size=3D2>Greetings,</FONT></SPAN></DIV>
> ><DIV><SPAN class=3D072095919-06122006><FONT face=3D"Trebuchet MS"=20 
> >size=3D2></FONT></SPAN>&nbsp;</DIV>
> ><DIV><SPAN class=3D072095919-06122006><FONT face=3D"Trebuchet MS" = 
> >size=3D2>Is there a=20 specific reason, that maximum length of 
> >subjects for tickets&nbsp;are = 200=20 character? Wouldn't it be 
> >better if the number of character is higher or =
> >
> >unlimited?</FONT></SPAN></DIV>
> ><DIV><SPAN class=3D072095919-06122006><FONT face=3D"Trebuchet MS"=20 
> >size=3D2></FONT></SPAN>&nbsp;</DIV>
> ><DIV><SPAN class=3D072095919-06122006></SPAN>&nbsp;</DIV>
> ><P class=3DMsoNormal align=3Dleft><FONT face=3D"Times New Roman" = 
> >size=3D3><SPAN=20
> >style=3D"FONT-SIZE: 12pt"><?xml:namespace prefix =3D o ns =3D=20 
> >"urn:schemas-microsoft-com:office:office" = 
> >/><o:p></o:p></SPAN></FONT></P> <P class=3DMsoNormal 
> >align=3Dleft><FONT face=3D"Trebuchet MS" = size=3D2><SPAN=20
> >style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Trebuchet MS'">Michael=20 
> >Peer<BR><EM>I&amp;CT</EM><BR>_______________________<BR>EURAC = 
> >research<BR>Viale=20 Druso/Drususallee 1<BR>39100 
> >Bolzano/Bozen<BR><?xml:namespace prefix =3D =
> >st1 ns =3D=20
> >"urn:schemas-microsoft-com:office:smarttags" /><st1:country-region=20

> >w:st=3D"on"><st1:place=20 
> >w:st=3D"on">Italy</st1:place></st1:country-region><BR><BR>Email:=20
> ></SPAN></FONT><FONT face=3D"Trebuchet MS" size=3D2><SPAN lang=3DDE=20
> >style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Trebuchet MS'"><A=20 
> >title=3Dmailto:---.--- at eurac.edu = 
> >href=3D"mailto:.michael.peer at eurac.edu"><FONT=20
> >title=3Dmailto:---.--- at eurac.edu color=3Dblack><SPAN = 
> >title=3Dmailto:---.--- at eurac.edu=20
> >style=3D"COLOR: =
> >black">michael.peer at eurac.edu</SPAN></FONT></A></SPAN></FONT><FONT=20
> >face=3D"Trebuchet MS" size=3D2><SPAN=20
> >style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Trebuchet 
> >MS'"><BR>Website:=20 </SPAN></FONT><A title=3Dhttp://www.eurac.edu/ =

> >href=3D"http://www.eurac.edu/"><FONT=20
> >title=3Dhttp://www.eurac.edu/ face=3D"Trebuchet MS" color=3Dblack = 
> >size=3D2><SPAN=20 title=3Dhttp://www.eurac.edu/=20
> >style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Trebuchet = 
> >MS'">www.eurac.edu</SPAN></FONT></A><o:p></o:p></P>
> ><DIV>&nbsp;</DIV></BODY></HTML>
> >
> >------_=_NextPart_001_01C71972.1F271BCF--
> >
> >--===============1857492103==
> >Content-Type: text/plain; charset="us-ascii"
> >MIME-Version: 1.0
> >Content-Transfer-Encoding: 7bit
> >Content-Disposition: inline
> >
> >_______________________________________________
> >List info: 
> >http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> >--===============1857492103==--
> >
> _______________________________________________
> List info: 
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> 

--
_______________________________________________
List info:
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel