Re: [Codestriker-user] Problems on integration of CodeStriker and Bugzilla

[David S. <dav...@gm...>]

It means bug ID 6401 does not exist in that specific Bugzilla database
you have connected to (0 rows returned, instead of 1).  Is it possible
you have more than one Bugzilla instance, and you have connected to
the wrong one?  That is what seems to be happening.

Cheers,
David

On Tue, May 5, 2009 at 7:54 AM, Gary Yang <gar...@ya...> wrote:
>
> 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 <dav...@gm...> wrote:
>
>> From: David Sitsky <dav...@gm...>
>> Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and  Bugzilla
>> To: "Gary Yang" <gar...@ya...>
>> Cc: cod...@li...
>> 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 <gar...@ya...>
>> 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
>> > Cod...@li...
>> > https://lists.sourceforge.net/lists/listinfo/codestriker-user
>> >
>>
>
>
>
>