David, I got the output below. But, I do not know what it means. Any idea?
mysql> SELECT COUNT(*) FROM bugs WHERE bug_id = 6401; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.05 sec) Thanks. --- On Sun, 5/3/09, David Sitsky <david.sit...@gmail.com> wrote: > From: David Sitsky <david.sit...@gmail.com> > Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and > Bugzilla > To: "Gary Yang" <garyya...@yahoo.com> > Cc: codestriker-user@lists.sourceforge.net > Date: Sunday, May 3, 2009, 6:12 PM > Hi Gary, > > For Bugzilla, the check for the existence of a specific bug > just runs > the following query, and checks it is not equal to 0: > > SELECT COUNT(*) FROM bugs WHERE bug_id = ? > > Since you have already reached this part in the code, I > would assume > that Codestriker has already connected to your Bugzilla > database. The > only thing I can think of is some obscure mysql permissions > getting in > the way. > > On the same machine that Codestriker runs from, try > connecting to the > Bugzilla database using the mysql command-line tool to see > if you can > run the query: > > SELECT COUNT(*) FROM bugs WHERE bug_id = 6401 > > Hopefully that will show what the issue might be? > > Cheers, > David > > On Sat, May 2, 2009 at 10:36 AM, Gary Yang <garyya...@yahoo.com> > wrote: > > > > Hi, > > > > There is a bug ID, 6401 in Bugzilla. However, I got > errors when I create a topic in CodeStriker. Can someone > tell me what are the possible reasons? > > > > Error: > > Bug ID 6401 does not exist. > > For security reasons, please re-enter the file name to > upload, if required. > > > > codestriker.conf: > > > > # Bug database connection details. > > $bug_db = 'bugzilla'; > > $bug_db_host = 'sdcrevc04'; > > $bug_db_name = 'bugs'; > > $bug_db_password = 'bug4adm'; > > $bug_db_dbname = 'bugs'; > > > > $bugtracker = 'http://sdcrevc04.company.com:8080/bugzilla/show_bug.cgi?id='; > > > > Thanks, > > > > > > Gary > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > Register Now & Save for Velocity, the Web > Performance & Operations > > Conference from O'Reilly Media. Velocity features a > full day of > > expert-led, hands-on workshops and two days of > sessions from industry > > leaders in dedicated Performance & Operations > tracks. Use code vel09scf > > and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf > > _______________________________________________ > > Codestriker-user mailing list > > Codestriker-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/codestriker-user > > > ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Codestriker-user mailing list Codestriker-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/codestriker-user
