We use (a heavily customized version of) Keystone. Works reasonably well. It's powerful enough for our needs, yet simple.

We switched to Keystone from Mantis. Mantis was too limited.

Other bug tracking systems, like Bugzilla, have too many useless features, and they're too difficult to install. Looking at FogBUGZ, but will probably stick with Keystone.