Can't find bugs.

classic Classic list List threaded Threaded
18 messages Options
Reply | Threaded
Open this post in threaded view
|

Can't find bugs.

hobbitmage

Hello,

I did an import of one bugzilla database into the new bugzilla database.

I can't find any of the bugs.  Any idea why? 

Regards,

Marc

_______________________________________________ mozilla-webtools mailing list [hidden email] http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

Max Kanat-Alexander
On Mon, 2005-05-23 at 18:23 +0000, marc jackson wrote:
> I did an import of one bugzilla database into the new bugzilla
> database.
>
> I can't find any of the bugs.  Any idea why?  

        Hey Marc. The correct way to do an upgrade is explained in the Release
Notes. Basically, you make a backup of your database, and then you
install the new Bugzilla over the old one and run checksetup.pl.

        Is that what you did?

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage
Hi,

I'm not sure it's a bugzilla issue.  The old bugzilla was running on mysql
3.23.  It's version 2.18.  The new bugzilla is version 2.18.1, but it's
running on mysql4.1*.

Sigh.

It's an odd thing.  Depending on how you run your query, either the data
will show or it won't.  Odd.... :)

Marc

<br><br><br>&gt;From: Max Kanat-Alexander
&lt;[hidden email]&gt;<br>&gt;To:
[hidden email]<br>&gt;Subject: Re: Can't find
bugs.<br>&gt;Date: Mon, 23 May 2005 15:10:16 -0700<br>&gt;<br>&gt;On Mon,
2005-05-23 at 18:23 +0000, marc jackson wrote:<br>&gt; &gt; I did an import
of one bugzilla database into the new bugzilla<br>&gt; &gt;
database.<br>&gt; &gt;<br>&gt; &gt; I can't find any of the bugs.  Any idea
why?<br>&gt;<br>&gt; Hey Marc. The correct way to do an upgrade is explained
in the Release<br>&gt;Notes. Basically, you make a backup of your database,
and then you<br>&gt;install the new Bugzilla over the old one and run
checksetup.pl.<br>&gt;<br>&gt; Is that what you
did?<br>&gt;<br>&gt; -Max<br>&gt;--<br>&gt;http://www.everythingsolved.com/<br>&gt;Everything
Solved: Experts at Bugzilla... and everything else,
too.<br>&gt;<br>&gt;_______________________________________________<br>&gt;mozilla-webtools
mailing
list<br>&gt;[hidden email]<br>&gt;http://mail.mozilla.org/listinfo/mozilla-webtools<br>


_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage
In reply to this post by Max Kanat-Alexander

Hi Max,

I'm not sure if I responded to this.  I wasn't trying to do an upgrade.  Just transfer bugzilla to a new machine.  It seems as no one has seen this type of behavior before. hmm ....

If it helps to understand more:

