Project

General

Profile

Actions

Defect #19588

closed

Invalid column size for language pt-BR

Added by José Cavalcanti over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I installed Redmine 3.0.1 recently with default language pt-BR, no problem during the instalation. However, when logging in the first time I got error 500. Looking logs I found:

Mysql2::Error: Data too long for column 'language' at row 1

I saw the table users and confirmed the size of column language is 2, but the language I was trying to put is 'pt-BR' (size 4).

After that I got another errors on non-created tables like `settings`

Full error log:

Mysql2::Error: Data too long for column 'language' at row 1: INSERT INTO `users` (`firstname`, `lastname`, `mail`, `language`, `login`, `hashed_password`, `admin`, `created_on`, `updated_on`) VALUES ('Administrator', 'Admin', 'tec.ic.gc@phoebustecnologia.com.br', 'pt-br', 'admin', '594e6525619e6b4f20c0f523c95b0f0830b9c013', 1, '2015-04-10 10:49:29.979955', '2015-04-10 10:49:29.979955')
Mysql2::Error: Unknown column 'roles.builtin' in 'where clause': SELECT  1 AS one FROM `roles` WHERE `roles`.`builtin` = 0 LIMIT 1
Started GET "/redmine/" for 127.0.0.1 at 2015-04-10 10:54:23 -0300
Processing by WelcomeController#index as HTML
Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM `settings`
Completed 500 Internal Server Error in 0ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM `settings`):
  app/models/setting.rb:186:in `check_cache'
  app/controllers/application_controller.rb:100:in `user_setup'

Started GET "/redmine/" for 127.0.0.1 at 2015-04-10 10:56:31 -0300
Processing by WelcomeController#index as HTML
Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM `settings`
Completed 500 Internal Server Error in 16ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM `settings`):
  app/models/setting.rb:186:in `check_cache'
  app/controllers/application_controller.rb:100:in `user_setup'

Related issues

Related to Redmine - Defect #20176: Defect on user table migrate code Closed

Actions
Actions

Also available in: Atom PDF