Bugzilla Noob - Bug Comments Do not show up!! :( - Mozilla

This is a discussion on Bugzilla Noob - Bug Comments Do not show up!! :( - Mozilla ; Hi there, I've recently installed Bugzilla 3.0.3 at work for our application bug tracking. We followed the basic set of installion instructions for setting it up on a Windows machine using Apache. All the suggested Pearl packages were installed as ...

+ Reply to Thread
Results 1 to 14 of 14

Thread: Bugzilla Noob - Bug Comments Do not show up!! :(

  1. Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi there,

    I've recently installed Bugzilla 3.0.3 at work for our application bug
    tracking. We followed the basic set of installion instructions for setting
    it up on a Windows machine using Apache. All the suggested Pearl packages
    were installed as well. As far as can be determined, this is a complete set
    up.

    There are some problems, however. When looking at bugs, no long bug
    description shows up, and neither do any of the reply comments. I've had a
    look at the database, and the longdescs table does actually have all the
    comments saved, so it seems like it's writing them properly when saving the
    bug.

    But I don't see anything. I haven't made any changes to any of them page
    templates, so I don't think I'm not displaying them because I screwed
    something up. This is pretty much vanilla Bugzilla here.

    Any help on why or how to fix this will be greatly appreciated!

    David.



  2. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    On Thu, 28 Feb 2008 11:49:09 -0500 "David" wrote:
    > When looking at bugs, no long bug
    > description shows up, and neither do any of the reply comments.


    This usually indicates some strange installation problem. Try
    running checksetup.pl again.

    -Max
    --
    http://www.everythingsolved.com/
    Competent, Friendly Bugzilla and Perl Services. Everything Else, too.

  3. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi Max,

    Thanks. I've tried running it again when we first encountered another issue
    (there was a strange thing going on with the product names if there were
    only 2 products), and it seemed to run without giving any errors both after
    the initial install and while trying to troubleshoot that bug.

    If I run it again, will it clear out all the products and bugs I've put in
    so far?

    Thanks,
    David


    "Max Kanat-Alexander" wrote in message
    news:mailman.1654.1204279427.3376.support-bugzilla@lists.mozilla.org...
    > On Thu, 28 Feb 2008 11:49:09 -0500 "David" wrote:
    >> When looking at bugs, no long bug
    >> description shows up, and neither do any of the reply comments.

    >
    > This usually indicates some strange installation problem. Try
    > running checksetup.pl again.
    >
    > -Max
    > --
    > http://www.everythingsolved.com/
    > Competent, Friendly Bugzilla and Perl Services. Everything Else, too.




  4. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    On Fri, 29 Feb 2008 14:23:25 -0500 "David" wrote:
    > If I run it again, will it clear out all the products and bugs I've
    > put in so far?


    It won't.

    You didn't copy a database from an old Bugzilla or anything,
    did you?

    If nothing works, and this is a fresh install, you might want
    to drop your database and let checksetup.pl recreate it from scratch,
    making sure that there are no errors printed by checksetup.

    -Max
    --
    http://www.everythingsolved.com/
    Competent, Friendly Bugzilla and Perl Services. Everything Else, too.

  5. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi Max,

    Nope, this was a clean install of bugzilla, not an update or anything.

    I guess I'll have to try dropping the DB like you suggest, though I really
    don't want to.

    Is there something I can look into with bugzilla application/template code?
    like where does it keep the db queries to get the comment information? could
    it be that there was something maybe set up incorrectly that's making it not
    access that specific table correclty?

    i really don't know my way around the bugzilla app, so I'm at a loss of
    where I can find these things.

    Thanks,
    David

    "Max Kanat-Alexander" wrote in message
    news:mailman.1701.1204321404.3376.support-bugzilla@lists.mozilla.org...
    > On Fri, 29 Feb 2008 14:23:25 -0500 "David" wrote:
    >> If I run it again, will it clear out all the products and bugs I've
    >> put in so far?

    >
    > It won't.
    >
    > You didn't copy a database from an old Bugzilla or anything,
    > did you?
    >
    > If nothing works, and this is a fresh install, you might want
    > to drop your database and let checksetup.pl recreate it from scratch,
    > making sure that there are no errors printed by checksetup.
    >
    > -Max
    > --
    > http://www.everythingsolved.com/
    > Competent, Friendly Bugzilla and Perl Services. Everything Else, too.




  6. RE: Bugzilla Noob - Bug Comments Do not show up!! :(

    The first thing I would do is check that the templates are there:
    \template\en\default\bug\comments.html.tmpl

    Then check that there is no \custom\ template that matched that, but was incorrectly coded.

    You should have this code snippet near the bottom of the edit template, which calls the comments...
    \bug\edit.html.tmpl
    -----

    [% PROCESS bug/comments.html.tmpl
    comments = bug.longdescs
    mode = user.id ? "edit" : "show"
    %]

    -----

    Next would be: are your users' permissions set in such a way that comments are kept private from them?
    Check that the "insidergroup" parameter isn't blocking comments from being displayed.

    It sounded like you checked the comments table, and that it was indeed there ... did you examine the comments themselves to see if there was anything that might prevent them from displaying?
    (We had someone put javascript pop-up commands in a bug and our anti-virus ate the table claiming it was infected).
    Something innocently added as a comment could be the culprit.

    The script you would probably want to peek at would be: show_bug.cgi, but I am wary that this would be the culprit because if something were wrong with the script, it would have thrown some sort of error.

    ---
    Once a page has been served that you know in your heart of hearts should have a comment displayed, you could try editing the template "live" and just do a "refresh page" and see what happens. If the comments template is bing processed, you may be able to put the following code snippet somewhere on the page (after the comments process command) and the last comment should be inserted before the word "test" (/search for "test" to see where it should appear)
    [% wrapped_comment %] test
    -----

    If you're someplace warm I'll make a housecall. Please tell me you're in the Bahamas or something

    Best of luck,
    Unca Ghrys

    ________________________________

    From: support-bugzilla-bounces@lists.mozilla.org on behalf of David
    Sent: Mon 3/3/2008 3:38 PM
    To: support-bugzilla@lists.mozilla.org
    Subject: Re: Bugzilla Noob - Bug Comments Do not show up!!



    Hi Max,

    Nope, this was a clean install of bugzilla, not an update or anything.

    I guess I'll have to try dropping the DB like you suggest, though I really
    don't want to.

    Is there something I can look into with bugzilla application/template code?
    like where does it keep the db queries to get the comment information? could
    it be that there was something maybe set up incorrectly that's making it not
    access that specific table correclty?

    i really don't know my way around the bugzilla app, so I'm at a loss of
    where I can find these things.

    Thanks,
    David

    "Max Kanat-Alexander" wrote in message
    news:mailman.1701.1204321404.3376.support-bugzilla@lists.mozilla.org...
    > On Fri, 29 Feb 2008 14:23:25 -0500 "David" wrote:
    >> If I run it again, will it clear out all the products and bugs I've
    >> put in so far?

    >
    > It won't.
    >
    > You didn't copy a database from an old Bugzilla or anything,
    > did you?
    >
    > If nothing works, and this is a fresh install, you might want
    > to drop your database and let checksetup.pl recreate it from scratch,
    > making sure that there are no errors printed by checksetup.
    >
    > -Max
    > --
    > http://www.everythingsolved.com/
    > Competent, Friendly Bugzilla and Perl Services. Everything Else, too.



    _______________________________________________
    support-bugzilla mailing list
    support-bugzilla@lists.mozilla.org
    https://lists.mozilla.org/listinfo/support-bugzilla
    PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you reply.



  7. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi Unca,

    First off - Were I am in Canada, it's the farthest thing from Bahams weather
    that you can get right now. Trust me, if *you* were in the Bahamas, I'd
    bring my server to you for help!!

    So I tried everything you suggested here:

    There were no custom templates for comments, and the default comment
    template was there. I tried adding a "Text" string of my own after the
    [%wrapped_comment%] stuff in the template file, and I would see "Text" show
    up on the bug report page - but still no comment!!

    The you said to check for in edit.html.tmpl was there as you said it
    should be.

    All the comments are set to public (the isprivate field in the comments
    table was 0). I'm not sure what you mean by "insidergroup" otherwise,
    because I didn't see anything anywhere about that.

    I had a look at the comments - there were no special characters that would
    have messed anything up. I tried straight, pure text like "this is a test
    comment" (no quotes, angled brackets or anything like that at all).


    Though the mention of the insidergroup thing made me think - do I need to
    have products and users all within groups? As of right now, it's not set up
    like that. There are products, and a bunch of users. Could it be not
    displaying the comments becuase I'm not in *any* group, neverminding that
    I'm not in the "correct" group??

    I tried adding a group to a test product, and added a user to it, but still
    no comment. Though I'm not sure if I set up the group permissiosn properly.
    I just had a look at what was on the page when I created the group and
    didn't really see anything that stood out as relating to comment.s Though
    when I tried adding a bug, I did tell it to use that group. Again, though,
    the comment in the table didn't have it's "isprivate" field set to anything
    other than 0.


    Thanks,
    David



    "Bob Dunn" wrote in message
    news:mailman.2.1204605776.15829.support-bugzilla@lists.mozilla.org...
    The first thing I would do is check that the templates are there:
    \template\en\default\bug\comments.html.tmpl

    Then check that there is no \custom\ template that matched that, but was
    incorrectly coded.

    You should have this code snippet near the bottom of the edit template,
    which calls the comments...
    \bug\edit.html.tmpl
    -----

    [% PROCESS bug/comments.html.tmpl
    comments = bug.longdescs
    mode = user.id ? "edit" : "show"
    %]

    -----

    Next would be: are your users' permissions set in such a way that comments
    are kept private from them?
    Check that the "insidergroup" parameter isn't blocking comments from being
    displayed.

    It sounded like you checked the comments table, and that it was indeed there
    .... did you examine the comments themselves to see if there was anything
    that might prevent them from displaying?
    (We had someone put javascript pop-up commands in a bug and our anti-virus
    ate the table claiming it was infected).
    Something innocently added as a comment could be the culprit.

    The script you would probably want to peek at would be: show_bug.cgi, but I
    am wary that this would be the culprit because if something were wrong with
    the script, it would have thrown some sort of error.

    ---
    Once a page has been served that you know in your heart of hearts should
    have a comment displayed, you could try editing the template "live" and just
    do a "refresh page" and see what happens. If the comments template is bing
    processed, you may be able to put the following code snippet somewhere on
    the page (after the comments process command) and the last comment should be
    inserted before the word "test" (/search for "test" to see where it should
    appear)
    [% wrapped_comment %] test
    -----

    If you're someplace warm I'll make a housecall. Please tell me you're in
    the Bahamas or something

    Best of luck,
    Unca Ghrys

    ________________________________

    From: support-bugzilla-bounces@lists.mozilla.org on behalf of David
    Sent: Mon 3/3/2008 3:38 PM
    To: support-bugzilla@lists.mozilla.org
    Subject: Re: Bugzilla Noob - Bug Comments Do not show up!!



    Hi Max,

    Nope, this was a clean install of bugzilla, not an update or anything.

    I guess I'll have to try dropping the DB like you suggest, though I really
    don't want to.

    Is there something I can look into with bugzilla application/template code?
    like where does it keep the db queries to get the comment information? could
    it be that there was something maybe set up incorrectly that's making it not
    access that specific table correclty?

    i really don't know my way around the bugzilla app, so I'm at a loss of
    where I can find these things.

    Thanks,
    David

    "Max Kanat-Alexander" wrote in message
    news:mailman.1701.1204321404.3376.support-bugzilla@lists.mozilla.org...
    > On Fri, 29 Feb 2008 14:23:25 -0500 "David" wrote:
    >> If I run it again, will it clear out all the products and bugs I've
    >> put in so far?

    >
    > It won't.
    >
    > You didn't copy a database from an old Bugzilla or anything,
    > did you?
    >
    > If nothing works, and this is a fresh install, you might want
    > to drop your database and let checksetup.pl recreate it from scratch,
    > making sure that there are no errors printed by checksetup.
    >
    > -Max
    > --
    > http://www.everythingsolved.com/
    > Competent, Friendly Bugzilla and Perl Services. Everything Else, too.



    _______________________________________________
    support-bugzilla mailing list
    support-bugzilla@lists.mozilla.org
    https://lists.mozilla.org/listinfo/support-bugzilla
    PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you
    reply.




  8. RE: Bugzilla Noob - Bug Comments Do not show up!! :(

    I'm in the Bahamas, bring it to me. Take a plane to Philadelphia, then
    head east to the jersey shore. Well, maybe not the Bahamas, but close
    enough. We have sand and water with waves. They tell us it's "blue".
    You can see all the way down to your knees if you don't go in far enough
    to get your shorts wet. We have all kinds of marine life. Recently
    they discovered a new kind of fish. They call it the
    Staten-Island-Medicalwaste. They even closed the whole beach so this
    new fish could survive unfettered. Then a couple miles away they found
    beach crabs made of metal artillery shells. Such a wonderful place to
    be.

    As for your no comment problem, run the following Perl code and see if
    you get any errors:
    [you@yourserver /var/www/htdocs/bugzilla ]$ perl -w
    use Bugzilla;
    my $bug_id = ;
    my $bug = Bugzilla::Bug->new($bug_id);
    my $comments = $bug->longdescs;
    print "Bug " . $bug->bug_id . " has " . @$comments . " comments.\n";


    Should output:
    Bug ## has ## comments.

    This way you know the bug object is at least able to attach the
    comments. To print the comments, add the following code to above:
    foreach my $comment (@comments) {
    print $comment->{body} . "\n-------------\n";
    }

    Hope this helps,
    Tosh

  9. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi Tosh,

    Wow.. it sounds fabulous there! I'll clear the trip with my boss first thing
    tomorrow morning. He'll probably want to come, too.

    I tried the script you posted. I've had mixed success with it. When it runs,
    I can connect to the DB and get a count, but the count is wrong and no
    comments are displayed.

    So if I do it with bug 4 for example. When I go to mysql directly, I can
    look at the longdescs table and see 6 comments for it. Coolbeans, so I know
    data is being written correctly.

    When I run this pearl script, I get:
    Bug 4 has 1 comments.
    ---------------

    So, it looks like it's having some weird issue with getting data from that
    one table. There should be 6 there, and it should be displaying them as
    well. I have no clue. I should also add that my knowledge and experience of
    using Perl is limited to copy/pasting and running this script that you gave
    me. :-/

    I had a look through the bug.pm (or whatever it's called) package that has
    all the code for the Bug structure you're using in the test. I noticed the
    sql statement for the getting the comment (a sub called GetComment) had an
    inner join based on the user. Would that have an effect on what I'm seeing,
    since I'm not getting the data through any actual bugzilla user account?

    Also, the new sub seems to say that it creates a new comment automatically.
    Is that why I'm just seeing 1?

    Though I also ran it with a bug id i know didn't have any comments, and in
    that case I got a count of 0.


    Thanks,
    David



    "Tosh, Michael J" wrote in message
    news:mailman.176.1204826765.2568.support-bugzilla@lists.mozilla.org...
    > I'm in the Bahamas, bring it to me. Take a plane to Philadelphia, then
    > head east to the jersey shore. Well, maybe not the Bahamas, but close
    > enough. We have sand and water with waves. They tell us it's "blue".
    > You can see all the way down to your knees if you don't go in far enough
    > to get your shorts wet. We have all kinds of marine life. Recently
    > they discovered a new kind of fish. They call it the
    > Staten-Island-Medicalwaste. They even closed the whole beach so this
    > new fish could survive unfettered. Then a couple miles away they found
    > beach crabs made of metal artillery shells. Such a wonderful place to
    > be.
    >
    > As for your no comment problem, run the following Perl code and see if
    > you get any errors:
    > [you@yourserver /var/www/htdocs/bugzilla ]$ perl -w
    > use Bugzilla;
    > my $bug_id =
    ;
    > my $bug = Bugzilla::Bug->new($bug_id);
    > my $comments = $bug->longdescs;
    > print "Bug " . $bug->bug_id . " has " . @$comments . " comments.\n";
    >
    >
    > Should output:
    > Bug ## has ## comments.
    >
    > This way you know the bug object is at least able to attach the
    > comments. To print the comments, add the following code to above:
    > foreach my $comment (@comments) {
    > print $comment->{body} . "\n-------------\n";
    > }
    >
    > Hope this helps,
    > Tosh




  10. RE: Bugzilla Noob - Bug Comments Do not show up!! :(

    > Though I also ran it with a bug id i know didn't have any comments,
    and in
    > that case I got a count of 0.


    Oh, and all bugs should have a comment. a comment is required when
    creating a new bug report. At least I THOUGHT it was.

    Tosh

  11. RE: Bugzilla Noob - Bug Comments Do not show up!! :(

    here is a script that may work on Bugzilla 2.20-2.24:

    [you@server bugz]$ perl -w
    use strict;
    use lib qw(.);
    use Data:umper;
    use Bugzilla;
    use Bugzilla::Constants;
    use Bugzilla::Bug;
    require "globals.pl";
    my $b = new Bugzilla::Bug(, );
    print Dumper($b->longdescs);




    Here is my output of a bug with 3 comments:
    $VAR1 = [
    {
    'email' => 'me@us',
    'body' => 'another comment',
    'work_time' => '0.00',
    'isprivate' => '0',
    'already_wrapped' => '0',
    'time' => '2008.02.27 10:35:11',
    'name' => 'me@us'
    },
    {
    'email' => 'me@us',
    'body' => 'a comment',
    'work_time' => '0.00',
    'isprivate' => '0',
    'already_wrapped' => '0',
    'time' => '2008.02.27 09:28:20',
    'name' => 'me@us'
    },
    {
    'email' => 'reporter@us',
    'body' => 'original description',
    'work_time' => '0.00',
    'isprivate' => '0',
    'already_wrapped' => '0',
    'time' => '2008.02.26 15:32:38',
    'name' => 'reporter@us'
    }
    ];

  12. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi Mike,



    I probably should have mentioned this sooner, but I'm running Windows Server
    2003, so I don't have a grep command. If you know how I can do that version
    thing on windows, I'll run it and let you know.



    But I am running Bugzilla 3.0.3.



    I ran the original script you gave me, and I got this:

    $VAR1 [

    Undef

    ];





    When I try to run the new script you gave me, I get an error saying it can't
    find globals.pl. Where is that located in the tree of Bugzilla files?



    Also, Here's the version numbers that I can give you:

    DBD_mysql 4.005

    Mysql 6.0.3

    Apache 2.2.6

    Active Perl 5.8.8



    We ran checksetup.pl again, since we had updated the version of the perl
    mysql scripts, thinking at first there might have been a problem with that.
    When running checksetup now, at the end, it gives the following error:

    Not an Array reference at

    C:\perl\site\lib\dbd\mysql.pm line 443, chunk 228.





    Thanks,

    David





    "Tosh, Michael J" wrote in message
    news:mailman.205.1204835976.2568.support-bugzilla@lists.mozilla.org...
    > here is a script that may work on Bugzilla 2.20-2.24:
    >
    > [you@server bugz]$ perl -w
    > use strict;
    > use lib qw(.);
    > use Data:umper;
    > use Bugzilla;
    > use Bugzilla::Constants;
    > use Bugzilla::Bug;
    > require "globals.pl";
    > my $b = new Bugzilla::Bug(, );
    > print Dumper($b->longdescs);
    >
    >
    >
    >
    > Here is my output of a bug with 3 comments:
    > $VAR1 = [
    > {
    > 'email' => 'me@us',
    > 'body' => 'another comment',
    > 'work_time' => '0.00',
    > 'isprivate' => '0',
    > 'already_wrapped' => '0',
    > 'time' => '2008.02.27 10:35:11',
    > 'name' => 'me@us'
    > },
    > {
    > 'email' => 'me@us',
    > 'body' => 'a comment',
    > 'work_time' => '0.00',
    > 'isprivate' => '0',
    > 'already_wrapped' => '0',
    > 'time' => '2008.02.27 09:28:20',
    > 'name' => 'me@us'
    > },
    > {
    > 'email' => 'reporter@us',
    > 'body' => 'original description',
    > 'work_time' => '0.00',
    > 'isprivate' => '0',
    > 'already_wrapped' => '0',
    > 'time' => '2008.02.26 15:32:38',
    > 'name' => 'reporter@us'
    > }
    > ];




  13. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    On 3/6/2008 1:06 PM, David wrote:

    > I probably should have mentioned this sooner, but I'm running Windows Server
    > 2003, so I don't have a grep command.


    It's not difficult to get one. ;-)

    > When I try to run the new script you gave me, I get an error saying it can't
    > find globals.pl. Where is that located in the tree of Bugzilla files?


    I think that only existed in older Bugzilla versions.

    > Mysql 6.0.3


    That seems potentially bad - version 6 is alpha, and Bugzilla may have
    issues with it. If you don't have much invested in it yet, I'd go back
    to MySQL 5.0.x.

  14. Re: Bugzilla Noob - Bug Comments Do not show up!! :(

    Hi David,

    I'm having this issue while i try to setup Bugzilla on my system
    Windows server 2003, MySQL 6.0

    If you fixed it, please let me know

    Thanks,
    Thuc

    On Feb 28, 11:49 pm, "David" wrote:
    > Hi there,
    >
    > I've recently installed Bugzilla 3.0.3 at work for our application bug
    > tracking. We followed the basic set of installion instructions for setting
    > it up on aWindowsmachine using Apache. All the suggested Pearl packages
    > were installed as well. As far as can be determined, this is a complete set
    > up.



    >
    > There are some problems, however. When looking at bugs, no long bug
    > description shows up, and neither do any of the reply comments. I've had a
    > look at the database, and the longdescs table does actually have all the
    > comments saved, so it seems like it's writing them properly when saving the
    > bug.
    >
    > But I don't see anything. I haven't made any changes to any of them page
    > templates, so I don't think I'm not displaying them because I screwed
    > something up. This is pretty much vanilla Bugzilla here.
    >
    > Any help on why or how to fix this will be greatly appreciated!
    >
    > David.



+ Reply to Thread