I have installed redmine(5.0.10) on Centos7.9. I'm able to login but when I try to access settings page getting

Hi,

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

The command: RAILS_ENV=production bundle exec rake db:migrate has already been executed.
But the command RAILS_ENV=production bundle exec rake redmine:load_default_data was executed.
It prompted the error: Error: Mysql2::Error: unknown column in “where clause” roles.builtin
Default configuration data was not loaded.

\redmine5.0.10\log\production.log here is log details :

[151133d2-55cb-49ee-8b7e-14450824bbfd]
[151133d2-55cb-49ee-8b7e-14450824bbfd] app/models/setting.rb:280:in `check_cache'
[151133d2-55cb-49ee-8b7e-14450824bbfd] app/controllers/application_controller.rb:102:in `user_setup'
I, [2024-12-07T10:18:22.990429 #32446] INFO -- : [974aa451-20b1-4d33-b41e-24abff9d6418] Started GET "/" for 192.168.10.4 at 2024-12-07 10:18:22 +0800
I, [2024-12-07T10:18:22.991139 #32446] INFO -- : [974aa451-20b1-4d33-b41e-24abff9d6418] Processing by WelcomeController#index as HTML
I, [2024-12-07T10:18:22.992879 #32446] INFO -- : [974aa451-20b1-4d33-b41e-24abff9d6418] Completed 500 Internal Server Error in 2ms (ActiveRecord: 0.6ms | Allocations: 327)
F, [2024-12-07T10:18:22.994519 #32446] FATAL -- : [974aa451-20b1-4d33-b41e-24abff9d6418]
[974aa451-20b1-4d33-b41e-24abff9d6418] ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'updated_on' in 'field list'):
[974aa451-20b1-4d33-b41e-24abff9d6418]
[974aa451-20b1-4d33-b41e-24abff9d6418] app/models/setting.rb:280:in `check_cache'
[974aa451-20b1-4d33-b41e-24abff9d6418] app/controllers/application_controller.rb:102:in `user_setup'

Replies (2)

RE: I have installed redmine(5.0.10) on Centos7.9. I'm able to login but when I try to access settings page getting - Added by Holger Just 17 days ago

Verify that your application server is also started with RAILS_ENV=production. By default, it uses the development environment. If you have configured a different database for the development environment in your config/database.yml, you may possible end up in an unexpected database which was not migrated correctly.

RE: I have installed redmine(5.0.10) on Centos7.9. I'm able to login but when I try to access settings page getting - Added by danhan Huan 17 days ago

config/database.yml configured

production:
  adapter: mysql2
  database: redmine
  host: 127.0.0.1
  username: root
  password: "admin@123456" 
  # Use "utf8" instead of "utfmb4" for MySQL prior to 5.7.7
  encoding: utf8mb4

development:
  adapter: mysql2
  database: redmine
  host: 127.0.0.1
  username: root
  password: "admin@123456" 
  port: 3307
  # Use "utf8" instead of "utfmb4" for MySQL prior to 5.7.7
  encoding: utf8mb4

(1-2/2)

Project

General

Profile

Redmine