Here are more info:
mysql> SELECT COUNT(*) FROM bugs; +----------+ | COUNT(*) | +----------+ | 4372 | +----------+ 1 row in set (0.03 sec) mysql> describe bugs; +---------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------+----------------+ | bug_id | mediumint(9) | NO | PRI | NULL | auto_increment | | assigned_to | mediumint(9) | NO | MUL | 0 | | | bug_file_loc | text | YES | | NULL | | | bug_severity | varchar(64) | NO | MUL | NULL | | | bug_status | varchar(64) | NO | MUL | NULL | | | creation_ts | datetime | YES | MUL | NULL | | | delta_ts | datetime | NO | MUL | NULL | | | short_desc | varchar(255) | NO | | NULL | | | op_sys | varchar(64) | NO | MUL | NULL | | | priority | varchar(64) | NO | MUL | NULL | | | product_id | smallint(6) | NO | MUL | 0 | | | rep_platform | varchar(64) | NO | | NULL | | | reporter | mediumint(9) | NO | MUL | 0 | | | version | varchar(64) | NO | MUL | NULL | | | component_id | smallint(6) | NO | MUL | 0 | | | resolution | varchar(64) | NO | MUL | NULL | | | target_milestone | varchar(20) | NO | MUL | --- | | | qa_contact | mediumint(9) | YES | MUL | NULL | | | status_whiteboard | mediumtext | NO | | NULL | | | votes | mediumint(9) | NO | MUL | 0 | | | keywords | mediumtext | NO | | NULL | | | lastdiffed | datetime | YES | | NULL | | | everconfirmed | tinyint(4) | NO | | 0 | | | reporter_accessible | tinyint(4) | NO | | 1 | | | cclist_accessible | tinyint(4) | NO | | 1 | | | estimated_time | decimal(5,2) | NO | | 0.00 | | | remaining_time | decimal(5,2) | NO | | 0.00 | | | alias | varchar(20) | YES | UNI | NULL | | | deadline | datetime | YES | | NULL | | | cf_reflib | varchar(132) | NO | | --- | | | cf_revision | varchar(255) | YES | | NULL | | | cf_version | varchar(255) | YES | | NULL | | +---------------------+--------------+------+-----+---------+----------------+ 32 rows in set (0.99 sec) --- On Mon, 5/4/09, Gary Yang <garyya...@yahoo.com> wrote: > From: Gary Yang <garyya...@yahoo.com> > Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and > Bugzilla > To: "David Sitsky" <david.sit...@gmail.com> > Cc: codestriker-user@lists.sourceforge.net > Date: Monday, May 4, 2009, 2:54 PM > > 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 > ------------------------------------------------------------------------------ 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
