Actions
Defect #30284
closedInternal Server Error When Deleting a User
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Affected version:
Description
When deleting a user an Internal Server Error is generated, and the user account does not get deleted.
Error from log:
Started DELETE "/users/341" for x.x.x.x at 2018-12-27 08:41:07 -0500 Processing by UsersController#destroy as HTML Parameters: {"authenticity_token"=>"", "id"=>"341"} Current user: (id=3) Completed 500 Internal Server Error in 302ms (ActiveRecord: 284.1ms) ActiveRecord::StatementInvalid ( TinyTds::Error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.: EXEC sp_executesql N'DELETE FROM [custom_values] WHERE [custom_values].[id] IN (SELECT [custom_values].[id] FROM [custom_values] LEFT OUTER JOIN [custom_fields] ON [custom_fields].[id] = [custom_values].[custom_field_id] WHERE [custom_values].[customized_id] = @0 AND [custom_values].[customized_type] = @1 ORDER BY custom_fields.position); SELECT @@ROWCOUNT AS AffectedRows', N'@0 int, @1 nvarchar(30)', @0 = 341, @1 = N'Principal'):
Environment: Redmine version 4.0.0.devel Ruby version 2.5.3-p105 (2018-10-18) [x64-mingw32] Rails version 5.2.2 Environment production Database adapter SQLServer Database version SQL Server 2012 Mailer queue ActiveJob::QueueAdapters::AsyncAdapter Mailer delivery smtp SCM: Git 2.20.0 Filesystem Redmine plugins: redmine_agile 1.4.7
Related issues
Actions