The original bugzilla was 2.18 running on mysql3.23. [ I wish they'd told me that before. *sigh* ]

I built bugzilla 2.18.1 running on mysql 4.1.11.  I can see the data from the mysql prompt via select * from profiles. etc. etc.  I can use the find button on a bug #, but the data doesn't display. That's with the old bugs.  I created a new test bug and it displayed fine, when I used the find button.  My boss then did a search and pulled up everything, but he didn't use the find button.

Any thoughts?

mj




>From: Max Kanat-Alexander <[hidden email]>
>To: [hidden email]
>Subject: Re: Can't find bugs.
>Date: Mon, 23 May 2005 15:10:16 -0700
>
>On Mon, 2005-05-23 at 18:23 +0000, marc jackson wrote:
> > I did an import of one bugzilla database into the new bugzilla
> > database.
> >
> > I can't find any of the bugs.  Any idea why?
>
> Hey Marc. The correct way to do an upgrade is explained in the Release
>Notes. Basically, you make a backup of your database, and then you
>install the new Bugzilla over the old one and run checksetup.pl.
>
> Is that what you did?
>
> -Max
>--
>http://www.everythingsolved.com/
>Everything Solved: Experts at Bugzilla... and everything else, too.
>
>_______________________________________________
>mozilla-webtools mailing list
>[hidden email]
>http://mail.mozilla.org/listinfo/mozilla-webtools
_______________________________________________ mozilla-webtools mailing list [hidden email] http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

Max Kanat-Alexander
On Tue, 2005-05-24 at 18:47 +0000, marc jackson wrote:
> The original bugzilla was 2.18 running on mysql3.23. [ I wish they'd
> told me that before. *sigh* ]
>
> I built bugzilla 2.18.1 running on mysql 4.1.11.  

        How did you do that? The correct way would have been:

        (1) mysqldump on the old MySQL DB.
        (2) import the mysqldump into your 4.1.11
        (3) Have Bugzilla 2.18.1 connect to your database, and run
checksetup.pl on it, and make sure checksetup.pl doesn't give any
errors.

        The important thing is that there would be NO other steps (except maybe
creating the 'bugs' user in MySQL 4.1). That is, you want the mysqldump
import (Step 2) to create the tables as well as the data.

> I can use the find button on a bug #, but the data doesn't display.

        Could you explain a bit more what you mean by "the data doesn't
display?"

> Any thoughts?

        Maybe there's something wrong with your indexes? But then you'd
probably get errors. Still, you could try running REPAIR TABLE on all
the tables in the Bugzilla database.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage

Oddly enough, the steps went something like:

1. mysqldump of old bugzilla. 

2. Start mysql on new machine.

3. Bugzilla/checksetup.pl

4. mysql import of old dump.

5. Bugzilla/checksetup.pl

3 - 5 *may* have changed order.  It was late and I was under a bit of pressure. :)

It was the output of mysqldump which infomed me of 3.23 as the original database.

re: The data doesn't show. There's a find button for searching for bugs. That button doesn't work/display information when you try to display bugs from the other machine. When I use that button to display the test bug I created, it works fine.

Thanks for the tip on REPAIR TABLES. I'll try that.

Regards,

Marc




>From: Max Kanat-Alexander <[hidden email]>
>To: [hidden email]
>Subject: Re: Can't find bugs.
>Date: Tue, 24 May 2005 16:44:33 -0700
>
>On Tue, 2005-05-24 at 18:47 +0000, marc jackson wrote:
> > The original bugzilla was 2.18 running on mysql3.23. [ I wish they'd
> > told me that before. *sigh* ]
> >
> > I built bugzilla 2.18.1 running on mysql 4.1.11.
>
> How did you do that? The correct way would have been:
>
> (1) mysqldump on the old MySQL DB.
> (2) import the mysqldump into your 4.1.11
> (3) Have Bugzilla 2.18.1 connect to your database, and run
>checksetup.pl on it, and make sure checksetup.pl doesn't give any
>errors.
>
> The important thing is that there would be NO other steps (except maybe
>creating the 'bugs' user in MySQL 4.1). That is, you want the mysqldump
>import (Step 2) to create the tables as well as the data.
>
> > I can use the find button on a bug #, but the data doesn't display.
>
> Could you explain a bit more what you mean by "the data doesn't
>display?"
>
> > Any thoughts?
>
> Maybe there's something wrong with your indexes? But then you'd
>probably get errors. Still, you could try running REPAIR TABLE on all
>the tables in the Bugzilla database.
>
> -Max
>--
>http://www.everythingsolved.com/
>Everything Solved: Experts at Bugzilla... and everything else, too.
>
>_______________________________________________
>mozilla-webtools mailing list
>[hidden email]
>http://mail.mozilla.org/listinfo/mozilla-webtools
_______________________________________________ mozilla-webtools mailing list [hidden email] http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

RE: Can't find bugs.

Benton, Kevin
In reply to this post by hobbitmage

Are you running the same MySQL version in both cases?

 

---

Kevin Benton

Perl/Bugzilla Developer

Advanced Micro Devices

 

The opinions stated in this communication do not necessarily reflect the view of Advanced Micro Devices and have not been reviewed by management.  This communication may contain sensitive and/or confidential and/or proprietary information.  Distribution of such information is strictly prohibited without prior consent of Advanced Micro Devices.  This communication is for the intended recipient(s) only.  If you have received this communication in error, please notify the sender, then destroy any remaining copies of this communication.

 

 


