Internal Error while create new issue
|Resolution:||No feedback||Affected version:|
While I am going to create, delete or edit any issue, it will give internal error. Recently I changed fields permission from administration. I have tried again after reset those changes but still it is not working.
I give lots of time to configure redmine and its admin. Please advise what should be error.
Affected Version: 3.2.1
#3 Updated by shedow qiu over 5 years ago
ActiveRecord::StatementInvalid (Mysql2::Error: Field 'position' doesn't have a default value: INSERT INTO `issues` (`project_id`, `author_id`, `start_date`, `tracker_id`, `st
atus_id`, `subject`, `description`, `priority_id`, `updated_on`, `created_on`, `lock_version`) VALUES (34, 6, '2016-05-17', 1, 1, 'test3', '', 2, '2016-05-17 19:32:28', '2016
-05-17 19:32:28', 0)):
#7 Updated by Nishad Salam over 5 years ago
I am getting the same error and I have applied above SQL statement, and now you I have got the new error. I am using redmine 3.3 and I have recently upgraded from redmiine-1.3 to 3.3. I had redminebacklogs earlier but I have already installed the backlogs.
ActiveRecord::RecordNotUnique (Mysql2::Error: Duplicate entry '1-0' for key 'index_issues_on_position_and_position_lock': INSERT INTO `issues` (`project_id`, `author_id`, `start_date`, `tracker_id`, `status_id`, `subject`, `description`, `priority_id`, `updated_on`, `created_on`, `lock_version`) VALUES (249, 61, '2016-08-14', 1, 1, 'test', 'test', 4, '2016-08-14 13:16:23', '2016-08-14 13:16:23', 0)):
#10 Updated by Martín Tolava about 1 year ago
Hi, Im working with version 3.0.2 with Rails 4.2.1. and resolve this problem, but I have a new problem when delete an Issue.
In log I can see this error
ActiveRecord::StatementInvalid (Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails (`redmine_production`.`redhopper_issues`, CONSTRAINT `fk_rails_d346a13856` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`id`)): DELETE FROM `issues` WHERE `issues`.`id` = 33853 AND `issues`.`lock_version` = 0):
someone has a solution