search

clueware / redmine_my_roadmaps

Redmine plugin that expose global roadmaps for the user's projects.
39 stars 10 forks source link

PG::Error: ERROR: operator does not exist: boolean = integer LINE 1: SELECT * FROM "trackers" WHERE (is_in_roadmap = 1) ORDER BY... #11

Closed itpark closed 12 years ago

itpark commented 12 years ago

hi,

when i install this plugin I get some error as flow:

ActiveRecord::StatementInvalid (PG::Error: ERROR: operator does not exist: boolean = integer LINE 1: SELECT * FROM "trackers" WHERE (is_in_roadmap = 1) ORDER BY... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT * FROM "trackers" WHERE (is_in_roadmap = 1) ORDER BY position): vendor/plugins/redmine_my_roadmaps/app/controllers/my_roadmaps_controller.rb:82:in initialize' passenger (3.0.12) lib/phusion_passenger/rack/request_handler.rb:96:inprocess_request' passenger (3.0.12) lib/phusion_passenger/abstract_request_handler.rb:513:in accept_and_process_next_request' passenger (3.0.12) lib/phusion_passenger/abstract_request_handler.rb:274:inmain_loop' passenger (3.0.12) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in start_request_handler' passenger (3.0.12) lib/phusion_passenger/classic_rails/application_spawner.rb:275:insend' passenger (3.0.12) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in handle_spawn_application' passenger (3.0.12) lib/phusion_passenger/utils.rb:479:insafe_fork' passenger (3.0.12) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in handle_spawn_application' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:357:insend' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:357:in server_main_loop' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:206:instart_synchronously' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:180:in start' passenger (3.0.12) lib/phusion_passenger/classic_rails/application_spawner.rb:149:instart' passenger (3.0.12) lib/phusion_passenger/spawn_manager.rb:219:in spawn_rails_application' passenger (3.0.12) lib/phusion_passenger/abstract_server_collection.rb:132:inlookup_or_add' passenger (3.0.12) lib/phusion_passenger/spawn_manager.rb:214:in spawn_rails_application' passenger (3.0.12) lib/phusion_passenger/abstract_server_collection.rb:82:insynchronize' passenger (3.0.12) lib/phusion_passenger/abstract_server_collection.rb:79:in synchronize' passenger (3.0.12) lib/phusion_passenger/spawn_manager.rb:213:inspawn_rails_application' passenger (3.0.12) lib/phusion_passenger/spawn_manager.rb:132:in spawn_application' passenger (3.0.12) lib/phusion_passenger/spawn_manager.rb:275:inhandle_spawn_application' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:357:in __send__' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:357:inserver_main_loop' passenger (3.0.12) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' passenger (3.0.12) helper-scripts/passenger-spawn-server:99

Rendering /opt/lampp/htdocs/redmine-1.4.0/public/500.html (500 Internal Server Error)

clueware commented 12 years ago

PG:Error suggest you're using Postgresql which, as a matter of fact, I've not tested. Could you provide me with the following information please:

Thanks a lot!

clueware commented 12 years ago

Hey Itpark!

I've found the cause of the issue, the plugin is now working properly with Postgres - well, at least version 9.1. Feel free to reopen an issue if the version 0.1.6 does not fix the problem for you!

itpark commented 12 years ago

OK！ this great fix .

thanks!