Defect #22819

Internal Error while create new issue

Added by saurabh Savaliya over 1 year ago. Updated 3 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution:No feedback Affected version:

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

Snap 2016-05-14 at 20.03.21.png (50 KB) saurabh Savaliya, 2016-05-14 16:40

Error.png (42.3 KB) saurabh Savaliya, 2016-05-14 16:40

History

#1 Updated by Toshi MARUYAMA over 1 year ago

  • Status changed from New to Needs feedback
  • Priority changed from Urgent to Normal

Please see Submissions.

#2 Updated by shedow qiu over 1 year ago

we get the same problem from 3.2.0 update to 3.2.2

#3 Updated by shedow qiu over 1 year 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)):

#4 Updated by Toshi MARUYAMA over 1 year 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.

#5 Updated by Leydson Vieira over 1 year 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.

#6 Updated by Toshi MARUYAMA over 1 year ago

  • Category deleted (Administration)
  • Status changed from Needs feedback to Closed
  • Resolution set to No feedback

No feedback from author.

#7 Updated by Nishad Salam about 1 year 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'

#8 Updated by Toshi MARUYAMA about 1 year ago

Nishad Salam wrote:

I am getting the same error...

Please contact plugin author.

#9 Updated by Inese Ez 3 months 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!

Also available in: Atom PDF