Is Bugzilla on Windows/IIS a Bad Idea?

[Habers, Mark]

Hi Max,
I'm sorry, but I don't have the details in front of me. I was previously
running BugZilla version 2.17.4 I do remember that an overly problematic
area was the code block in checksetup at line 3573, specifically,
$dbh->bz_drop_column("group_group_map", "isbless");

I was throwing a duplicate key error at that line...and checksetup
stopped there. That's all I can say with confidence until I try and
repeat the install on a local machine somewhere with my old db again.
I'll do it again this week if I can. I seem to recall getting past the
problem by doing that portion manually after issuing a repair table
command... could be wrong though, I tried many things and there were a
couple other errors, but nothing major, I'm running, and my users are
happy. If I duplicate the issues I'll report them next time.

I am more familiar with SQL Server than MySQL... sorry if this is a dumb
question, but is it just a limitation of MySQL that prevents a huge
script like checksetup from continuing on when it runs into a
non-showstopper kind of problem? Would it be technically possible to
port this over to something like SQL Server or Oracle? The frustration
factor increases big time when 1 line out of several thousand has an
issue of some sort and the script just dies instead of executing the
rest... Realizing that sometimes executing the rest wouldn't be a good
idea... but also sometimes it would be if at all possible. I do have to
remind myself that this is a free DB and overall, it rocks.

In fact, if you guys would like some Windows specific QA, I can probably
smk test the install of 'almost ready for production' builds for you
from time to time. I'm probably a good guinea pig after using BZ on
Windows way before I probably should have attempted it.

Thanks
Mark

-----Original Message-----
From: developers-owner at bugzilla.org
[mailto:developers-owner at bugzilla.org] On Behalf Of Max Kanat-Alexander
Sent: Tuesday, August 16, 2005 2:16 PM
To: developers at bugzilla.org
Subject: Re: Is Bugzilla on Windows/IIS a Bad Idea?

On Tue, 2005-08-16 at 09:31 -0400, Habers, Mark wrote:
> The main reason in my case was that I was upgrading a pretty old BZ
> database and checksetup bombed on me repeatedly trying to convert some
> of my tables.

	If you still have the exact error messages around that
checksetup gave
you (or a copy of your old database schema) I'd appreciate a bug report
on that -- checksetup should ideally be able to upgrade from any version
to any version.

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

-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=habers@pbworld.com>