Fixes spent time column sort for postgresql.
Fixes test conditions.
Removed open/closed percentage on the roadmap.
Adds a test for invalid query statement.
Makes spent time column available on the issue list (#971).
Rails3: model: replace deprecated validate method at watcher model
add unit test to validate watcher
Rails3: model: replace deprecated before_save method at UserPreference model
add unit test to ensure user preference others is hash in saving
Rails3: model: replace deprecated validate method at member_role model
