북마크 검색 창에서 ":first" 검색 시 권한 오류 발생

yanz · 11월 5, 2025, 8:06오후

Moin · 11월 5, 2025, 9:31오후

콜론으로 시작하는 단어(예: :test)나 with:images 같은 경우로 재현할 수 있습니다.

브라우저 콘솔에 500 오류가 표시되고 /logs에 항목이 기록됩니다.

Message

ActiveRecord::PreparedStatementInvalid (missing value for :test in: "(REGEXP_REPLACE(TO_TSQUERY('english', ''':test'':*')::text, '<->|<\\d+>', '&', 'g')::tsquery @@ post_search_data.search_data OR bookmarks.name ILIKE :q)")
app/services/registered_bookmarkable.rb:44:in `block in perform_search_query'
app/services/post_bookmarkable.rb:36:in `search_query'
app/services/registered_bookmarkable.rb:43:in `perform_search_query'
lib/bookmark_query.rb:55:in `block in list_all'
lib/bookmark_query.rb:45:in `map'
lib/bookmark_query.rb:45:in `list_all'
app/models/user_bookmark_list.rb:35:in `load'
app/controllers/users_controller.rb:1916:in `block (2 levels) in bookmarks'
app/controllers/users_controller.rb:1905:in `bookmarks'
app/controllers/application_controller.rb:439:in `block in with_resolved_locale'
app/controllers/application_controller.rb:439:in `with_resolved_locale'
app/controllers/application_controller.rb:1072:in `ensure_dont_cache_page'
lib/middleware/omniauth_bypass_middleware.rb:35:in `call'
lib/middleware/crawler_hooks.rb:11:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:415:in `call'
lib/middleware/csp_script_nonce_injector.rb:12:in `call'
config/initializers/008-rack-cors.rb:26:in `call'
lib/middleware/default_headers.rb:13:in `call'
config/initializers/100-quiet_logger.rb:20:in `call'
config/initializers/100-silence_logger.rb:29:in `call'
lib/middleware/enforce_hostname.rb:23:in `call'
lib/middleware/processing_request.rb:12:in `call'
lib/middleware/request_tracker.rb:376:in `call'


Backtrace

