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 <garyyang6@...> wrote:
> From: Gary Yang <garyyang6@...>
> Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and Bugzilla
> To: "David Sitsky" <david.sitsky@...>
> Cc: codestriker-user@...
> 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.sitsky@...>
> wrote:
>
> > From: David Sitsky <david.sitsky@...>
> > Subject: Re: [Codestriker-user] Problems on
> integration of CodeStriker and Bugzilla
> > To: "Gary Yang" <garyyang6@...>
> > Cc: codestriker-user@...
> > 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 <garyyang6@...>
> > 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@...
> > > 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@...
> https://lists.sourceforge.net/lists/listinfo/codestriker-user
>
|