[filter by group] When I filter users by group, the list still shows all users, not the selected group, and this error is shown in the log: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "groups" LINE 1: ..._2' WHERE "directory_items"."period_type" = 4 AND "groups"."... info ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "groups" LINE 1: ..._2' WHERE "directory_items"."period_type" = 4 AND "groups"."... ^ ) app/controllers/directory_items_controller.rb:75:in `index' app/controllers/application_controller.rb:397:in `block in with_resolved_locale' app/controllers/application_controller.rb:397:in `with_resolved_locale' lib/middleware/omniauth_bypass_middleware.rb:71:in `call' lib/content_security_policy/middleware.rb:12:in `call' lib/middleware/anonymous_cache.rb:356:in `call' config/initializers/100-quiet_logger.rb:23:in `call' config/initializers/100-silence_logger.rb:31:in `call' lib/middleware/enforce_hostname.rb:23:in `call' lib/middleware/request_tracker.rb:187:in `call' backtrace rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:72:in `exec_params' rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:72:in `exec_params' activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache' activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads' activesupport (6.1.4.1) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares' activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads' activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:695:in `block in log' activesupport (6.1.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:687:in `log' activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:670:in `exec_no_cache' activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:649:in `execute_and_clear' activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql/database_statements.rb:53:in `exec_query' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:532:in `select' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:69:in `select_all' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `block in select_all' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:118:in `block in cache_sql' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:109:in `cache_sql' activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `select_all' activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:308:in `block in execute_simple_calculation' activerecord (6.1.4.1) lib/active_record/relation.rb:861:in `skip_query_cache_if_necessary' activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:308:in `execute_simple_calculation' activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:269:in `perform_calculation' activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:144:in `calculate' activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:51:in `count' app/controllers/directory_items_controller.rb:75:in `index' plugins/discourse-locations/lib/users_map.rb:23:in `index' actionpack (6.1.4.1) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action' actionpack (6.1.4.1) lib/abstract_controller/base.rb:228:in `process_action' actionpack (6.1.4.1) lib/action_controller/metal/rendering.rb:30:in `process_action' actionpack (6.1.4.1) lib/abstract_controller/callbacks.rb:42:in `block in process_action' activesupport (6.1.4.1) lib/active_support/callbacks.rb:117:in `block in run_callbacks' app/controllers/application_controller.rb:397:in `block in with_resolved_locale' i18n (1.8.10) lib/i18n.rb:314:in `with_locale' app/controllers/application_controller.rb:397:in `with_resolved_locale' activesupport (6.1.4.1) lib/active_support/callbacks.rb:126:in `block in run_callbacks' activesupport (6.1.4.1) lib/active_support/callbacks.rb:137:in `run_callbacks' actionpack (6.1.4.1) lib/abstract_controller/callbacks.rb:41:in `process_action' actionpack (6.1.4.1) lib/action_controller/metal/rescue.rb:22:in `process_action' actionpack (6.1.4.1) lib/action_controller/metal/instrumentation.rb:34:in `block in process_action' activesupport (6.1.4.1) lib/active_support/notifications.rb:203:in `block in instrument' activesupport (6.1.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument' activesupport (6.1.4.1) lib/active_support/notifications.rb:203:in `instrument' actionpack (6.1.4.1) lib/action_controller/metal/instrumentation.rb:33:in `process_action' actionpack (6.1.4.1) lib/action_controller/metal/params_wrapper.rb:249:in `process_action' activerecord (6.1.4.1) lib/active_record/railties/controller_runtime.rb:27:in `process_action' actionpack (6.1.4.1) lib/abstract_controller/base.rb:165:in `process' actionview (6.1.4.1) lib/action_view/rendering.rb:39:in `process' rack-mini-profiler (2.3.3) lib/mini_profiler/profiling_methods.rb:111:in `block in profile_method' actionpack (6.1.4.1) lib/action_controller/metal.rb:190:in `dispatch' actionpack (6.1.4.1) lib/action_controller/metal.rb:254:in `dispatch' actionpack (6.1.4.1) lib/action_dispatch/routing/route_set.rb:50:in `dispatch' actionpack (6.1.4.1) lib/action_dispatch/routing/route_set.rb:33:in `serve' actionpack (6.1.4.1) lib/action_dispatch/journey/router.rb:50:in `block in serve' actionpack (6.1.4.1) lib/action_dispatch/journey/router.rb:32:in `each' actionpack (6.1.4.1) lib/action_dispatch/journey/router.rb:32:in `serve' actionpack (6.1.4.1) lib/action_dispatch/routing/route_set.rb:842:in `call' lib/middleware/omniauth_bypass_middleware.rb:71:in `call' rack (2.2.3) lib/rack/tempfile_reaper.rb:15:in `call' rack (2.2.3) lib/rack/conditional_get.rb:27:in `call' rack (2.2.3) lib/rack/head.rb:12:in `call' actionpack (6.1.4.1) lib/action_dispatch/http/permissions_policy.rb:22:in `call' lib/content_security_policy/middleware.rb:12:in `call' lib/middleware/anonymous_cache.rb:356:in `call' rack (2.2.3) lib/rack/session/abstract/id.rb:266:in `context' rack (2.2.3) lib/rack/session/abstract/id.rb:260:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/cookies.rb:689:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call' activesupport (6.1.4.1) lib/active_support/callbacks.rb:98:in `run_callbacks' actionpack (6.1.4.1) lib/action_dispatch/middleware/callbacks.rb:26:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/actionable_exceptions.rb:18:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/debug_exceptions.rb:29:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/show_exceptions.rb:33:in `call' logster (2.9.7) lib/logster/middleware/reporter.rb:43:in `call' railties (6.1.4.1) lib/rails/rack/logger.rb:37:in `call_app' railties (6.1.4.1) lib/rails/rack/logger.rb:28:in `call' config/initializers/100-quiet_logger.rb:23:in `call' config/initializers/100-silence_logger.rb:31:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/remote_ip.rb:81:in `call' request_store (1.5.0) lib/request_store/middleware.rb:19:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/request_id.rb:26:in `call' lib/middleware/enforce_hostname.rb:23:in `call' rack (2.2.3) lib/rack/method_override.rb:24:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/executor.rb:14:in `call' rack (2.2.3) lib/rack/sendfile.rb:110:in `call' actionpack (6.1.4.1) lib/action_dispatch/middleware/host_authorization.rb:92:in `call' rack-mini-profiler (2.3.3) lib/mini_profiler/profiler.rb:393:in `call' message_bus (3.3.6) lib/message_bus/rack/middleware.rb:61:in `call' lib/middleware/request_tracker.rb:187:in `call' railties (6.1.4.1) lib/rails/engine.rb:539:in `call' railties (6.1.4.1) lib/rails/railtie.rb:207:in `public_send' railties (6.1.4.1) lib/rails/railtie.rb:207:in `method_missing' rack (2.2.3) lib/rack/urlmap.rb:74:in `block in call' rack (2.2.3) lib/rack/urlmap.rb:58:in `each' rack (2.2.3) lib/rack/urlmap.rb:58:in `call' unicorn (6.0.0) lib/unicorn/http_server.rb:634:in `process_client' unicorn (6.0.0) lib/unicorn/http_server.rb:732:i env |hostname|gaoa-discourse-app| |---|---| |process_id|26534| |application_version|a9d6b2380230a0ee497f4fd993b4c42107f1f75e| |HTTP_HOST|forum.**********.com| |REQUEST_URI|/directory_items?period=weekly&order=Aircraft&group=current_members&user_field_ids=2%7C36%7C37| |REQUEST_METHOD|GET| |HTTP_USER_AGENT|Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Safari/537.36| |HTTP_ACCEPT|application/json, text/javascript, */*; q=0.01| |HTTP_REFERER|https://forum.**********.com/u?group=advanced_aero&order=Aircraft| |HTTP_X_FORWARDED_FOR|63.224.250.126| |HTTP_X_REAL_IP|63.224.250.126| |username|omarf| |time|9:41 pm| |params|| |period|weekly| |order|Aircraft| |group|current_members| |user_field_ids|2|36|37| The directory columns contain 4 custom user text fields and /u goes to our Users Map provided by the Locations plugin. This also happens in safe-mode.