activerecord (8.0.4) lib/active_record/relation/query_methods.rb:1698:in `rescue in build_named_bound_sql_literal'
activerecord (8.0.4) lib/active_record/relation/query_methods.rb:1695:in `build_named_bound_sql_literal'
activerecord (8.0.4) lib/active_record/relation/query_methods.rb:1625:in `build_where_clause'
activerecord (8.0.4) lib/active_record/relation/query_methods.rb:1044:in `where!'
activerecord (8.0.4) lib/active_record/relation/query_methods.rb:1039:in `where'
app/services/registered_bookmarkable.rb:44:in `block in perform_search_query'
app/services/post_bookmarkable.rb:36:in `search_query'
app/services/registered_bookmarkable.rb:43:in `perform_search_query'
lib/bookmark_query.rb:55:in `block in list_all'
/usr/local/lib/ruby/3.3.0/set.rb:501:in `each_key'
/usr/local/lib/ruby/3.3.0/set.rb:501:in `each'
lib/bookmark_query.rb:45:in `map'
lib/bookmark_query.rb:45:in `list_all'
app/models/user_bookmark_list.rb:35:in `load'
app/controllers/users_controller.rb:1916:in `block (2 levels) in bookmarks'
actionpack (8.0.4) lib/action_controller/metal/mime_responds.rb:224:in `respond_to'
app/controllers/users_controller.rb:1905:in `bookmarks'
actionpack (8.0.4) lib/action_controller/metal/basic_implicit_render.rb:8:in `send_action'
actionpack (8.0.4) lib/abstract_controller/base.rb:215:in `process_action'
actionpack (8.0.4) lib/action_controller/metal/rendering.rb:193:in `process_action'
actionpack (8.0.4) lib/abstract_controller/callbacks.rb:261:in `block in process_action'
activesupport (8.0.4) lib/active_support/callbacks.rb:120:in `block in run_callbacks'
app/controllers/application_controller.rb:439:in `block in with_resolved_locale'
i18n (1.14.7) lib/i18n.rb:353:in `with_locale'
app/controllers/application_controller.rb:439:in `with_resolved_locale'
activesupport (8.0.4) lib/active_support/callbacks.rb:129:in `block in run_callbacks'
app/controllers/application_controller.rb:1072:in `ensure_dont_cache_page'
activesupport (8.0.4) lib/active_support/callbacks.rb:129:in `block in run_callbacks'
activesupport (8.0.4) lib/active_support/callbacks.rb:140:in `run_callbacks'
actionpack (8.0.4) lib/abstract_controller/callbacks.rb:260:in `process_action'
actionpack (8.0.4) lib/action_controller/metal/rescue.rb:27:in `process_action'
actionpack (8.0.4) lib/action_controller/metal/instrumentation.rb:76:in `block in process_action'
activesupport (8.0.4) lib/active_support/notifications.rb:210:in `block in instrument'
activesupport (8.0.4) lib/active_support/notifications/instrumenter.rb:58:in `instrument'
activesupport (8.0.4) lib/active_support/notifications.rb:210:in `instrument'
actionpack (8.0.4) lib/action_controller/metal/instrumentation.rb:75:in `process_action'
actionpack (8.0.4) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
activerecord (8.0.4) lib/active_record/railties/controller_runtime.rb:39:in `process_action'
actionpack (8.0.4) lib/abstract_controller/base.rb:152:in `process'
actionview (8.0.4) lib/action_view/rendering.rb:40:in `process'
rack-mini-profiler (4.0.1) lib/mini_profiler/profiling_methods.rb:90:in `block in profile_method'
actionpack (8.0.4) lib/action_controller/metal.rb:252:in `dispatch'
actionpack (8.0.4) lib/action_controller/metal.rb:335:in `dispatch'
actionpack (8.0.4) lib/action_dispatch/routing/route_set.rb:67:in `dispatch'
actionpack (8.0.4) lib/action_dispatch/routing/route_set.rb:50:in `serve'
actionpack (8.0.4) lib/action_dispatch/journey/router.rb:53:in `block in serve'
actionpack (8.0.4) lib/action_dispatch/journey/router.rb:133:in `block in find_routes'
actionpack (8.0.4) lib/action_dispatch/journey/router.rb:126:in `each'
actionpack (8.0.4) lib/action_dispatch/journey/router.rb:126:in `find_routes'
actionpack (8.0.4) lib/action_dispatch/journey/router.rb:34:in `serve'
actionpack (8.0.4) lib/action_dispatch/routing/route_set.rb:908:in `call'
lib/middleware/omniauth_bypass_middleware.rb:35:in `call'
lib/middleware/crawler_hooks.rb:11:in `call'
rack (2.2.21) lib/rack/tempfile_reaper.rb:15:in `call'
rack (2.2.21) lib/rack/conditional_get.rb:27:in `call'
rack (2.2.21) lib/rack/head.rb:12:in `call'
actionpack (8.0.4) lib/action_dispatch/http/permissions_policy.rb:38:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:415:in `call'
lib/middleware/csp_script_nonce_injector.rb:12:in `call'
config/initializers/008-rack-cors.rb:26:in `call'
rack (2.2.21) lib/rack/session/abstract/id.rb:266:in `context'
rack (2.2.21) lib/rack/session/abstract/id.rb:260:in `call'
actionpack (8.0.4) lib/action_dispatch/middleware/cookies.rb:706:in `call'
actionpack (8.0.4) lib/action_dispatch/middleware/callbacks.rb:31:in `block in call'
activesupport (8.0.4) lib/active_support/callbacks.rb:100:in `run_callbacks'
actionpack (8.0.4) lib/action_dispatch/middleware/callbacks.rb:30:in `call'
actionpack (8.0.4) lib/action_dispatch/middleware/debug_exceptions.rb:31:in `call'
actionpack (8.0.4) lib/action_dispatch/middleware/show_exceptions.rb:32:in `call'
logster (2.20.1) lib/logster/middleware/reporter.rb:40:in `call'
lib/middleware/default_headers.rb:13:in `call'
lograge (0.14.0) lib/lograge/rails_ext/rack/logger.rb:18:in `call_app'
railties (8.0.4) lib/rails/rack/logger.rb:29:in `call'
config/initializers/100-quiet_logger.rb:20:in `call'
config/initializers/100-silence_logger.rb:29:in `call'
actionpack (8.0.4) lib/action_dispatch/middleware/request_id.rb:34:in `call'
lib/middleware/enforce_hostname.rb:23:in `call'
rack (2.2.21) lib/rack/method_override.rb:24:in `call'
rack (2.2.21) lib/rack/sendfile.rb:127:in `call'
plugins/discourse-prometheus/lib/middleware/metrics.rb:14:in `call'
rack-mini-profiler (4.0.1) lib/mini_profiler.rb:191:in `call'
lib/middleware/processing_request.rb:12:in `call'
message_bus (4.4.1) lib/message_bus/rack/middleware.rb:60:in `call'
lib/middleware/request_tracker.rb:376:in `call'
actionpack (8.0.4) lib/action_dispatch/middleware/remote_ip.rb:96:in `call'
rails_failover (2.3.0) lib/rails_failover/active_record/middleware.rb:67:in `block in call'
activerecord (8.0.4) lib/active_record/connection_handling.rb:401:in `with_role_and_shard'
activerecord (8.0.4) lib/active_record/connection_handling.rb:149:in `connected_to'
rails_failover (2.3.0) lib/rails_failover/active_record/middleware.rb:64:in `call'
rails_multisite (7.0.0) lib/rails_multisite/middleware.rb:26:in `call'
railties (8.0.4) lib/rails/engine.rb:535:in `call'
railties (8.0.4) lib/rails/railtie.rb:226:in `public_send'
railties (8.0.4) lib/rails/railtie.rb:226:in `method_missing'
rack (2.2.21) lib/rack/urlmap.rb:74:in `block in call'
rack (2.2.21) lib/rack/urlmap.rb:58:in `each'
rack (2.2.21) lib/rack/urlmap.rb:58:in `call'
unicorn (6.1.0) lib/unicorn/http_server.rb:634:in `process_client'
unicorn (6.1.0) lib/unicorn/http_server.rb:739:in `worker_loop'
unicorn (6.1.0) lib/unicorn/http_server.rb:547:in `spawn_missing_workers'
unicorn (6.1.0) lib/unicorn/http_server.rb:143:in `start'
unicorn (6.1.0) bin/unicorn:128:in `<top (required)>'
vendor/bundle/ruby/3.3.0/bin/unicorn:25:in `load'
vendor/bundle/ruby/3.3.0/bin/unicorn:25:in `<main>'

