Content
View differences
Updated by Jonas Heinrich (Finn) over 10 years ago
When I click “Budgets” in the project menu i get the error message
- I am a project member with the project role “Project Admin” and “Controller”
- The Cost Reports and Controlling modules are both activated
- The same error appears if at least one budget is created and if no budget is created

**Stacktrace**
Started GET "/ite2/projects/test-jonas/cost_objects" for 217.92.230.129 at 2015-09-15 17:01:31 +0200
Processing by CostObjectsController#index as HTML
Parameters: {"project_id"=>"test-jonas"}
OpenProject User: Heinrich# Jonas (j.heinrich@finn.de ID: 115 <j.heinrich@finn.de>)
Rendered vendor/bundle/ruby/2.1.0/bundler/gems/openproject-costs-abdf01b28e53/app/views/shared/_costs_header.html.erb (2.0ms)
Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(*) FROM `cost_objects` WHERE ((projects.id = 207) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='costs_mo
dule')))
Rendered vendor/bundle/ruby/2.1.0/bundler/gems/openproject-costs-abdf01b28e53/app/views/cost_objects/index.html.erb within layouts/base (39.6ms)
Completed 500 Internal Server Error in 90ms (ActiveRecord: 9.0ms)
ActionView::Template::Error (Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(*) FROM `cost_objects` WHERE ((projects.id = 207) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modul
es em WHERE em.name='costs_module')))):
23: <% html_title(l(:label_cost_object_plural)) %>
24: <%= toolbar title: l(:label_cost_object_plural) %>
25:
26: <% if @cost_objects.empty? %>
27: <p class="nodata"><%= l(:label_no_data) %></p>
28: <% else %>
29: <%= render :partial => 'list', :locals => {:cost_objects => @cost_objects} %>
app/middleware/params_parser_with_exclusion.rb:40:in `call'
- I am a project member with the project role “Project Admin” and “Controller”
- The Cost Reports and Controlling modules are both activated
- The same error appears if at least one budget is created and if no budget is created

**Stacktrace**
Started GET "/ite2/projects/test-jonas/cost_objects" for 217.92.230.129 at 2015-09-15 17:01:31 +0200
Processing by CostObjectsController#index as HTML
Parameters: {"project_id"=>"test-jonas"}
OpenProject User: Heinrich# Jonas (j.heinrich@finn.de ID: 115 <j.heinrich@finn.de>)
Rendered vendor/bundle/ruby/2.1.0/bundler/gems/openproject-costs-abdf01b28e53/app/views/shared/_costs_header.html.erb (2.0ms)
Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(*) FROM `cost_objects` WHERE ((projects.id = 207) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='costs_mo
dule')))
Rendered vendor/bundle/ruby/2.1.0/bundler/gems/openproject-costs-abdf01b28e53/app/views/cost_objects/index.html.erb within layouts/base (39.6ms)
Completed 500 Internal Server Error in 90ms (ActiveRecord: 9.0ms)
ActionView::Template::Error (Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(*) FROM `cost_objects` WHERE ((projects.id = 207) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modul
es em WHERE em.name='costs_module')))):
23: <% html_title(l(:label_cost_object_plural)) %>
24: <%= toolbar title: l(:label_cost_object_plural) %>
25:
26: <% if @cost_objects.empty? %>
27: <p class="nodata"><%= l(:label_no_data) %></p>
28: <% else %>
29: <%= render :partial => 'list', :locals => {:cost_objects => @cost_objects} %>
app/middleware/params_parser_with_exclusion.rb:40:in `call'