プロジェクト

全般

プロフィール

Vote #66397

完了

Error when adding/creating groups

Admin Redmine さんが約3年前に追加. 約3年前に更新.

ステータス:
Closed
優先度:
通常
担当者:
-
カテゴリ:
Groups_27
対象バージョン:
開始日:
2010/01/22
期日:
進捗率:

0%

予定工数:
category_id:
27
version_id:
15
issue_org_id:
4632
author_id:
2275
assigned_to_id:
0
comments:
3
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
ステータス-->[Closed]

説明

I've updated redmine to the latest trunk. When I try to create a new group I get an error 500. 

Here is the trace from the event
Processing GroupsController#create (for 82.127.39.172 at 2010-01-21 12:36:30) [POST]
  Parameters: {"commit"=>"Create", "action"=>"create", "authenticity_token"=>"MN1CPMMOikf/8G32WFAo+fpkEVLzc+Cpi6V9APP2SZA=", "controller"=>"groups", "group"=>{"lastname"=>"a"}}

ActiveRecord::StatementInvalid (Mysql::Error: Column 'login' cannot be null: INSERT INTO `users` (`status`, `created_on`, `last_login_on`, `hashed_password`, `language`, `updated_on`, `admin`, `type`, `firstname`, `lastname`, `mail`, `identity_url`, `mail_notification`, `auth_source_id`, `login`) VALUES(1, '2010-01-21 12:36:30', NULL, '', '', '2010-01-21 12:36:30', 0, 'Group', '', 'a', '', NULL, 1, NULL, NULL)):
  app/controllers/groups_controller.rb:69:in `create'
  app/controllers/groups_controller.rb:68:in `create'
  passenger (2.2.8) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
  passenger (2.2.8) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
  passenger (2.2.8) lib/phusion_passenger/railz/application_spawner.rb:385:in `start_request_handler'
  passenger (2.2.8) lib/phusion_passenger/railz/application_spawner.rb:343:in `handle_spawn_application'
  passenger (2.2.8) lib/phusion_passenger/utils.rb:184:in `safe_fork'
  passenger (2.2.8) lib/phusion_passenger/railz/application_spawner.rb:341:in `handle_spawn_application'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:163:in `start'
  passenger (2.2.8) lib/phusion_passenger/railz/application_spawner.rb:209:in `start'
  passenger (2.2.8) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
  passenger (2.2.8) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
  passenger (2.2.8) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
  passenger (2.2.8) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
  passenger (2.2.8) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  passenger (2.2.8) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
  passenger (2.2.8) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
  passenger (2.2.8) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  passenger (2.2.8) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

Rendering /var/lib/redmine-0.7-dev/public/500.html (500 Internal Server Error)

And here is my redmine environment

About your application's environment
Ruby version              1.8.6 (i486-linux)
RubyGems version          1.3.5
Rack version              1.0
Rails version             2.3.5
Active Record version     2.3.5
Active Resource version   2.3.5
Action Mailer version     2.3.5
Active Support version    2.3.5
Application root          /var/lib/redmine-0.7-dev
Environment               production
Database adapter          mysql
Database schema version   20091227112908

About your Redmine plugins
Google Analytics plugin              0.2.0
Redmine System Notification plugin   0.2.0
Bots filter                          1.02

journals

Well, this should not happen. The login column of the users table is defined to have an empty string by default which should be inserted automatically during that insert. At least, that's what my Postgres databases do :)

Could you possibly provide the actual database-schema of your current users table?
Also, which version of MySQL are you using?
--------------------------------------------------------------------------------
MySql Server version: 5.0.51a-3ubuntu5.4

Here is the screenshot of my schema. If you want the text tell me the sql command because I'm not that familiar with MySql system queries.

!Picture_3.png!

--------------------------------------------------------------------------------
I'm not able to reproduce with the same exact Mysql version (5.0.51a-3ubuntu5.4) but r3343 should fix it.
--------------------------------------------------------------------------------


related_issues

duplicates,Closed,4693,Add Group: 'hashed_password' cannot be null

Admin Redmine さんが約3年前に更新

  • カテゴリGroups_27 にセット
  • 対象バージョン0.9.1_15 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0