Yes, same behavior after rebuilding without Locations: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "groups" LINE 1: ..._2' WHERE "directory_items"."period_type" = 4 AND "groups"."... ^ )

I’ve narrowed it down: When I reset Edit Directory Columns to default, it works as expected, but when I reorder the columns and include my custom user fields, the issue is reproduced. [edit directory columns] [directory-columns]

רישום משתמשים לפי קבוצה - שגיאה: חסר ערך FROM-clause עבור הטבלה "groups"

תמיכה

Falco (Falco) 21 באוקטובר,‏ 2021,‏ 1:45pm 2

Can you reproduce this after rebuilding without the locations plugin?

נושא		תגובות	צפיות
Userlist not working Product Support	9	1354	16 בינואר,‏ 2017
Loading groups gives internal server error Product Support	12	1209	3 באוקטובר,‏ 2021
Invites in user page queries database without checking table emptiness Product Support	3	970	18 בנובמבר,‏ 2017
Failed rebuild (column directory_columns.type does not exist) Self-hosting	1	613	23 ביוני,‏ 2021
Hide admin user from user-directory and top contributors Product Support user-directory	29	912	9 ביוני,‏ 2026

רישום משתמשים לפי קבוצה - שגיאה: חסר ערך FROM-clause עבור הטבלה "groups"

נושאים קשורים