redmine_task_board icon indicating copy to clipboard operation
redmine_task_board copied to clipboard
verified publisher icon netaustin

Setting Internal Error

Open hanzlik opened this issue 9 years ago • 2 comments

Hi, i'm running: Redmine version -> 2.5.2.stable.13420 Ruby version -> 2.1.5-p273 (2014-11-13) [x86_64-linux] Rails version -> 3.2.19 Environment -> production Database adapter -> Mysql2

I have done all the tasks described in the wiki. I also have done the migration:

Migrating redmine_task_board (Redmine Task Board)... == CreateTaskBoardIssues: migrating ========================================== -- create_table(:task_board_issues) -> 0.0456s == CreateTaskBoardIssues: migrated (0.0458s) =================================

== CreateTaskBoardColumns: migrating ========================================= -- create_table(:task_board_columns) -> 0.0065s -- create_table(:issue_statuses_task_board_columns, {:id=>false}) -> 0.0163s -- add_index(:issue_statuses_task_board_columns, [:issue_status_id, :task_board_column_id], {:name=>"issue_statuses_task_board_columns_idx"}) -> 0.0353s == CreateTaskBoardColumns: migrated (0.0585s) ================================

== CreateTaskBoardAssignees: migrating ======================================= -- create_table(:task_board_assignees) -> 0.0207s -- add_index(:task_board_assignees, :issue_id) -> 0.0230s -- add_index(:task_board_assignees, :assignee_id) -> 0.0292s == CreateTaskBoardAssignees: migrated (0.0733s) ==============================

== CreateStatusBuckets: migrating ============================================ -- create_table(:status_buckets) -> 0.0059s -- drop_table(:issue_statuses_task_board_columns) -> 0.0196s == CreateStatusBuckets: migrated (0.0263s) ===================================

Everything looked fine after that. But when i was going to activate the module in the Settings-Tab, i got on Internal Error. Here's the production.log:

Started GET "/projects/theproject/settings/modules" for 127.0.0.1 at 2016-01-05 11:08:54 +0100 Processing by ProjectsController#settings as HTML Parameters: {"id"=>"project", "tab"=>"modules"} Current user: my.nae (id=myid) Rendered plugins/redmine_dmsf/app/views/hooks/redmine_dmsf/_view_projects_form.html.erb (0.0ms) Rendered projects/_form.html.erb (86.9ms) Rendered projects/_edit.html.erb (89.1ms) Rendered projects/settings/_modules.html.erb (16.7ms) Rendered projects/settings/_members.html.erb (110.4ms) Rendered projects/settings/_versions.html.erb (47.9ms) Rendered projects/settings/_issue_categories.html.erb (3.7ms) Rendered projects/settings/_wiki.html.erb (3.5ms) Rendered projects/settings/_repositories.html.erb (2.9ms) Rendered projects/settings/_boards.html.erb (1.6ms) Rendered projects/settings/_activities.html.erb (18.8ms) Rendered plugins/redmine_backlogs/app/views/backlogs/_project_settings.html.erb (2.6ms) Rendered plugins/redmine_code_review/app/views/code_review_settings/_filters.html.erb (2.0ms) Rendered plugins/redmine_code_review/app/views/code_review_settings/_show.html.erb (21.9ms) Rendered plugins/redmine_task_board/app/views/settings/_column_manager.html.erb (73.2ms) Rendered plugins/redmine_task_board/app/views/settings/_project.html.erb (88.0ms) Rendered common/_tabs.html.erb (422.0ms) Rendered projects/settings.html.erb within layouts/base (424.8ms) Completed 500 Internal Server Error in 440.4ms

ActionView::Template::Error (Mysql2::Error: Unknown column 'task_board_columns.project' in 'where clause': SELECT task_board_columns.* FROM task_board_columns WHERE task_board_columns.project = 135 ORDER BY weight ASC): 19: 20: 21:

22: <% columns.each do |column| %> 23:
24:
25:
<%= column.title %>
app/views/common/_tabs.html.erb:22:in block in _app_views_common__tabs_html_erb___287751597348913041_71868600' app/views/common/_tabs.html.erb:21:ineach' app/views/common/_tabs.html.erb:21:in _app_views_common__tabs_html_erb___287751597348913041_71868600' app/helpers/application_helper.rb:318:inrender_tabs' app/views/projects/settings.html.erb:3:in `_app_views_projects_settings_html_erb__2154319618069903484_71997280'

How can i fix this?

hanzlik avatar Jan 05 '16 10:01 hanzlik

Hallo und Danke für Ihre E-Mail

Leider bin ich bis einschließlich 06.01.2016 im Urlaub. In dringenden Angelegenheiten wenden Sie sich bitte an meine Kollegen Michael (michael@sfxonline), Lukas ([email protected]) oder German ([email protected])

Ich wünsche Ihnen entspannte Festtage und einen guten Rutsch ins Jahr 2016.

Viele Grüße, Jürgen Hörmann

jhit avatar Jan 05 '16 10:01 jhit

I was able to make this work on our 2.4.2 version after editing the following:

Line 4 of /app/views/settings/update.js.erb

From

:columns => TaskBoardColumn.where(:project => @project.id).order('weight ASC'),

To

:columns => TaskBoardColumn.where(:project_id => @project.id).order('weight ASC'),

Line 27 of /app/views/settings/_project.html.erb

From

:columns => TaskBoardColumn.where(:project => @project.id).order("weight ASC"),

To

:columns => TaskBoardColumn.where(:project_id => @project.id).order("weight ASC"),

emaynard avatar Feb 10 '16 14:02 emaynard