From: [hidden email] [mailto:[hidden email]] On Behalf Of marc jackson
Sent: Wednesday, May 25, 2005 1:01 PM
To: [hidden email]; [hidden email]
Subject: Re: Can't find bugs.

 

Oddly enough, the steps went something like:

1. mysqldump of old bugzilla. 

2. Start mysql on new machine.

3. Bugzilla/checksetup.pl

4. mysql import of old dump.

5. Bugzilla/checksetup.pl

3 - 5 *may* have changed order.  It was late and I was under a bit of pressure. :)

It was the output of mysqldump which infomed me of 3.23 as the original database.

re: The data doesn't show. There's a find button for searching for bugs. That button doesn't work/display information when you try to display bugs from the other machine. When I use that button to display the test bug I created, it works fine.

Thanks for the tip on REPAIR TABLES. I'll try that.

Regards,

Marc




>From: Max Kanat-Alexander <[hidden email]>
>To: [hidden email]
>Subject: Re: Can't find bugs.
>Date: Tue, 24 May 2005 16:44:33 -0700
>
>On Tue, 2005-05-24 at 18:47 +0000, marc jackson wrote:
> > The original bugzilla was 2.18 running on mysql3.23. [ I wish they'd
> > told me that before. *sigh* ]
> >
> > I built bugzilla 2.18.1 running on mysql 4.1.11.
>
> How did you do that? The correct way would have been:
>
> (1) mysqldump on the old MySQL DB.
> (2) import the mysqldump into your 4.1.11
> (3) Have Bugzilla 2.18.1 connect to your database, and run
>checksetup.pl on it, and make sure checksetup.pl doesn't give any
>errors.
>
> The important thing is that there would be NO other steps (except maybe
>creating the 'bugs' user in MySQL 4.1). That is, you want the mysqldump
>import (Step 2) to create the tables as well as the data.
>
> > I can use the find button on a bug #, but the data doesn't display.
>
> Could you explain a bit more what you mean by "the data doesn't
>display?"
>
> > Any thoughts?
>
> Maybe there's something wrong with your indexes? But then you'd
>probably get errors. Still, you could try running REPAIR TABLE on all
>the tables in the Bugzilla database.
>
> -Max
>--
>http://www.everythingsolved.com/
>Everything Solved: Experts at Bugzilla... and everything else, too.
>
>_______________________________________________
>mozilla-webtools mailing list
>[hidden email]
>http://mail.mozilla.org/listinfo/mozilla-webtools

_______________________________________________ mozilla-webtools mailing list [hidden email] http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

Max Kanat-Alexander
In reply to this post by hobbitmage
On Wed, 2005-05-25 at 19:00 +0000, marc jackson wrote:
> Oddly enough, the steps went something like:
>
> 1. mysqldump of old bugzilla.  
>
> 2. Start mysql on new machine.
>
> 3. Bugzilla/checksetup.pl

        This should not have happened here. checksetup should have only been
run after you did the import.

> re: The data doesn't show. There's a find button for searching for
> bugs.

        You mean in the footer, the thing that's just for bug numbers? And when
you type in an old bug number, nothing shows up? Do you get an error
that that bug doesn't exist?

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

RE: Can't find bugs.

hobbitmage
In reply to this post by Benton, Kevin

Hi,

The dump indicated 3.23 on the original bugzilla machine.

I loaded 4.1.11.

mj




