Recc's for web based ticket system?

[bug_girl]

So, I now am suddenly in charge of two huge web projects, with a total of 8 different people making changes and repairs on a database and a website.

I need to figure out how to implement a issue and change tracking and reporting system--fast.

I looked at this system:
http://www.hosted-projects.com/trac/TracDemo/Demo/wiki/TracInstall
but it seems to be a bit iffy for mySQL.
Also, not sure if we have python available on a server, although we do have apache on a couple.

Anyone else have some recommendations on good freeware systems, or things to avoid?

and yeah, it has to be free or really cheap.
Thanks so much guys--you are always very helpful!

bug

[xenxabar]

Have you looked into Bugzilla (http://www.bugzilla.org/)? I haven't tried OnTime 2006 (http://www.axosoft.com/Products/downloads.aspx) but it looks fantastic and has a free single user version, but I don't know if it will suit your needs.

[Puggy]

I use Mantis, it's excellent for my needs, don't know for yours. It's PHP and mySQL based, though: http://www.mantisbt.org/

[bug_girl]

ooh, hey, these look great!
As a bonus, most have bug themes, too :D
I'm reading through the docs to figure out if outsiders can submit tickets--I'm sure that it's in there somewhere.

(and yes, I do actually RTFM. Sometimes, anyway :) )

[kevin]

bugzilla is hard for end users.

I would look a Trac again. Don't go with the MySQL version, go with SQLite. SQLite is really cool. It doesn't need a server component -- everything is stored in one file and a library is used to access the data in the file. Works great. I've got both MySQL and SQLite on my Linux box with no problems.