I noticed that BugZilla 2.18 is finally capable of working on windows, so I decided to make a grab for it and finally have something better than an excel sheet to list my bugs.

This page tells you how to do it.
I found it very amusing that the first sentence in this page is: "Bugzilla version 2.18 is the first release that runs unmodified on Windows."

Then it follows with a 15 pages of instructions of how to install it.
In order to get it to work, you need:

• Install MySQL 4.0.
• Install MySQL Control Center.
• Manually create bugs data base and users.
• Install ActiveState Perl.
• Create a temporary directory at "C:\Temp".
• Install perl's modules using some arcane syntax. {Case sensitive}
• Install Apache2 and configure it as a service (not to run as SYSTEM).
• Configure Apache2 by editing strange configuration files.
• Grant write access to several directories.
• Edit Apache2 configurations file.
• Hack the registery.
• Download some utitlies and hack the code so I wouldn't have to have a usr/lib directory
• Now you get to run the bugzilla script
• Edit some more configuration files (this time bugzilla's)
• Run more scripts
• Set some scripts to run as scheduled tasks
• Launch browser and set personal info on the bugzilla system
• Setup backup for the system.

And now you can use this.

First, a big thanks for Byron Jones, who created the list above (the 15 pages version, that is).
Second, if this is running unmodified, I would hate to see what it was like before. {As a matter of fact, that was the reason I avoided it until now.}

Third, it took me about four hours to make this work.