>From: "Benton, Kevin" <[hidden email]>
>To: "marc jackson" <[hidden email]>, [hidden email],        [hidden email]
>Subject: RE: Can't find bugs.
>Date: Wed, 25 May 2005 12:10:27 -0700
>
>Are you running the same MySQL version in both cases?
>
>
>
>---
>
>Kevin Benton
>
>Perl/Bugzilla Developer
>
>Advanced Micro Devices
>
>
>
>The opinions stated in this communication do not necessarily reflect the
>view of Advanced Micro Devices and have not been reviewed by management.
>This communication may contain sensitive and/or confidential and/or
>proprietary information.  Distribution of such information is strictly
>prohibited without prior consent of Advanced Micro Devices.  This
>communication is for the intended recipient(s) only.  If you have
>received this communication in error, please notify the sender, then
>destroy any remaining copies of this communication.
>
>
>
>
>
>________________________________
>
>From: [hidden email]
>[mailto:[hidden email]] On Behalf Of marc jackson
>Sent: Wednesday, May 25, 2005 1:01 PM
>To: [hidden email]; [hidden email]
>Subject: Re: Can't find bugs.
>
>
>
>Oddly enough, the steps went something like:
>
>1. mysqldump of old bugzilla.
>
>2. Start mysql on new machine.
>
>3. Bugzilla/checksetup.pl
>
>4. mysql import of old dump.
>
>5. Bugzilla/checksetup.pl
>
>3 - 5 *may* have changed order.  It was late and I was under a bit of
>pressure. :)
>
>It was the output of mysqldump which infomed me of 3.23 as the original
>database.
>
>re: The data doesn't show. There's a find button for searching for bugs.
>That button doesn't work/display information when you try to display
>bugs from the other machine. When I use that button to display the test
>bug I created, it works fine.
>
>Thanks for the tip on REPAIR TABLES. I'll try that.
>
>Regards,
>
>Marc
>
>
>
>
> >From: Max Kanat-Alexander <[hidden email]>
> >To: [hidden email]
> >Subject: Re: Can't find bugs.
> >Date: Tue, 24 May 2005 16:44:33 -0700
> >
> >On Tue, 2005-05-24 at 18:47 +0000, marc jackson wrote:
> > > The original bugzilla was 2.18 running on mysql3.23. [ I wish they'd
> > > told me that before. *sigh* ]
> > >
> > > I built bugzilla 2.18.1 running on mysql 4.1.11.
> >
> > How did you do that? The correct way would have been:
> >
> > (1) mysqldump on the old MySQL DB.
> > (2) import the mysqldump into your 4.1.11
> > (3) Have Bugzilla 2.18.1 connect to your database, and run
> >checksetup.pl on it, and make sure checksetup.pl doesn't give any
> >errors.
> >
> > The important thing is that there would be NO other steps (except
>maybe
> >creating the 'bugs' user in MySQL 4.1). That is, you want the mysqldump
> >import (Step 2) to create the tables as well as the data.
> >
> > > I can use the find button on a bug #, but the data doesn't display.
> >
> > Could you explain a bit more what you mean by "the data doesn't
> >display?"
> >
> > > Any thoughts?
> >
> > Maybe there's something wrong with your indexes? But then you'd
> >probably get errors. Still, you could try running REPAIR TABLE on all
> >the tables in the Bugzilla database.
> >
> > -Max
> >--
> >http://www.everythingsolved.com/
> >Everything Solved: Experts at Bugzilla... and everything else, too.
> >
> >_______________________________________________
> >mozilla-webtools mailing list
> >[hidden email]
> >http://mail.mozilla.org/listinfo/mozilla-webtools
>
>_______________________________________________ mozilla-webtools mailing
>list [hidden email]
>http://mail.mozilla.org/listinfo/mozilla-webtools
_______________________________________________ mozilla-webtools mailing list [hidden email] http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage
In reply to this post by Max Kanat-Alexander

re: when to run bugzilla. Ok ...

re: the find button. I didn't know that it was just for footers.  Yes, nothing shows up. No I don't get an error message.  It just prints a page with a lot of blank fields. When I use the test bug that I created, it prints the same page, previously mentioned, but the fields aren't blank anymore.

Regards,

Marc




