Error using this plugin with a postgres DB.

[thafreak]

It seems you're using integers for boolean values, which is ok with mysql, but it makes postgres angry. Here's the output from my production logs:

Processing GitosisPublicKeysController#index (for 10.96.2.8 at 2010-06-15 17:14:47) [GET] Parameters: {"action"=>"index", "controller"=>"gitosis_public_keys"}

ActiveRecord::StatementInvalid (PGError: ERROR: operator does not exist: boolean = integer LINE 1: ... FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND (... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT * FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND ("gitosis_public_keys".user_id = 4) ORDER BY active DESC, created_at DESC): /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:188:in log' /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:503:inexecute' /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:1000:in select_raw' /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:987:inselect' /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in select_all_without_query_cache' /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:62:inselect_all' /vendor/rails/activerecord/lib/active_record/base.rb:635:in find_by_sql' /vendor/rails/activerecord/lib/active_record/base.rb:1490:infind_every' /vendor/rails/activerecord/lib/active_record/base.rb:589:in find' /vendor/rails/activerecord/lib/active_record/base.rb:609:inall' /vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:370:in send' /vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:370:inmethod_missing' /vendor/rails/activerecord/lib/active_record/base.rb:2005:in with_scope' /vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:202:insend' /vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:202:in with_scope' /vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:366:inmethod_missing' /vendor/plugins/redmine_gitosis/app/controllers/gitosis_public_keys_controller.rb:17:in index' /vendor/rails/actionpack/lib/action_controller/base.rb:1256:insend' /vendor/rails/actionpack/lib/action_controller/base.rb:1256:in perform_action_without_filters' /vendor/rails/actionpack/lib/action_controller/filters.rb:617:incall_filters' /vendor/rails/actionpack/lib/action_controller/filters.rb:610:in perform_action_without_benchmark' /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:inperform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in measure' /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:inperform_action_without_rescue' /vendor/rails/actionpack/lib/action_controller/rescue.rb:136:in perform_action' /vendor/rails/actionpack/lib/action_controller/base.rb:524:insend' /vendor/rails/actionpack/lib/action_controller/base.rb:524:in process_without_filters' /vendor/rails/actionpack/lib/action_controller/filters.rb:606:inprocess_without_session_management_support' /vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in process_without_test' /vendor/rails/actionpack/lib/action_controller/test_process.rb:18:inprocess' /vendor/rails/actionpack/lib/action_controller/base.rb:392:in process' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:184:inhandle_request' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:112:in dispatch_unlocked' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:125:indispatch' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:124:in synchronize' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:124:indispatch' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:134:in dispatch_cgi' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:41:indispatch' /usr/lib/ruby/1.8/mongrel/rails.rb:76:in process' /usr/lib/ruby/1.8/mongrel/rails.rb:74:insynchronize' /usr/lib/ruby/1.8/mongrel/rails.rb:74:in process' /usr/lib/ruby/1.8/mongrel.rb:159:inprocess_client' /usr/lib/ruby/1.8/mongrel.rb:158:in each' /usr/lib/ruby/1.8/mongrel.rb:158:inprocess_client' /usr/lib/ruby/1.8/mongrel.rb:285:in run' /usr/lib/ruby/1.8/mongrel.rb:285:ininitialize' /usr/lib/ruby/1.8/mongrel.rb:285:in new' /usr/lib/ruby/1.8/mongrel.rb:285:inrun' /usr/lib/ruby/1.8/mongrel.rb:268:in initialize' /usr/lib/ruby/1.8/mongrel.rb:268:innew' /usr/lib/ruby/1.8/mongrel.rb:268:in run' /usr/lib/ruby/1.8/mongrel/configurator.rb:282:inrun' /usr/lib/ruby/1.8/mongrel/configurator.rb:281:in each' /usr/lib/ruby/1.8/mongrel/configurator.rb:281:inrun' /usr/bin/mongrel_rails:129:in run' /usr/lib/ruby/1.8/mongrel/command.rb:212:inrun' /usr/bin/mongrel_rails:282

Rendering /usr/share/redmine/public/500.html (500 Internal Server Error)

[takahashim]

I'm using this plugin on PostgreSQL with the patch: http://github.com/takahashim/redmine-gitosis/commit/7aae5d14210720f07b429adf41857bffe65fb86a

It seems to work.