sam · 11월 5, 2025, 9:40오후

해결하겠습니다. 보고해 주셔서 감사합니다.

sam · 11월 5, 2025, 9:50오후

다음 링크에 따라 수정했습니다:

하지만 오퍼레이터를 실제로 지원하는 것이 보완적인 기능 요청이라고 생각하는데, 이는 훨씬 더 어려울 것입니다.

Moin · 11월 5, 2025, 10:13오후

저는 그 기능이 필요하지 않다고 생각합니다. in:bookmarks와 같은 다른 운영자를 사용하여 일반적인 검색을 사용할 수 있습니다.

tobiaseigen · 11월 15, 2025, 4:00오후

이 주제는 5일 후 자동으로 닫혔습니다. 더 이상 새 답변을 작성할 수 없습니다.

글		댓글	조회수
No results for bookmarks search - confusing message Bug	2	588	11월 19, 2020
Search within topic is omitting results Bug	21	5184	6월 2, 2017
Can't erase the bookmark search input Bug bookmarks	8	344	3월 22, 2025
Search returns error 500 Support	3	441	3월 19, 2019
Search for wb.camra.org.uk doesn't return any results Bug	16	1669	8월 14, 2017

북마크 검색 창에서 ":first" 검색 시 권한 오류 발생

Related topics