>From: Max Kanat-Alexander <[hidden email]>
>To: [hidden email]
>Subject: Re: Can't find bugs.
>Date: Wed, 25 May 2005 13:19:07 -0700
>
>On Wed, 2005-05-25 at 19:00 +0000, marc jackson wrote:
> > Oddly enough, the steps went something like:
> >
> > 1. mysqldump of old bugzilla.
> >
> > 2. Start mysql on new machine.
> >
> > 3. Bugzilla/checksetup.pl
>
> This should not have happened here. checksetup should have only been
>run after you did the import.
>
> > re: The data doesn't show. There's a find button for searching for
> > bugs.
>
> You mean in the footer, the thing that's just for bug numbers? And when
>you type in an old bug number, nothing shows up? Do you get an error
>that that bug doesn't exist?
>
> -Max
>--
>http://www.everythingsolved.com/
>Everything Solved: Experts at Bugzilla... and everything else, too.
>
>_______________________________________________
>mozilla-webtools mailing list
>[hidden email]
>http://mail.mozilla.org/listinfo/mozilla-webtools
_______________________________________________ mozilla-webtools mailing list [hidden email] http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

Max Kanat-Alexander
On Wed, 2005-05-25 at 22:41 +0000, marc jackson wrote:
> It just prints a page with a lot of blank fields.

        That is really strange. I'd guess the import didn't work correctly, and
without direct access to your database to poke around, it would be
almost impossible for me to say how to fix it at this point. Maybe
somebody else has run into this specific issue in the past and could say
without looking at your data, but unless anybody has, that's probably
about where the situation stands.

        Particularly if you attempted to import the *old* structure into the
*new* tables (that is, ran checksetup.pl before you did the import),
then there's no easy way to fix that now, without some very deep
knowledge of the Bugzilla database structure.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage
In terms of the import working:

It seems to have worked.  From mysql's perspective, you can find the
information.
My boss, who's much better with bugzilla, was able to find the information.  
It just seems
like the "find" button doesn't work with the older bugs.

Regards,

Marc

2005 16:14:11 -0700<br>&gt;<br>&gt;On Wed, 2005-05-25 at 22:41 +0000, marc
jackson wrote:<br>&gt; &gt; It just prints a page with a lot of blank
fields.<br>&gt;<br>&gt; That is really strange. I'd guess the import didn't
work correctly, and<br>&gt;without direct access to your database to poke
around, it would be<br>&gt;almost impossible for me to say how to fix it at
this point. Maybe<br>&gt;somebody else has run into this specific issue in
the past and could say<br>&gt;without looking at your data, but unless
anybody has, that's probably<br>&gt;about where the situation
stands.<br>&gt;<br>&gt; Particularly if you attempted to import the *old*
structure into the<br>&gt;*new* tables (that is, ran checksetup.pl before
you did the import),<br>&gt;then there's no easy way to fix that now,
without some very deep<br>&gt;knowledge of the Bugzilla database
structure.<br>&gt;<br>&gt; -Max<br>&gt;--<br>&gt;http://www.everythingsolved.com/<br>&gt;Everything
Solved: Experts at Bugzilla... and everything else,
too.<br>&gt;<br>&gt;_______________________________________________<br>&gt;mozilla-webtools
mailing
list<br>&gt;[hidden email]<br>&gt;http://mail.mozilla.org/listinfo/mozilla-webtools<br>


_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

Max Kanat-Alexander
On Wed, 2005-05-25 at 23:19 +0000, marc jackson wrote:
> It seems to have worked.  From mysql's perspective, you can find the
> information.

        OK. But when you do a Bugzilla upgrade, it actually modifies both the
structure of the database and the data in it. That is, you can't just
directly import old data into new tables--you skip all the work that
checksetup.pl does, hundreds of lines of code.

        So yes, the data could *seem* to be in the database, but there's no way
that it will be in the right format if it wasn't upgraded in the correct
fashion.

        Fixing something like that would either require that you start the
Bugzilla installation process over again from scratch, or that you have
a very deep understanding of checksetup and the MySQL database
structure.

        That is, of course, provided that that's the problem. I'm guessing that
it is, since you have a very strange problem that I can't explain any
other way.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

alx-5
In reply to this post by hobbitmage
hi,

I've had the same problem some months ago.

In my case there went something wrong with the import.
My dataproblem was, that I can't find any bug with the searchfunction
or saved searches although all the bugs were in the database. The only
way to show a bug, was to enter the id in the action menu.

