Redmine

Here is an abstract from the log-file:

Processing IssuesController#update (for 217.194.224.41 at 2011-01-28 08:16:15) [PUT]
Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"11", "hours"=>"1"}, "commit"=>"OK", "notes"=>"", "action"=>"update", "_method"=>"put", "authenticity_token"=>"RtePQvF2C1y4+riticGrKNYBTIXWeOUUUW0QylCkpx0=", "id"=>"90", "issue"=>{"support_urls"=>"", "start_date"=>"2010-12-14", "estimated_hours"=>"3", "priority_id"=>"5", "parent_issue_id"=>"54", "lock_version"=>"2", "done_ratio"=>"100", "assigned_to_id"=>"6", "subject"=>"The adding of extra Keywords to the search bar and navigation bar is only functional on the DAMS tab yet, not on the Flickr and Dreamtime tab", "tracker_id"=>"2", "due_date"=>"", "status_id"=>"5", "description"=>""}, "controller"=>"issues", "attachments"=>{"1"=>{"description"=>""}}}

ActiveRecord::StatementInvalid (Mysql::Error: Column 'role' cannot be null: INSERT INTO `time_entries` (`comments`, `created_on`, `cost`, `project_id`, `issue_id`, `tmonth`, `activity_id`, `role`, `spent_on`, `updated_on`, `user_id`, `hours`, `tyear`, `tweek`) VALUES):
app/models/issue.rb:502:in `save_issue_with_child_records'
app/models/issue.rb:494:in `save_issue_with_child_records'
app/controllers/issues_controller.rb:170:in `update'
public/dispatch.fcgi:24@

As i could see, the error comes from database where column "role" is not submitted during insert.
Does anyone knows where this field comes from an why it is null?

Table time_entries has no 'role' column in redmine db, are you using some plugin relative to roles ?

We have installed some earlier before. But we removed it.
Can we manually delete this table column?

Hello,

we have resolved the problem. There were some old tables in the database.

Thanks

SPAM