gnats/372: SQL2 not working correctly for new pr

gnats/372: SQL2 not working correctly for new pr

[michaels]

>Number:         372
>Category:       gnats
>Synopsis:       SQL2 not working correctly for new pr
>Confidential:   no
>Severity:       critical
>Priority:       high
>Responsible:    unassigned
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Wed Apr 03 02:53:54 -0500 2002
>Originator:     Michael Salahoris
>Release:        GNATS 3.113.1
>Organization:

>Environment:
Solaris 2.5
>Description:
Hi Support,

I've just compiled and installed GNATS 3.113.1 and GnatsWeb 2.9.3 . When I submit new pr requests either from gnatsweb or e-mail (they obviously use queue-pr) I notice that the fields for this entry in the index file are wrong. I have to gen-index everytime I submit a new pr as SQL2 returns results with '!' in them.
example last lines of index file:
Web/3571|TBJ|Deb|closed|yes|serious|medium|1008406260|1008679935|1008679935|General|Peter Ferwerda|18.19M.12|Website Access for Franc Rota
Web/3767|SHN|Deb|open|yes|serious|medium|1015306740|0|0|Level-3|Niels de Reus|18.20.06|version impossibility(18.21.06)
General/3821|Support|Support|open|no|serious|medium|0|||1017873740|0|0|Unclassed|Michael Salahoris|Softix 18.19M.12|Test Ack usting gnatsweb

pr 3821 is last ack that I submitted so if I do a SQL2 on this pr I get:
210 User access level set to edit
sql2 3821
220 PRs follow.
3821|General|Unclassed!Michael Salahoris!Softix 18.19M.12!Test Ack usting gnatsweb|no|2|2|Support|1|0|Support||0|0|||

Notice the '!' marks in the 3rd field. If I do a gen-index then everything is fine. Could you please help me out as I don't know if there is a patch I should know about and I don't want to run gen-index everytime some submits a pr.

Thanks
Michael

>How-To-Repeat:

>Fix:
Unknown
>Unformatted:
 

_______________________________________________
Gnats-prs mailing list
Gnats-prs@gnu.org
http://mail.gnu.org/mailman/listinfo/gnats-prs