Problem with "Bulk Time Entry" plugin
Added by Thiago Lima about 15 years ago
I already reported this as an issue: https://projects.littlestreamsoftware.com/issues/3311
This seems to be a PostgreSQL error, but as I know nothing about Ruby, I couldn't try anything. (Actually, I couldn't even find out where this psql query is built... =S)
production.log
Processing BulkTimeEntriesController#index (for 172.17.166.101 at 2009-11-26 13:16:41) [GET]
Parameters: {"action"=>"index", "controller"=>"bulk_time_entries"}
Rendering template within layouts/base
Rendering bulk_time_entries/index
ActionView::TemplateError (PGError: ERROR: invalid input syntax for integer: "<"
: SELECT * FROM "issues" WHERE ("issues"."project_id" = E'<') ) on line #15 of vendor/plugins/redmine-bulk-time-entry-plugin/app/views/bulk_time_entries/_time_entry.html.erb:
12: { :onchange => "new Ajax.Request('#{url_for :action => 'load_assigned_issues'}', { parameters: { project_id: 'X', entry_id: $(this).up(1).id } } )" } %>
13: </p>
14: <p id="entry_<%= rnd %>_issues">
15: <% @issues = controller.get_issues projects.first %>
16: <%= render :partial => 'issues_selector', :locals => { :issues => @issues, :f => f, :rnd => rnd } %>
17: </p>
18: <p>
vendor/plugins/redmine-bulk-time-entry-plugin/app/controllers/bulk_time_entries_controller.rb:19:in `get_issues'
vendor/plugins/redmine-bulk-time-entry-plugin/app/views/bulk_time_entries/_time_entry.html.erb:15
vendor/plugins/redmine-bulk-time-entry-plugin/app/views/bulk_time_entries/_time_entry.html.erb:1
vendor/plugins/redmine-bulk-time-entry-plugin/app/views/bulk_time_entries/index.html.erb:5
vendor/plugins/redmine-bulk-time-entry-plugin/app/views/bulk_time_entries/index.html.erb:3
passenger (2.2.5) lib/phusion_passenger/rack/request_handler.rb:95:in `process_request'
passenger (2.2.5) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
passenger (2.2.5) lib/phusion_passenger/utils.rb:183:in `safe_fork'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:163:in `start'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
passenger (2.2.5) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
Rendering /srv/www/redmine/public/500.html (500 Internal Server Error)
script/about
About your application's environment
Ruby version 1.8.7 (i586-linux)
RubyGems version 1.3.5
Rack version 1.0
Rails version 2.3.4
Active Record version 2.3.4
Active Resource version 2.3.4
Action Mailer version 2.3.4
Active Support version 2.3.4
Application root /srv/www/redmine
Environment production
Database adapter postgresql
Database schema version 20091114105931
About your Redmine plugins
Redmine Code Review plugin 0.2.7
Bulk Time Entry 0.3.0
Stuff To Do Plugin 0.3.0
Scrumdashboard plugin 1.2
Timesheet Plugin 0.5.0
Google Calendar Plugin 0.1.2
Replies (2)
RE: Problem with "Bulk Time Entry" plugin - Added by Thiago Lima about 15 years ago
I forgot to say that both, Redmine and the plugin, are up to date, with the last revision.
RE: Problem with "Bulk Time Entry" plugin - Added by Eric Davis almost 15 years ago
Thanks for the report, I've opened a new bug on my Redmine for the plugin. I'll try to take a look at it for the next release of the plugin.
https://projects.littlestreamsoftware.com/issues/3502
Eric Davis