Have you checked the keyvalues in the database? There was my problem.
During the  import the keys have been changed. Until today I don't know
why this happened.
Does your mysqldump include the keys?
Check especially the keyvalues in the tables 'bugs', 'products' and
'profiles'.

If I remember correctly, saniticheck.cgi can say you too, whether all
the id's fit together or not.

hope this may help you.

alx

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage
In reply to this post by Max Kanat-Alexander
Thanks for the info.  So, did the tables change significantly b/n 2.18 &
2.18.1?

Regards,

Marc

<br><br><br>&gt;From: Max Kanat-Alexander
&lt;[hidden email]&gt;<br>&gt;To:
[hidden email]<br>&gt;Subject: Re: Can't find
bugs.<br>&gt;Date: Wed, 25 May 2005 16:24:31 -0700<br>&gt;<br>&gt;On Wed,
2005-05-25 at 23:19 +0000, marc jackson wrote:<br>&gt; &gt; It seems to have
worked.  From mysql's perspective, you can find the<br>&gt; &gt;
information.<br>&gt;<br>&gt; OK. But when you do a Bugzilla upgrade, it
actually modifies both the<br>&gt;structure of the database and the data in
it. That is, you can't just<br>&gt;directly import old data into new
tables--you skip all the work that<br>&gt;checksetup.pl does, hundreds of
lines of code.<br>&gt;<br>&gt; So yes, the data could *seem* to be in the
database, but there's no way<br>&gt;that it will be in the right format if
it wasn't upgraded in the correct<br>&gt;fashion.<br>&gt;<br>&gt; Fixing
something like that would either require that you start the<br>&gt;Bugzilla
installation process over again from scratch, or that you have<br>&gt;a very
deep understanding of checksetup and the MySQL
database<br>&gt;structure.<br>&gt;<br>&gt; That is, of course, provided that
that's the problem. I'm guessing that<br>&gt;it is, since you have a very
strange problem that I can't explain any<br>&gt;other
way.<br>&gt;<br>&gt; -Max<br>&gt;--<br>&gt;http://www.everythingsolved.com/<br>&gt;Everything
Solved: Experts at Bugzilla... and everything else,
too.<br>&gt;<br>&gt;_______________________________________________<br>&gt;mozilla-webtools
mailing list

<br>&gt;[hidden email]<br>&gt;http://mail.mozilla.org/listinfo/mozilla-webtools<br>


_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

Max Kanat-Alexander
On Thu, 2005-05-26 at 21:28 +0000, marc jackson wrote:
> Thanks for the info.  So, did the tables change significantly b/n 2.18 &
> 2.18.1?

        Not a *whole* lot, but they did change, and the changes were certainly
important.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

hobbitmage
In reply to this post by Max Kanat-Alexander
Hello,

So I went back and dropped the bugs database.
I did the import again.
Then I ran checksetup.pl.
Then I ran testserver.pl.

show_bug.cgi isn't displaying the information when one
searches for bugs.

Thoughts?

Regards,

Marc

<br><br><br>&gt;From: Max Kanat-Alexander
&lt;[hidden email]&gt;<br>&gt;To:
[hidden email]<br>&gt;Subject: Re: Can't find
bugs.<br>&gt;Date: Tue, 24 May 2005 16:44:33 -0700<br>&gt;<br>&gt;On Tue,
2005-05-24 at 18:47 +0000, marc jackson wrote:<br>&gt; &gt; The original
bugzilla was 2.18 running on mysql3.23. [ I wish they'd<br>&gt; &gt; told me
that before. *sigh* ]<br>&gt; &gt;<br>&gt; &gt; I built bugzilla 2.18.1
running on mysql 4.1.11.<br>&gt;<br>&gt; How did you do that? The correct
way would have been:<br>&gt;<br>&gt; (1) mysqldump on the old MySQL
DB.<br>&gt; (2) import the mysqldump into your 4.1.11<br>&gt; (3) Have
Bugzilla 2.18.1 connect to your database, and run<br>&gt;checksetup.pl on
it, and make sure checksetup.pl doesn't give
any<br>&gt;errors.<br>&gt;<br>&gt; The important thing is that there would
be NO other steps (except maybe<br>&gt;creating the 'bugs' user in MySQL
4.1). That is, you want the mysqldump<br>&gt;import (Step 2) to create the
tables as well as the data.<br>&gt;<br>&gt; &gt; I can use the find button
on a bug #, but the data doesn't display.<br>&gt;<br>&gt; Could you explain
a bit more what you mean by &quot;the data
doesn't<br>&gt;display?&quot;<br>&gt;<br>&gt; &gt; Any
thoughts?<br>&gt;<br>&gt; Maybe there's something wrong with your indexes?
But then you'd<br>&gt;probably get errors. Still, you could try running
REPAIR TABLE on all<br>&gt;the tables in the Bugzilla
database.<br>&gt;<br>&gt; -Max<br>&gt;--<br>&gt;http://www.everythingsolved.com/<br>&gt;Everything
Solved: Experts at Bugzilla... and everything else,
too.<br>&gt;<br>&gt;_______________________________________________<br>&gt;mozilla-webtools
mailing
list<br>&gt;[hidden email]<br>&gt;http://mail.mozilla.org/listinfo/mozilla-webtools<br>


