Operating System database field

Neil Griffiths ngriffiths at climax.co.uk
Fri Aug 8 12:46:55 UTC 2003


I don't have a URL for anyone to look at unfortunately, the box is behind
NAT and a firewall otherwise I'd happily give you a link.

The CGI in question is query.cgi - I've included 2 .GIF files (small, I hope
nobody minds!) that show the problem.

One picture shows the output from phpMyAdmin clearly showing the correct
values in the database. The other shows how the query.cgi page does not
reflect this at all... And yes, I've refreshed the page - even though
anything coming from a .cgi file shouldn't be cached anyway...

I'm lost, so if anybody can point me in the correct direction then I'd
appreciate it a lot!

Kind regards,
Neil

----- Original Message -----
From: "Jason Pyeron" <jason at pyeron.com>
To: <developers at bugzilla.org>
Sent: Friday, August 08, 2003 1:08 PM
Subject: Re: Operating System database field


> You are not being very specific, do you have a URL which I may look at.
> Which cgi, does not reflect the change? Where does it not reflect this
> change?
>
> On Fri, 8 Aug 2003, Neil Griffiths wrote:
>
> > Hi,
> >
> > Hang about... I used phpMyAdmin and it shows that the data I edited in
> > localconfig is in the database. However, the CGI produces the old
list...
> > Where would THAT be cached? :o
> >
> > Thanks guys for pointing out localconfig, I'm just not sure now about
what
> > to do next... Perhaps I should remove all files within the data/
directory
> > and re-run ./checksetup.pl ?
> >
> > Kind regards,
> > Neil
> >
> > ----- Original Message -----
> > From: "Mark Ingram" <mark.ingram at nexsan.com>
> > To: <developers at bugzilla.org>
> > Sent: Friday, August 08, 2003 12:46 PM
> > Subject: Re: Operating System database field
> >
> >
> > > Its in bugs,
> > >
> > > you should try www.phpmyadmin.com if you can, gives a real nice n easy
way
> > > of editing DBs.
> > >
> > > bugs.op_sys
> > >
> > > update it to be like
> > >
> > > enum('All', 'PS2', 'Gamecube', 'X-Box')
> > >
> > > or whatever you need
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: developers-owner at bugzilla.org
> > > [mailto:developers-owner at bugzilla.org]On Behalf Of Neil Griffiths
> > > Sent: 08 August 2003 12:42
> > > To: developers at bugzilla.org
> > > Subject: Re: Operating System database field
> > >
> > >
> > > Thanks for the pointer, but still no cigar... :-/
> > >
> > > I edited the localconfig directly and it looks like this now:
> > >
> > > @opsys = (
> > >         "N/A"
> > > );
> > >
> > > @platforms = (
> > >         "All",
> > >         "Gamecube",
> > >         "GBA",
> > >         "PC",
> > >         "PS2",
> > >         "X-Box"
> > > );
> > >
> > > I then re-ran ./checksetup.pl and it still looked the same. Then I
dropped
> > > the table and re-ran ./checksetup.pl again. It STILL shows the default
> > data!
> > > I'm confused as to why...
> > >
> > > I'll have a go at editing the SQL data directly as suggested by Mark.
Can
> > > anybody tell me in which particular table I will find the op_sys field
so
> > > that I can try editing it directly?
> > >
> > > Kind regards,
> > > Neil
> > >
> > > ----- Original Message -----
> > > From: "Bruce Armstrong [TeamSybase]" <bruce.armstrong at teamsybase.com>
> > > To: <developers at bugzilla.org>
> > > Sent: Friday, August 08, 2003 12:25 PM
> > > Subject: Re: Operating System database field
> > >
> > >
> > > > What about just editing the information in the
> > > > localconfig file directly....
> > > >
> > > > --- Neil Griffiths <ngriffiths at climax.co.uk> wrote:
> > > > > Hi,
> > > > >
> > > > > I'm currently setting up a bugzilla installation for
> > > > > use internally here and
> > > > > I'm a bit puzzled. Everything works fine, but I'm
> > > > > customising it to our
> > > > > needs.
> > > > >
> > > > > I initially ran checksetup.pl which got everything
> > > > > running just fine, but
> > > > > we're a games company and so all the different
> > > > > platforms are pretty
> > > > > pointless, we only need Gamecube, GBA, PC, PS2 and
> > > > > X-Box. It also makes the
> > > > > OS field unneeded. I edited the checksetup.pl script
> > > > > so that OS would
> > > > > contain only N/A like so:
> > > > >
> > > > > @opsys = (
> > > > >         "N/A"
> > > > > );
> > > > > ');
> > > > >
> > > > > And then I edited the platforms like so:
> > > > >
> > > > > @platforms = (
> > > > >         "All",
> > > > >         "Gamecube",
> > > > >         "GBA",
> > > > >         "PC",
> > > > >         "PS2",
> > > > >         "X-Box"
> > > > > );
> > > > > ');
> > > > >
> > > > > After running the script again, I saw no changes.
> > > > > Puzzled, I even dropped
> > > > > the bugs table and restarted - but again I see the
> > > > > old platforms and OS
> > > > > data. Where is this stored? I can't find any
> > > > > reference to, say, FreeBSD
> > > > > anywhere in the Bugzilla directory anymore - but
> > > > > it's still coming up. It
> > > > > must be in MySQL (unless Bugzilla caches something
> > > > > somehow) - but how can I
> > > > > get rid of it and change it?
> > > > >
> > > > > Thanks in advance for any help!
> > > > >
> > > > > Kind regards,
> > > > > Neil
> > > > >
> > > > > -
> > > > > To view or change your list settings, click here:
> > > > >
> > > >
> > >
> >
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=bruce.armstrong@teamsybase.com>
> > > >
> > > >
> > > > =====
> > > > Bruce Armstrong [TeamSybase]
> > > > ---------------------------------
> > > > http://www.teamsybase.com
> > > >
> > > > Preach the gospel at all times.
> > > > If necessary, use words.  -- Francis of Assisi
> > > > http://www.needhim.org
> > > > -
> > > > To view or change your list settings, click here:
> > > > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=ngriffiths@climax.co.uk>
> > > >
> > >
> > > -
> > > To view or change your list settings, click here:
> > > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=mark.ingram@nexsan.com>
> > >
> > >
> > > -
> > > To view or change your list settings, click here:
> > > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=ngriffiths@climax.co.uk>
> > >
> >
> > -
> > To view or change your list settings, click here:
> > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=jpyeron@pyerotechnics.com>
> >
>
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> -                                                               -
> - Jason Pyeron                   http://www.pyerotechnics.com   -
> - Owner & Lead                  Pyerotechnics Development, Inc. -
> -                               500 West University Parkway #1S -
> - +1 (410) 808-6646             Baltimore, Maryland  21210-3253 -
> -                                                               -
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you
> have received it in error, purge the message from your system and
> notify the sender immediately.  Any other use of the email by you
> is prohibited.
>
>
>
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=ngriffiths@climax.co.uk>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: phpMyAdmin.gif
Type: image/gif
Size: 2645 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20030808/35faceae/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: query_cgi.gif
Type: image/gif
Size: 5658 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20030808/35faceae/attachment-0001.gif>


More information about the developers mailing list