Defect #22819
closed
Internal Error while create new issue
0%
Description
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
Files
Updated by Toshi MARUYAMA over 8 years ago
- Status changed from New to Needs feedback
- Priority changed from Urgent to Normal
Please see Submissions.
Updated by shedow qiu over 8 years ago
we get the same problem from 3.2.0 update to 3.2.2
Updated by shedow qiu over 8 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)):
Updated by Toshi MARUYAMA over 8 years ago
shedow qiu wrote:
we get the same problem from 3.2.0 update to 3.2.2
Do not post unrelated issue.
"issues" table does not have 'position'.
Please ask your using plugin author.
Updated by Leydson Vieira over 8 years ago
Enter in your database and add a default value for the 'position' column.
ALTER TABLE issues MODIFY COLUMN position int(11) NOT NULL DEFAULT '1';for example.
Updated by Toshi MARUYAMA over 8 years ago
- Category deleted (
Administration) - Status changed from Needs feedback to Closed
- Resolution set to No feedback
No feedback from author.
Updated by Nishad Salam over 8 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)):
app/models/issue.rb:211:in `create_or_update'
app/controllers/issues_controller.rb:141:in `create'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
Updated by Toshi MARUYAMA over 8 years ago
Nishad Salam wrote:
I am getting the same error...
Please contact plugin author.
Updated by Inese Ez over 7 years ago
Leydson Vieira wrote:
Enter in your database and add a default value for the 'position' column.
ALTER TABLE issues MODIFY COLUMN position int(11) NOT NULL DEFAULT '1';
for example.
Thankx, this worked!
Updated by Martín Tolava about 4 years 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