_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Can't find bugs.

alx-5
In reply to this post by Max Kanat-Alexander
does your import include the keycolumns like bugs.bug_id?
Have you checked that this keyvalues in your old database are the same
values after importing?
Run sanitycheck.cgi - that might give you some hints whats wrong!


marc jackson wrote:

> Hello,
>
> So I went back and dropped the bugs database.
> I did the import again.
> Then I ran checksetup.pl.
> Then I ran testserver.pl.
>
> show_bug.cgi isn't displaying the information when one
> searches for bugs.
>
> Thoughts?
>
> Regards,
>
> Marc
>
> <br><br><br>&gt;From: Max Kanat-Alexander
> &lt;[hidden email]&gt;<br>&gt;To:
> [hidden email]<br>&gt;Subject: Re: Can't find
> bugs.<br>&gt;Date: Tue, 24 May 2005 16:44:33 -0700<br>&gt;<br>&gt;On Tue,
> 2005-05-24 at 18:47 +0000, marc jackson wrote:<br>&gt; &gt; The original
> bugzilla was 2.18 running on mysql3.23. [ I wish they'd<br>&gt; &gt; told me
> that before. *sigh* ]<br>&gt; &gt;<br>&gt; &gt; I built bugzilla 2.18.1
> running on mysql 4.1.11.<br>&gt;<br>&gt; How did you do that? The correct
> way would have been:<br>&gt;<br>&gt; (1) mysqldump on the old MySQL
> DB.<br>&gt; (2) import the mysqldump into your 4.1.11<br>&gt; (3) Have
> Bugzilla 2.18.1 connect to your database, and run<br>&gt;checksetup.pl on
> it, and make sure checksetup.pl doesn't give
> any<br>&gt;errors.<br>&gt;<br>&gt; The important thing is that there would
> be NO other steps (except maybe<br>&gt;creating the 'bugs' user in MySQL
> 4.1). That is, you want the mysqldump<br>&gt;import (Step 2) to create the
> tables as well as the data.<br>&gt;<br>&gt; &gt; I can use the find button
> on a bug #, but the data doesn't display.<br>&gt;<br>&gt; Could you explain
> a bit more what you mean by &quot;the data
> doesn't<br>&gt;display?&quot;<br>&gt;<br>&gt; &gt; Any
> thoughts?<br>&gt;<br>&gt; Maybe there's something wrong with your indexes?
> But then you'd<br>&gt;probably get errors. Still, you could try running
> REPAIR TABLE on all<br>&gt;the tables in the Bugzilla
> database.<br>&gt;<br>&gt; -Max<br>&gt;--<br>&gt;http://www.everythingsolved.com/<br>&gt;Everything
> Solved: Experts at Bugzilla... and everything else,
> too.<br>&gt;<br>&gt;_______________________________________________<br>&gt;mozilla-webtools
> mailing
> list<br>&gt;[hidden email]<br>&gt;http://mail.mozilla.org/listinfo/mozilla-webtools<br>

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools