Problem with Custom Fields...
Added by Rene Kolbe over 7 years ago
Hello good People,
now i've the next problem and i hope somebody can help me:
Started GET "/custom_fields/32/edit" for 10.20.1.35 at 2017-06-30 13:32:56 +0200 Processing by CustomFieldsController#edit as HTML Parameters: {"id"=>"32"} Current user: xx.xxx (id=1080) Rendered custom_fields/formats/_list.html.erb (15.6ms) TinyTds::Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.: EXEC sp_executesql N'SELECT [roles].* FROM [roles] WHERE [roles].[builtin] = @0 ORDER BY roles.position ASC, roles.builtin ASC, roles.position ASC', N'@0 int', @0 = 0 Rendered custom_fields/_form.html.erb (203.1ms) Rendered custom_fields/edit.html.erb within layouts/admin (203.1ms) Completed 500 Internal Server Error in 219ms (ActiveRecord: 0.0ms) ActionView::Template::Error (TinyTds::Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.: EXEC sp_executesql N'SELECT [roles].* FROM [roles] WHERE [roles].[builtin] = @0 ORDER BY roles.position ASC, roles.builtin ASC, roles.position ASC', N'@0 int', @0 = 0): 44: :data => {:enables => '.custom_field_role input'} %> 45: <%= l(:label_visibility_roles) %>: 46: </label> 47: <% Role.givable.sorted.each do |role| %> 48: <label class="block custom_field_role" style="padding-left:2em;"> 49: <%= check_box_tag 'custom_field[role_ids][]', role.id, @custom_field.roles.include?(role), :id => nil %> 50: <%= role.name %> app/views/custom_fields/_form.html.erb:47:in `_app_views_custom_fields__form_html_erb___901772835_59902284' app/views/custom_fields/edit.html.erb:6:in `block in _app_views_custom_fields_edit_html_erb__233822614_60504744' app/helpers/application_helper.rb:1026:in `labelled_form_for' app/views/custom_fields/edit.html.erb:5:in `_app_views_custom_fields_edit_html_erb__233822614_60504744'
My Config is:
Redmine version 3.0.4.stable
Ruby version 2.2.6-p396 (2016-11-15) [i386-mingw32]
Rails version 4.2.3
Environment production
Database adapter SQLServer
Please help me to find a solution - but i'm not a RoR Developer!
Best Regards
René
Update 2017-07-04: Nobody can help me??