Project

General

Profile

Problem with "Bulk Time Entry" plugin

Added by Thiago Lima over 14 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 } } )" } %>&nbsp;
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 over 14 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 over 14 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

    (1-2/2)