the last letter missing at some maintainers names

[Beat Gätzi]

Boris Samorodov wrote:
> On Thu, 12 Mar 2009 20:59:45 +0100 Beat Gätzi wrote:
>> Boris Samorodov wrote:
>>> On Thu, 12 Mar 2009 03:10:37 -0400 Joe Marcus Clarke wrote:
>>>> On Thu, 2009-03-12 at 09:55 +0300, Boris Samorodov wrote:
> 
>>>>> I use tinderbox 3.2 with upgraded from 3.1 and paefchen webui. Some of
>>>>> maintainers names do missing the last letter. I.e. gnom instead of
>>>>> gnome, gah -> gahr, kd -> kde:
>>>>> http://bb.ipt.ru/tb/index.php?action=list_buildports&build=8-bsam-exp
>>>>>
>>>>> Is it something wrong with my system?
>>>> Looks like it.  My TB is showing the correct info.  Is the information
>>>> correct in the database?
>>> Yes, the database has correct full names (with domain).
> 
>> I removed the rettyEmail function in 3.2 and use SQL therefor so I think
>> this must be related with my changes in the webui. What kind of database
>> do you use? Could you please execute these SQL statement and post the
>> output:
> 
>>> select port_maintainer FROM ports WHERE port_maintainer =
>> 'gnome at FreeBSD.org';
> 
> Not interesting:
> -----
> port_maintainer  
> -------------------
>  gnome at FreeBSD.org
> ...
>  gnome at FreeBSD.org
> (188 rows)
> -----
> 
>>> select DISTINCT TRIM(TRAILING '@FreeBSD.org' FROM port_maintainer) as
>> port_maintainer FROM ports WHERE port_maintainer = 'gnome at FreeBSD.org';
> 
> That is what I see:
> -----
> port_maintainer 
> -----------------
>  gnom
> (1 row)
> -----
> 
> Seems you've found it. Thanks!

What kind of database and which version do you use?

Beat