the last letter missing at some maintainers names

[Boris Samorodov]

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!


WBR
-- 
Boris Samorodov (bsam)
Research Engineer, http://www.ipt.ru Telephone & Internet SP
FreeBSD committer, http://www.FreeBSD.org The Power To Serve