From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 22788 invoked from network); 3 Apr 2002 09:06:09 -0000 Received: from unknown (HELO fencepost.gnu.org) (199.232.76.164) by sources.redhat.com with SMTP; 3 Apr 2002 09:06:09 -0000 Received: from localhost ([127.0.0.1] helo=fencepost.gnu.org) by fencepost.gnu.org with esmtp (Exim 3.34 #1 (Debian)) id 16sgOh-0004zH-00; Wed, 03 Apr 2002 03:45:39 -0500 Received: from gnats by fencepost.gnu.org with local (Exim 3.34 #1 (Debian)) id 16sfae-0006et-00; Wed, 03 Apr 2002 02:53:56 -0500 From: michaels@ticketek.com.au To: pdm-gnats@zamazal.org,gnats-prs@gnu.org,bug-gnats@gnu.org Reply-To: michaels@ticketek.com.au Subject: gnats/372: SQL2 not working correctly for new pr Message-Id: Sender: gnats-prs-admin@gnu.org Errors-To: gnats-prs-admin@gnu.org X-BeenThere: gnats-prs@gnu.org X-Mailman-Version: 2.0.8 Precedence: bulk List-Help: List-Post: List-Subscribe: , List-Id: Copies of bug tracking system messages List-Archive: Date: Wed, 03 Apr 2002 01:06:00 -0000 X-SW-Source: 2002-q2/txt/msg00002.txt.bz2 >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