Project

General

Profile

Internal error 500 - while opening projects and issues

Added by Kevin Schulz about 1 year ago

Hi everyone,

i bought the AlphaNodes Plugin Bundle and have tried to implement these.
I installed the Plugins in a test environment (copy from production environment but with a new empty database) uninstall some redminex plugins and install the alpha nodes plugins -> no problem! Eveything is working.
Now i tried the same in a test environment (copy from production environment with the database with live data -> i can't open the project and issues lists -> everything else is working.
Before i installed the AlphaNodes Plugins i had to uninstall some Redmine X Plugins. (on the AlphaNode webpage is described that they don't work together)
So i guess i have a database problem? Cause thats the main difference between the both test environments Maybe someone can help me here or has a few tips:

Information about Redmine and Plugins (same like in the test environment with the new database -> which is working without problem)
Environment:
Redmine version 5.0.5.stable
Ruby version 3.0.2-p107 (2021-07-07) [x86_64-linux-gnu]
Rails version 6.1.7.2
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
Redmine settings:
Redmine theme Default
SCM:
Subversion 1.14.1
Git 2.34.1
Filesystem
Redmine plugins:
additional_tags 3.0.9
additionals 3.0.9
redmine_agile 1.6.5
redmine_automation 3.0.9
redmine_checklists 3.1.22
redmine_db 3.0.9
redmine_devops 3.0.9
redmine_hrm 3.0.9
redmine_more_previews 5.0.8
redmine_reporting 3.0.9
redmine_x_agile_my_page 1.1.4

Internal error 500 while opening project list and issues list in every project
https://redmine-test.xyz.de/projects
https://redmine-test.xyz.de/projects/agile-methoden/issues

Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.
If you are the Redmine administrator, check your log files for details about the error.
Back

In the /var/www/redmine/log/production.log is the following error:

I, [2023-12-01T07:29:50.342222 #14458] INFO -- : [c9d60f03-89a0-4c7c-b031-136d4504233d] Rendered plugins/redmine_reporting/app/views/issues/index.html.slim within layouts/base (Duration: 4.7ms | Allocations: 2047)
I, [2023-12-01T07:29:50.342275 #14458] INFO -- : [c9d60f03-89a0-4c7c-b031-136d4504233d] Rendered layout layouts/base.html.erb (Duration: 4.9ms | Allocations: 2091)
I, [2023-12-01T07:29:50.342490 #14458] INFO -- : [c9d60f03-89a0-4c7c-b031-136d4504233d] Completed 500 Internal Server Error in 46ms (ActiveRecord: 8.3ms | Allocations: 20766)
F, [2023-12-01T07:29:50.343249 #14458] FATAL -- : [c9d60f03-89a0-4c7c-b031-136d4504233d]
[c9d60f03-89a0-4c7c-b031-136d4504233d] ActionView::Template::Error (Array::ArrayRowIsNotAHash):
[c9d60f03-89a0-4c7c-b031-136d4504233d] 20: = form_tag _project_issues_path(Herve Harster), method: :get, id: 'query_form' do
[c9d60f03-89a0-4c7c-b031-136d4504233d] 21: = render 'additionals/h2_with_query_search',
[c9d60f03-89a0-4c7c-b031-136d4504233d] 22: title: :label_issue_plural,
[c9d60f03-89a0-4c7c-b031-136d4504233d] 23: title_info: live_search_title_info(:issue),
[c9d60f03-89a0-4c7c-b031-136d4504233d] 24: css_class: 'issue',
[c9d60f03-89a0-4c7c-b031-136d4504233d] 25: q: params[:search]
[c9d60f03-89a0-4c7c-b031-136d4504233d] 26: = render_query_description @query
[c9d60f03-89a0-4c7c-b031-136d4504233d]
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/additionals/lib/additionals/helpers.rb:45:in `live_search_title_info'
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/redmine_reporting/app/views/issues/index.html.slim:23
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/redmine_reporting/app/views/issues/index.html.slim:20
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/redmine_reporting/lib/redmine_reporting/patches/issues_controller_patch.rb:76:in `block (2 levels) in index_with_reporting'
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/redmine_reporting/lib/redmine_reporting/patches/issues_controller_patch.rb:48:in `index_with_reporting'
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/redmine_reporting/lib/redmine_reporting/sweeper.rb:10:in `around'
[c9d60f03-89a0-4c7c-b031-136d4504233d] plugins/redmine_reporting/lib/redmine_reporting/sweeper.rb:10:in `around'
[c9d60f03-89a0-4c7c-b031-136d4504233d] lib/redmine/sudo_mode.rb:61:in `sudo_mode'

Maybe someone would like to help me.
If you need more information - let me know.

Thank you
Kevin


Replies (1)

RE: Internal error 500 - while opening projects and issues - Added by Kevin Schulz about 1 year ago

Hi all,
problem is solved.
We used "RedmineUP Helpdesk" before we now installed "AlphaNodes Servicedesk".
This both plugins use some same database named tables.
AlphaNodes provide a script for the nessesary database adaptations.(migration)

Kind regard
Kevin

    (1-1/1)