Describe the bug
When I go to a component of proposals and I order by "most commented" or "most followed" after filtering by category an error raises.
To Reproduce
Go to a participatory space with a proposals component.
Go to the proposals component.
Filter by category.
Order by "most commented" or "most followed" and see the error.
Expected behavior
It should order without any errors.
Screenshots
Screen.Recording.2023-08-09.at.16.57.36.mov
Stacktrace
ActionView::Template::Error (PG::GroupingError: ERROR: column "decidim_categories.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ... "decidim_proposals_proposals"."state" AS t0_r27, "decidim_c...
^
):
12: </div>
13:
14: <div class="proposal-list__container">
15: <%= render @proposals %>
16: </div>
17:
18: <%= decidim_paginate @proposals %>
rack-mini-profiler (3.1.1) lib/patches/db/pg.rb:72:in `exec_params'
rack-mini-profiler (3.1.1) lib/patches/db/pg.rb:72:in `exec_params'
activerecord (6.1.7.4) lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'
activesupport (6.1.7.4) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
activesupport (6.1.7.4) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport (6.1.7.4) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
activerecord (6.1.7.4) lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract_adapter.rb:695:in `block in log'
activesupport (6.1.7.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract_adapter.rb:687:in `log'
activerecord (6.1.7.4) lib/active_record/connection_adapters/postgresql_adapter.rb:670:in `exec_no_cache'
activerecord (6.1.7.4) lib/active_record/connection_adapters/postgresql_adapter.rb:649:in `execute_and_clear'
activerecord (6.1.7.4) lib/active_record/connection_adapters/postgresql/database_statements.rb:55:in `exec_query'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract/database_statements.rb:532:in `select'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract/database_statements.rb:69:in `select_all'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `block in select_all'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract/query_cache.rb:118:in `block in cache_sql'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (6.1.7.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract/query_cache.rb:109:in `cache_sql'
activerecord (6.1.7.4) lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `select_all'
activerecord (6.1.7.4) lib/active_record/relation.rb:838:in `block (2 levels) in exec_queries'
activerecord (6.1.7.4) lib/active_record/relation/finder_methods.rb:421:in `apply_join_dependency'
activerecord (6.1.7.4) lib/active_record/relation.rb:833:in `block in exec_queries'
activerecord (6.1.7.4) lib/active_record/relation.rb:861:in `skip_query_cache_if_necessary'
activerecord (6.1.7.4) lib/active_record/relation.rb:828:in `exec_queries'
activerecord (6.1.7.4) lib/active_record/relation.rb:631:in `load'
activerecord (6.1.7.4) lib/active_record/relation.rb:249:in `records'
bullet (7.0.7) lib/bullet/active_record61.rb:46:in `records'
activerecord (6.1.7.4) lib/active_record/relation/delegation.rb:88:in `each'
actionview (6.1.7.4) lib/action_view/renderer/collection_renderer.rb:123:in `map'
actionview (6.1.7.4) lib/action_view/renderer/collection_renderer.rb:123:in `render_collection_derive_partial'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:90:in `render_partial_to_object'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:53:in `render_partial'
actionview (6.1.7.4) lib/action_view/helpers/rendering_helper.rb:45:in `render'
decidim-proposals/app/views/decidim/proposals/proposals/_proposals.html.erb:15
actionview (6.1.7.4) lib/action_view/base.rb:247:in `public_send'
actionview (6.1.7.4) lib/action_view/base.rb:247:in `_run'
actionview (6.1.7.4) lib/action_view/template.rb:154:in `block in render'
activesupport (6.1.7.4) lib/active_support/notifications.rb:205:in `instrument'
actionview (6.1.7.4) lib/action_view/template.rb:345:in `instrument_render_template'
actionview (6.1.7.4) lib/action_view/template.rb:152:in `render'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:285:in `block in render_partial_template'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `block in instrument'
activesupport (6.1.7.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `instrument'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:280:in `render_partial_template'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:271:in `render'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:81:in `render_partial_to_object'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:27:in `render_to_object'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:22:in `render'
actionview (6.1.7.4) lib/action_view/helpers/rendering_helper.rb:38:in `block in render'
actionview (6.1.7.4) lib/action_view/base.rb:273:in `in_rendering_context'
actionview (6.1.7.4) lib/action_view/helpers/rendering_helper.rb:34:in `render'
decidim-proposals/app/views/decidim/proposals/proposals/index.html.erb:58
actionview (6.1.7.4) lib/action_view/helpers/capture_helper.rb:45:in `block in capture'
actionview (6.1.7.4) lib/action_view/helpers/capture_helper.rb:209:in `with_output_buffer'
actionview (6.1.7.4) lib/action_view/helpers/capture_helper.rb:45:in `capture'
actionview (6.1.7.4) lib/action_view/helpers/rendering_helper.rb:102:in `_layout_for'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:286:in `block (2 levels) in render_partial_template'
decidim-core/app/views/layouts/decidim/shared/_layout_two_col.html.erb:10
actionview (6.1.7.4) lib/action_view/helpers/capture_helper.rb:45:in `block in capture'
actionview (6.1.7.4) lib/action_view/helpers/capture_helper.rb:209:in `with_output_buffer'
actionview (6.1.7.4) lib/action_view/helpers/capture_helper.rb:45:in `capture'
actionview (6.1.7.4) lib/action_view/helpers/tag_helper.rb:342:in `content_tag'
decidim-core/app/views/layouts/decidim/shared/_layout_two_col.html.erb:8
actionview (6.1.7.4) lib/action_view/base.rb:247:in `public_send'
actionview (6.1.7.4) lib/action_view/base.rb:247:in `_run'
actionview (6.1.7.4) lib/action_view/template.rb:154:in `block in render'
activesupport (6.1.7.4) lib/active_support/notifications.rb:205:in `instrument'
actionview (6.1.7.4) lib/action_view/template.rb:345:in `instrument_render_template'
actionview (6.1.7.4) lib/action_view/template.rb:152:in `render'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:285:in `block in render_partial_template'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `block in instrument'
activesupport (6.1.7.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `instrument'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:280:in `render_partial_template'
actionview (6.1.7.4) lib/action_view/renderer/partial_renderer.rb:271:in `render'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:81:in `render_partial_to_object'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:53:in `render_partial'
actionview (6.1.7.4) lib/action_view/helpers/rendering_helper.rb:36:in `block in render'
actionview (6.1.7.4) lib/action_view/base.rb:273:in `in_rendering_context'
actionview (6.1.7.4) lib/action_view/helpers/rendering_helper.rb:34:in `render'
decidim-proposals/app/views/decidim/proposals/proposals/index.html.erb:30
actionview (6.1.7.4) lib/action_view/base.rb:247:in `public_send'
actionview (6.1.7.4) lib/action_view/base.rb:247:in `_run'
actionview (6.1.7.4) lib/action_view/template.rb:154:in `block in render'
activesupport (6.1.7.4) lib/active_support/notifications.rb:205:in `instrument'
actionview (6.1.7.4) lib/action_view/template.rb:345:in `instrument_render_template'
actionview (6.1.7.4) lib/action_view/template.rb:152:in `render'
actionview (6.1.7.4) lib/action_view/renderer/template_renderer.rb:61:in `block (2 levels) in render_template'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `block in instrument'
activesupport (6.1.7.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `instrument'
actionview (6.1.7.4) lib/action_view/renderer/template_renderer.rb:56:in `block in render_template'
actionview (6.1.7.4) lib/action_view/renderer/template_renderer.rb:71:in `block in render_with_layout'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `block in instrument'
activesupport (6.1.7.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `instrument'
actionview (6.1.7.4) lib/action_view/renderer/template_renderer.rb:70:in `render_with_layout'
actionview (6.1.7.4) lib/action_view/renderer/template_renderer.rb:55:in `render_template'
actionview (6.1.7.4) lib/action_view/renderer/template_renderer.rb:11:in `render'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:61:in `render_template_to_object'
actionview (6.1.7.4) lib/action_view/renderer/renderer.rb:29:in `render_to_object'
actionview (6.1.7.4) lib/action_view/rendering.rb:117:in `block in _render_template'
actionview (6.1.7.4) lib/action_view/base.rb:273:in `in_rendering_context'
actionview (6.1.7.4) lib/action_view/rendering.rb:116:in `_render_template'
actionpack (6.1.7.4) lib/action_controller/metal/streaming.rb:218:in `_render_template'
actionview (6.1.7.4) lib/action_view/rendering.rb:103:in `render_to_body'
actionpack (6.1.7.4) lib/action_controller/metal/rendering.rb:52:in `render_to_body'
actionpack (6.1.7.4) lib/action_controller/metal/renderers.rb:142:in `render_to_body'
actionpack (6.1.7.4) lib/abstract_controller/rendering.rb:25:in `render'
actionpack (6.1.7.4) lib/action_controller/metal/rendering.rb:36:in `render'
actionpack (6.1.7.4) lib/action_controller/metal/instrumentation.rb:46:in `block (2 levels) in render'
.rbenv/versions/3.1.1/lib/ruby/3.1.0/benchmark.rb:311:in `realtime'
activesupport (6.1.7.4) lib/active_support/core_ext/benchmark.rb:14:in `ms'
actionpack (6.1.7.4) lib/action_controller/metal/instrumentation.rb:46:in `block in render'
actionpack (6.1.7.4) lib/action_controller/metal/instrumentation.rb:86:in `cleanup_view_runtime'
activerecord (6.1.7.4) lib/active_record/railties/controller_runtime.rb:34:in `cleanup_view_runtime'
actionpack (6.1.7.4) lib/action_controller/metal/instrumentation.rb:45:in `render'
wicked_pdf (2.6.3) lib/wicked_pdf/pdf_helper.rb:18:in `render'
actionpack (6.1.7.4) lib/action_controller/metal/implicit_render.rb:35:in `default_render'
actionpack (6.1.7.4) lib/action_controller/metal/basic_implicit_render.rb:6:in `block in send_action'
<internal:kernel>:90:in `tap'
actionpack (6.1.7.4) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
actionpack (6.1.7.4) lib/abstract_controller/base.rb:228:in `process_action'
actionpack (6.1.7.4) lib/action_controller/metal/rendering.rb:30:in `process_action'
actionpack (6.1.7.4) lib/abstract_controller/callbacks.rb:42:in `block in process_action'
activesupport (6.1.7.4) lib/active_support/callbacks.rb:117:in `block in run_callbacks'
activesupport (6.1.7.4) lib/active_support/core_ext/time/zones.rb:66:in `use_zone'
decidim-core/app/controllers/concerns/decidim/use_organization_time_zone.rb:21:in `use_organization_time_zone'
activesupport (6.1.7.4) lib/active_support/callbacks.rb:126:in `block in run_callbacks'
i18n (1.14.1) lib/i18n.rb:322:in `with_locale'
decidim-core/app/controllers/concerns/decidim/locale_switcher.rb:24:in `switch_locale'
activesupport (6.1.7.4) lib/active_support/callbacks.rb:126:in `block in run_callbacks'
activesupport (6.1.7.4) lib/active_support/callbacks.rb:137:in `run_callbacks'
actionpack (6.1.7.4) lib/abstract_controller/callbacks.rb:41:in `process_action'
actionpack (6.1.7.4) lib/action_controller/metal/rescue.rb:22:in `process_action'
actionpack (6.1.7.4) lib/action_controller/metal/instrumentation.rb:34:in `block in process_action'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `block in instrument'
activesupport (6.1.7.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (6.1.7.4) lib/active_support/notifications.rb:203:in `instrument'
actionpack (6.1.7.4) lib/action_controller/metal/instrumentation.rb:33:in `process_action'
actionpack (6.1.7.4) lib/action_controller/metal/params_wrapper.rb:249:in `process_action'
activerecord (6.1.7.4) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
actionpack (6.1.7.4) lib/abstract_controller/base.rb:165:in `process'
actionview (6.1.7.4) lib/action_view/rendering.rb:39:in `process'
actionpack (6.1.7.4) lib/action_controller/metal.rb:190:in `dispatch'
actionpack (6.1.7.4) lib/action_controller/metal.rb:254:in `dispatch'
actionpack (6.1.7.4) lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
actionpack (6.1.7.4) lib/action_dispatch/routing/route_set.rb:33:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/routing/route_set.rb:842:in `call'
railties (6.1.7.4) lib/rails/engine.rb:539:in `call'
railties (6.1.7.4) lib/rails/railtie.rb:207:in `public_send'
railties (6.1.7.4) lib/rails/railtie.rb:207:in `method_missing'
actionpack (6.1.7.4) lib/action_dispatch/routing/mapper.rb:20:in `block in <class:Constraints>'
actionpack (6.1.7.4) lib/action_dispatch/routing/mapper.rb:49:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/routing/route_set.rb:842:in `call'
railties (6.1.7.4) lib/rails/engine.rb:539:in `call'
railties (6.1.7.4) lib/rails/railtie.rb:207:in `public_send'
railties (6.1.7.4) lib/rails/railtie.rb:207:in `method_missing'
actionpack (6.1.7.4) lib/action_dispatch/routing/mapper.rb:20:in `block in <class:Constraints>'
actionpack (6.1.7.4) lib/action_dispatch/routing/mapper.rb:49:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/routing/route_set.rb:842:in `call'
railties (6.1.7.4) lib/rails/engine.rb:539:in `call'
railties (6.1.7.4) lib/rails/railtie.rb:207:in `public_send'
railties (6.1.7.4) lib/rails/railtie.rb:207:in `method_missing'
actionpack (6.1.7.4) lib/action_dispatch/routing/mapper.rb:20:in `block in <class:Constraints>'
actionpack (6.1.7.4) lib/action_dispatch/routing/mapper.rb:49:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (6.1.7.4) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (6.1.7.4) lib/action_dispatch/routing/route_set.rb:842:in `call'
batch-loader (1.5.0) lib/batch_loader/middleware.rb:11:in `call'
omniauth (2.1.1) lib/omniauth/strategy.rb:202:in `call!'
omniauth (2.1.1) lib/omniauth/strategy.rb:169:in `call'
omniauth (2.1.1) lib/omniauth/builder.rb:44:in `call'
bullet (7.0.7) lib/bullet/rack.rb:17:in `call'
rack-attack (6.7.0) lib/rack/attack.rb:127:in `call'
warden (1.2.9) lib/warden/manager.rb:36:in `block in call'
warden (1.2.9) lib/warden/manager.rb:34:in `catch'
warden (1.2.9) lib/warden/manager.rb:34:in `call'
decidim-core/lib/decidim/middleware/strip_x_forwarded_host.rb:12:in `call'
decidim-core/lib/decidim/middleware/current_organization.rb:22:in `call'
rack (2.2.7) lib/rack/tempfile_reaper.rb:15:in `call'
rack (2.2.7) lib/rack/etag.rb:27:in `call'
rack (2.2.7) lib/rack/conditional_get.rb:27:in `call'
rack (2.2.7) lib/rack/head.rb:12:in `call'
actionpack (6.1.7.4) lib/action_dispatch/http/permissions_policy.rb:22:in `call'
actionpack (6.1.7.4) lib/action_dispatch/http/content_security_policy.rb:19:in `call'
rack (2.2.7) lib/rack/session/abstract/id.rb:266:in `context'
rack (2.2.7) lib/rack/session/abstract/id.rb:260:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/cookies.rb:697:in `call'
activerecord (6.1.7.4) lib/active_record/migration.rb:601:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
activesupport (6.1.7.4) lib/active_support/callbacks.rb:98:in `run_callbacks'
actionpack (6.1.7.4) lib/action_dispatch/middleware/callbacks.rb:26:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/executor.rb:14:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/actionable_exceptions.rb:18:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/debug_exceptions.rb:29:in `call'
web-console (4.2.0) lib/web_console/middleware.rb:132:in `call_app'
web-console (4.2.0) lib/web_console/middleware.rb:28:in `block in call'
web-console (4.2.0) lib/web_console/middleware.rb:17:in `catch'
web-console (4.2.0) lib/web_console/middleware.rb:17:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'
railties (6.1.7.4) lib/rails/rack/logger.rb:37:in `call_app'
railties (6.1.7.4) lib/rails/rack/logger.rb:26:in `block in call'
activesupport (6.1.7.4) lib/active_support/tagged_logging.rb:99:in `block in tagged'
activesupport (6.1.7.4) lib/active_support/tagged_logging.rb:37:in `tagged'
activesupport (6.1.7.4) lib/active_support/tagged_logging.rb:99:in `tagged'
railties (6.1.7.4) lib/rails/rack/logger.rb:26:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
request_store (1.5.1) lib/request_store/middleware.rb:19:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/request_id.rb:26:in `call'
rack (2.2.7) lib/rack/method_override.rb:24:in `call'
activesupport (6.1.7.4) lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/executor.rb:14:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/static.rb:24:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/static.rb:24:in `call'
rack (2.2.7) lib/rack/sendfile.rb:110:in `call'
actionpack (6.1.7.4) lib/action_dispatch/middleware/host_authorization.rb:148:in `call'
rack-mini-profiler (3.1.1) lib/mini_profiler.rb:413:in `call'
shakapacker (6.6.0) lib/webpacker/dev_server_proxy.rb:25:in `perform_request'
rack-proxy (0.7.6) lib/rack/proxy.rb:87:in `call'
rack-cors (1.1.1) lib/rack/cors.rb:100:in `call'
railties (6.1.7.4) lib/rails/engine.rb:539:in `call'
puma (6.2.2) lib/puma/configuration.rb:270:in `call'
puma (6.2.2) lib/puma/request.rb:98:in `block in handle_request'
puma (6.2.2) lib/puma/thread_pool.rb:340:in `with_force_shutdown'
puma (6.2.2) lib/puma/request.rb:97:in `handle_request'
puma (6.2.2) lib/puma/server.rb:431:in `process_client'
puma (6.2.2) lib/puma/server.rb:233:in `block in run'
puma (6.2.2) lib/puma/thread_pool.rb:147:in `block in spawn_thread'
Extra data
Device: Desktop
Device OS: MacOS 13.4.1
Browser: Firefox
Decidim Version: Reproduced on 0.27.4 and 0.28
Decidim installation: Detected on Decidim Barcelona, reproduced on Metadecidim and a development app
Additional context
Example of this error in Metadecidim: https://meta.decidim.org/processes/roadmap/f/122/proposals?filter[with_any_category][]=647974&order=most_commented
Describe the bug
When I go to a component of proposals and I order by "most commented" or "most followed" after filtering by category an error raises.
To Reproduce
Expected behavior
It should order without any errors.
Screenshots
Screen.Recording.2023-08-09.at.16.57.36.mov
Stacktrace
Extra data
Additional context
Example of this error in Metadecidim: https://meta.decidim.org/processes/roadmap/f/122/proposals?filter[with_any_category][]=647974&order=most_commented