Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Setting Internal Error #41

Open
thejulian opened this issue Jan 5, 2016 · 2 comments
Open

Setting Internal Error #41

thejulian opened this issue Jan 5, 2016 · 2 comments

Comments

@thejulian
Copy link

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?

@jhit
Copy link

jhit commented Jan 5, 2016

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

@emaynard
Copy link

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"),

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants