טעינת כרטיס המשתמש נכשלה

sheng_hualuo · 16 במאי,‏ 2025,‏ 7:53am

לאחר עדכון הגרסה, גיליתי שלא ניתן לטעון את כרטיס המשתמש על ידי לחיצה על תמונת הפרופיל של המשתמש, וכשנכנסתי להגדרות המידע האישי, זה הציג הודעה שהדף לא נמצא.

merefield · 16 במאי,‏ 2025,‏ 7:58am

עדכנתי אתמול והכרטיסי משתמש נטענים אצלי כראוי.

בדוק מצב בטוח. אם זה בסדר, ייתכן שיש לך בעיה באחד מהנושאים או רכיבי הנושא שלך?

האם תוכל לספק أي שגיאות קונסולה.

sheng_hualuo · 16 במאי,‏ 2025,‏ 8:06am

אני במצב בטוח ועדיין לא יכול לטעון, הנה פרטי הלוג שלי


נכשל בטיפול בחריגה ב-middlewar של אפליקציית החריגים : ActiveRecord::StatementInvalid : PG::UndefinedTable: שגיאה: הקשר "gamification_leaderboard_cache_1_all_time" לא קיים שורה 1: ...

ActiveRecord::StatementInvalid (PG::UndefinedTable: שגיאה: הקשר "gamification_leaderboard_cache_1_all_time" לא קיים שורה 1: ...```

merefield · 16 במאי,‏ 2025,‏ 8:07am

זה עשוי להיות בעל השפעה, אבל התכוונתי ליומני דפדפן, אתה יכול לשתף אותם?

כלומר את הקונסול של הדפדפן. (שנפתח בדרך כלל על ידי F12)

sheng_hualuo · 16 במאי,‏ 2025,‏ 8:11am

topic-creator-avatar.hbr:1  [THEME 300 '最新主题摘要'] Compile error: unknown file extension 'hbr' (discourse/connectors/topic-list-before-columns/topic-creator-avatar.hbr)
(匿名) @ topic-creator-avatar.hbr:1
[新] 使用 Edge 中的 Copilot 来解释控制台错误: 单击
         
         以说明错误。
        了解更多信息
        不再显示
composer-action-title.js:62 ℹ️ Discourse v3.5.0.beta5-dev — https://github.com/discourse/discourse/commits/7820dd2b8f — Ember v5.12.0
post-placeholder.js:53  [PLUGIN discourse-chain-topics] Deprecation notice: Defining connector classes via registerConnectorClass is deprecated. See https://meta.discourse.org/t/32727 for more modern patterns. [deprecation id: discourse.register-connector-class-legacy]
o @ post-placeholder.js:53
p @ topic-link.js:12
registerConnectorClass @ group.js:15
(匿名) @ topic-custom-field-initializer.js:32
e1 @ group.js:15
initialize @ topic-custom-field-initializer.js:13
(匿名) @ composer-action-title.js:62
(匿名) @ item.js:166
e.each @ form-template-validation.js:54
e.walk @ form-template-validation.js:54
e.each @ form-template-validation.js:54
e.topsort @ form-template-validation.js:54
_runInitializer @ item.js:166
runInstanceInitializers @ item.js:166
_bootSync @ composer-action-title.js:62
didBecomeReady @ index.js:93
invoke @ client-error-handler.js:88
flush @ client-error-handler.js:88
flush @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_ensureInstance @ client-error-handler.js:88
schedule @ client-error-handler.js:88
f @ bookmark.js:114
waitForDOMReady @ index.js:93
init @ index.js:93
_ @ caret-position.js:86
create @ caret-position.js:86
(匿名) @ start-app.js:4
(匿名) @ discourse-boot.js:13
(匿名) @ discourse-boot.js:1
post-placeholder.js:53  [PLUGIN discourse-chain-topics] Deprecation notice: Defining connector classes via registerConnectorClass is deprecated. See https://meta.discourse.org/t/32727 for more modern patterns. [deprecation id: discourse.register-connector-class-legacy]
o @ post-placeholder.js:53
p @ topic-link.js:12
registerConnectorClass @ group.js:15
(匿名) @ topic-custom-field-initializer.js:83
e1 @ group.js:15
initialize @ topic-custom-field-initializer.js:13
(匿名) @ composer-action-title.js:62
(匿名) @ item.js:166
e.each @ form-template-validation.js:54
e.walk @ form-template-validation.js:54
e.each @ form-template-validation.js:54
e.topsort @ form-template-validation.js:54
_runInitializer @ item.js:166
runInstanceInitializers @ item.js:166
_bootSync @ composer-action-title.js:62
didBecomeReady @ index.js:93
invoke @ client-error-handler.js:88
flush @ client-error-handler.js:88
flush @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_ensureInstance @ client-error-handler.js:88
schedule @ client-error-handler.js:88
f @ bookmark.js:114
waitForDOMReady @ index.js:93
init @ index.js:93
_ @ caret-position.js:86
create @ caret-position.js:86
(匿名) @ start-app.js:4
(匿名) @ discourse-boot.js:13
(匿名) @ discourse-boot.js:1
post-placeholder.js:53  [PLUGIN discourse-chain-topics] Deprecation notice: Defining connector classes via registerConnectorClass is deprecated. See https://meta.discourse.org/t/32727 for more modern patterns. [deprecation id: discourse.register-connector-class-legacy]
o @ post-placeholder.js:53
p @ topic-link.js:12
registerConnectorClass @ group.js:15
(匿名) @ topic-custom-field-initializer.js:141
e1 @ group.js:15
initialize @ topic-custom-field-initializer.js:13
(匿名) @ composer-action-title.js:62
(匿名) @ item.js:166
e.each @ form-template-validation.js:54
e.walk @ form-template-validation.js:54
e.each @ form-template-validation.js:54
e.topsort @ form-template-validation.js:54
_runInitializer @ item.js:166
runInstanceInitializers @ item.js:166
_bootSync @ composer-action-title.js:62
didBecomeReady @ index.js:93
invoke @ client-error-handler.js:88
flush @ client-error-handler.js:88
flush @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_ensureInstance @ client-error-handler.js:88
schedule @ client-error-handler.js:88
f @ bookmark.js:114
waitForDOMReady @ index.js:93
init @ index.js:93
_ @ caret-position.js:86
create @ caret-position.js:86
(匿名) @ start-app.js:4
(匿名) @ discourse-boot.js:13
(匿名) @ discourse-boot.js:1
discourse-home-page.js:79  discourse-home-page error: invalid path ""
s @ discourse-home-page.js:79
initialize @ discourse-home-page.js:42
(匿名) @ composer-action-title.js:62
(匿名) @ item.js:166
e.each @ form-template-validation.js:54
e.walk @ form-template-validation.js:54
e.each @ form-template-validation.js:54
e.topsort @ form-template-validation.js:54
_runInitializer @ item.js:166
runInstanceInitializers @ item.js:166
_bootSync @ composer-action-title.js:62
didBecomeReady @ index.js:93
invoke @ client-error-handler.js:88
flush @ client-error-handler.js:88
flush @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_ensureInstance @ client-error-handler.js:88
schedule @ client-error-handler.js:88
f @ bookmark.js:114
waitForDOMReady @ index.js:93
init @ index.js:93
_ @ caret-position.js:86
create @ caret-position.js:86
(匿名) @ start-app.js:4
(匿名) @ discourse-boot.js:13
(匿名) @ discourse-boot.js:1
one-version.js:10  DEPRECATION: Components with separately resolved templates are deprecated. Migrate to either co-located js/ts + hbs files or to gjs/gts. Tried to lookup 'template:components/sidebar-theme-toggle'. [deprecation id: component-template-resolving] This will be removed in ember-source 6.0.0. See https://deprecations.emberjs.com/id/component-template-resolving for more details.
(匿名) @ one-version.js:10
(匿名) @ base.js:71
(匿名) @ deprecate.js:100
(匿名) @ base.js:71
(匿名) @ deprecate.js:100
(匿名) @ base.js:71
l @ index.js:49
(匿名) @ render-tags.js:60
(匿名) @ base.js:71
u @ index.js:49
(匿名) @ base.js:71
(匿名) @ base.js:71
(匿名) @ base.js:71
(匿名) @ bookmark.js:114
(匿名) @ base.js:71
(匿名) @ form-template-validation.js:54
(匿名) @ base.js:71
s @ post-placeholder.js:53
(匿名) @ base.js:71
r @ base.js:71
c @ deprecate.js:100
k @ upload.js:65
h @ binary.js:7
(匿名) @ theme-setting.js:6
(匿名) @ theme-setting.js:6
lookupComponent @ theme-setting.js:6
(匿名) @ theme-setting.js:6
A @ theme-setting.js:6
o @ theme-setting.js:6
(匿名) @ theme-setting.js:6
compile @ theme-setting.js:6
ef @ theme-setting.js:6
(匿名) @ theme-setting.js:6
compile @ theme-setting.js:6
compile @ backup-codes.js:33
(匿名) @ backup-codes.js:33
evaluate @ backup-codes.js:33
evaluateSyscall @ backup-codes.js:33
evaluateInner @ backup-codes.js:33
evaluateOuter @ backup-codes.js:33
next @ backup-codes.js:33
_execute @ backup-codes.js:33
execute @ backup-codes.js:33
sync @ backup-codes.js:33
(匿名) @ theme-setting.js:6
(匿名) @ theme-setting.js:6
tA @ backup-codes.js:33
_renderRoots @ theme-setting.js:6
_renderRootsTransaction @ theme-setting.js:6
_renderRoot @ theme-setting.js:6
_appendDefinition @ theme-setting.js:6
appendOutletView @ theme-setting.js:6
invoke @ client-error-handler.js:88
flush @ client-error-handler.js:88
flush @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_end @ client-error-handler.js:88
(匿名) @ client-error-handler.js:88
Promise.then
(匿名) @ client-error-handler.js:88
flush @ bookmark.js:114
_scheduleAutorun @ client-error-handler.js:88
_ensureInstance @ client-error-handler.js:88
schedule @ client-error-handler.js:88
f @ bookmark.js:114
waitForDOMReady @ index.js:93
init @ index.js:93
_ @ caret-position.js:86
create @ caret-position.js:86
(匿名) @ start-app.js:4
(匿名) @ discourse-boot.js:13
(匿名) @ discourse-boot.js:1
includes.js?v=116e2a6fd81c286e004e2a0afb03baa1:840 
            
            
            GET https://www.tometo.me/u/shen_hualuo/card.json 500 (Internal Server Error)
(匿名) @ includes.js?v=116e2a6fd81c286e004e2a0afb03baa1:840
send @ jquery.js:7408
ajax @ jquery.js:7408
a @ base.js:71
(匿名) @ named-references.js:49
e @ named-references.js:49
A @ base.js:71
(匿名) @ moment.js:257
(匿名) @ group.js:15
(匿名) @ named-references.js:49
e @ named-references.js:49
getAndRemove @ group.js:15
findDetails @ moment.js:257
findByUsername @ moment.js:257
_showCallback @ item.js:166
(匿名) @ topic-link.js:12
invoke @ client-error-handler.js:88
flush @ client-error-handler.js:88
flush @ client-error-handler.js:88
_end @ client-error-handler.js:88
end @ client-error-handler.js:88
_runExpiredTimers @ client-error-handler.js:88
setTimeout
setTimeout @ client-error-handler.js:88
_installTimerTimeout @ client-error-handler.js:88
_reinstallTimerTimeout @ client-error-handler.js:88
_later @ client-error-handler.js:88
later @ client-error-handler.js:88
T @ bookmark.js:114
_show @ topic-link.js:12
_showCardOnClick @ topic-link.js:12
_cardClickHandler @ topic-link.js:12
_run @ client-error-handler.js:88
_join @ client-error-handler.js:88
join @ client-error-handler.js:88
p @ bookmark.js:114
(匿名) @ bookmark.js:114

includes.js?v=116e2a…04e2a0afb03baa1:840 
 
 GET https://www.tometo.me/u/shen_hualuo.json 500 (Internal Server Error)
(匿名)	@	includes.js?v=116e2a…04e2a0afb03baa1:840
send	@	jquery.js:7408
ajax	@	jquery.js:7408
a	@	base.js:71
(匿名)	@	named-references.js:49
e	@	named-references.js:49
A	@	base.js:71
(匿名)	@	moment.js:257
(匿名)	@	group.js:15
(匿名)	@	named-references.js:49
e	@	named-references.js:49
getAndRemove	@	group.js:15
findDetails	@	moment.js:257
afterModel	@	post-placeholder.js:53
runAfterModelHook	@	topic-link.js:12
(匿名)	@	topic-link.js:12
k	@	named-references.js:49
w	@	named-references.js:49
invoke	@	client-error-handler.js:88
flush	@	client-error-handler.js:88
flush	@	client-error-handler.js:88
_end	@	client-error-handler.js:88
(匿名)	@	client-error-handler.js:88
Promise.then		
(匿名)	@	client-error-handler.js:88
flush	@	bookmark.js:114
_scheduleAutorun	@	client-error-handler.js:88
_ensureInstance	@	client-error-handler.js:88
schedule	@	client-error-handler.js:88
(匿名)	@	hashtag-autocomplete.js:158
T	@	named-references.js:49
resolve	@	topic-link.js:12
T	@	form-template-validation.js:54
getTransitionByIntent	@	topic-link.js:12
transitionByIntent	@	topic-link.js:12
doTransition	@	topic-link.js:12
transitionTo	@	topic-link.js:12
_doTransition	@	upload.js:65
transitionTo	@	binary.js:7
(匿名)	@	theme-setting.js:6
l	@	UIPlugin.js:138
click

merefield · 16 במאי,‏ 2025,‏ 8:36am

אז אני לא מאמין שהיית במצב בטוח.

רכיב זה נראה שגורם לבעיה:

topic-creator-avatar.hbr:1  [נושא 300 'תקציר נושאים אחרונים'] שגיאת קומפילציה: סיומת קובץ לא ידועה 'hbr' (discourse/connectors/topic-list-before-columns/topic-creator-avatar.hbr)
(אנונימי) @ topic-creator-avatar.hbr:1

זה מכיוון ש-template חומרים ב-HBR (כלולות גולמיות) אינם נתמכים יותר.

פנה למחבר של התמה הזו.

RGJ · 16 במאי,‏ 2025,‏ 8:36am

[ציטוט=“sheng_hualuo, פוסט:4, נושא:366391”]

board_cache_1_all_time" אינו קיים שורה 1: ...p.t

[/ציטוט]

@nolo האם גם אתה נתקלת בזה פעם?

merefield · 16 במאי,‏ 2025,‏ 8:40am

sheng_hualuo:

Failed to handle exception in exception app middleware : ActiveRecord::StatementInvalid : PG::UndefinedTable: ERROR: relation "gamification_leaderboard_cache_1_all_time" does not exist LINE 1: ...p.t

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "gamification_leaderboard_cache_1_all_time" does not exist LINE 1: ...p.total_score, p.position FROM "users" INNER JOIN gamificati.

So these look related.

Looks like Gamification is modifying the User data and is throwing an error.

So that almost certainly explains why the User Card is not loading.

It looks to me like you have more than one issue and are related to addins, not Core Discourse.

I would remove:

Gamification plugin
Whatever theme component ([THEME 300 ‘最新主题摘要’]) is causing that other browser error (needs to be rewritten to avoid use of .hbr templates)

until you can solve those issues.

Suggest reporting the Gamification error on the Gamification Topic.

JammyDodger · 16 במאי,‏ 2025,‏ 8:52am

As it’s an official plugin you can also report a bug in the Bug category (though remember to add the gamification tag).

merefield · 16 במאי,‏ 2025,‏ 8:56am

זה נכון.

בכל מקרה, נושא זה עוסק כעת בשני נושאים, והם כנראה צריכים להיות מפוצלים לשניים.

הבעיה שהכרטיס משתמש לא נטען כנראה קשורה יותר לנושא הגיימיפיקיישן, ולכן אולי כדאי להשתמש בזה לנושא זה. תווית gamification הוספה.

merefield · 16 במאי,‏ 2025,‏ 8:59am

(בסדר, זה מבלבל את ממשק העריכה של מטה הנושא שונה!)

manuel · 16 במאי,‏ 2025,‏ 9:01am

Yes.

That was when I tried installing a backup. Accessing user-cards and user-pages failed until I deleted the leaderboard from the backup.

edit: on a different note, it seems my screenshot doesn’t open in a lightbox? The upload was 1693px wide, but it only shows in 690.

merefield · 16 במאי,‏ 2025,‏ 9:06am

זה נראה מאוד דקרוני. אני תוהה אם קיימת פתרון קל יותר?

merefield · 16 במאי,‏ 2025,‏ 9:11am

This looks potentially related:

github.com/discourse/discourse-gamification

db/post_migrate/20250210133038_drop_versioned_leaderboard_materialized_views.rb

main

# frozen_string_literal: true

class DropVersionedLeaderboardMaterializedViews < ActiveRecord::Migration[7.2]
  def up
    versioned_mviews_query = <<~SQL
      SELECT cls.relname
      FROM pg_class cls
      INNER JOIN pg_namespace ns ON ns.oid = cls.relnamespace
      WHERE cls.relname ~ 'gamification_leaderboard_cache_[0-9]+_[a-zA-Z_]+_[1-9]$'
        AND cls.relkind = 'm'
        AND ns.nspname = 'public'
    SQL

    mviews = DB.query_single(versioned_mviews_query)

    return if mviews.empty?

    execute <<~SQL
      DROP MATERIALIZED VIEW IF EXISTS #{mviews.join(", ")} CASCADE
    SQL

This file has been truncated. show original

github.com/discourse/discourse-gamification

DEV: Remove explicit leaderboard materialize view versions (#187)

committed 03:44PM - 11 Feb 25 UTC

s3lase

+144 -129

Leaderboard materialized views currently include a version number in their view …names. This versioning mechanism helps with staleness checks and ensures views are updated after changes to the backing query. While effective, it also means the view name changes with each version bump, making it unsuitable for use in badge and Data Explorer queries. Ideally, given the transient nature of these materialized views, they shouldn’t be used in user queries, but we don’t have much control over that. This change removes explicit version numbers and instead adds a `COMMENT` to each view containing a signature of the query at the time it was created. This approach maintains the ability to check for staleness without explicitly versioning materialized views.

RGJ · 16 במאי,‏ 2025,‏ 10:17am

Yes, weird, original here for people who want to actually be able to read it

It might be. This migration deletes versioned cache views that have _x tacked to the end (where x is a digit). But the table that it misses is an unversioned table (without _x).

@sheng_hualuo can you try running this from a rails console?

DiscourseGamification::LeaderboardCachedView.regenerate_all

merefield · 16 במאי,‏ 2025,‏ 10:20am

gamification_leaderboard_cache_1_all_time isn’t 1 the version?

I think for some reason the naming convention was changed.

RGJ · 16 במאי,‏ 2025,‏ 10:22am

לא, זה מזהה לוח ההובלה. הכול מוסבר בהודעת ההתחייבות של ההתחייבות שציינת.

וגם, תסתכל על ה-regex 'gamification_leaderboard_cache_[0-9]+_[a-zA-Z_]+_[1-9]$'

merefield · 16 במאי,‏ 2025,‏ 10:23am

אה, זה מתחיל להסתדר ככה. אז הגרסה בגרסה (אההם) הושלכה, אבל ממניין שהגרסה החדשה (אההם) לא הומשה.

selase · 19 במאי,‏ 2025,‏ 2:44pm

I don’t have the full trace, but I believe the error happens during gamification_score serialization for the user card.

Given the transient nature of these materialized views, a score lookup isn’t expected to cause a system-wide error, it should fall back to a “default score” when the view doesn’t exist.

There’s a bug in the materialized view existence check. It reports that a view exists when it actually doesn’t (at least not in the current public schema), which leads to a lookup on a non-existent view resulting in the error.

I think what happened here was, the materialized view was present in the backup schema created as part of the restore but not the public schema. The backup schema is retained for a while after the restore.

github.com/discourse/discourse-gamification

plugin.rb

213af96ac


      
                  .includes(:flair_upload)
                  .all
                  .map { |group| BasicGroupSerializer.new(group, root: false, scope: self.scope).as_json },
              gamification_leaderboards:
                DiscourseGamification::GamificationLeaderboard.all.map do |leaderboard|
                  LeaderboardSerializer.new(leaderboard, root: false).as_json
                end,
            }
          end
          
          add_to_serializer(:user_card, :gamification_score) { object.gamification_score }
          add_to_serializer(:site, :default_gamification_leaderboard_id) do
            DiscourseGamification::GamificationLeaderboard.first&.id
          end
          
          SeedFu.fixture_paths << Rails
            .root
            .join("plugins", "discourse-gamification", "db", "fixtures")
            .to_s
          
          on(:site_setting_changed) do |name|

github.com/discourse/discourse-gamification

lib/discourse_gamification/user_extension.rb

213af96ac


      
              DEFAULT_SCORE = 0
          
              def gamification_score
                return DEFAULT_SCORE if !default_leaderboard
          
                DiscourseGamification::GamificationLeaderboard.find_position_by(
                  leaderboard_id: default_leaderboard.id,
                  period: "all_time",
                  for_user_id: self.id,
                )&.total_score || DEFAULT_SCORE
              rescue DiscourseGamification::LeaderboardCachedView::NotReadyError
                Jobs.enqueue(Jobs::GenerateLeaderboardPositions, leaderboard_id: default_leaderboard.id)
          
                DEFAULT_SCORE
              end
          
              def default_leaderboard
                @default_leaderboard ||= DiscourseGamification::GamificationLeaderboard.select(:id).first
              end
            end
          end

github.com/discourse/discourse-gamification

lib/discourse_gamification/leaderboard_cached_view.rb

213af96ac


      
          def scores(period: "all_time", page: 0, for_user_id: false, limit: nil, offset: nil)
            user_filter_condition = for_user_id ? ["users.id = ?", for_user_id] : [nil]
          
            if mview_exists?(period)
              User
                .where(*user_filter_condition)
                .joins("INNER JOIN #{mview_name(period)} p ON  p.user_id = users.id")
                .select(
                  "users.id, users.name, users.username, users.uploaded_avatar_id, p.total_score, p.position",
                )
                .limit(limit)
                .offset(offset)
                .order(position: :asc, id: :asc)
                .load
            else
              raise NotReadyError.new(I18n.t("errors.leaderboard_positions_not_ready"))
            end
          end

I’ve got a PR ready with a fix.

github.com/discourse/discourse-gamification

FIX: Scope materialized view existence check to current schema

main ← fix/materialized-view-presence-check

opened 02:16PM - 19 May 25 UTC

s3lase

+21 -1

Currently, `mview_exists?` returns true if the materialized view existed anywher…e in the database, regardless of the schema. This caused issues after backup restores, where the views may exist in the `backup` schema created during the restore but not in the current public schema. This change ensures the check is scoped to the current schema.

נושא		תגובות	צפיות
Usercard Redesign Experiment Feature user-card	129	6870	18 ביולי,‏ 2024
User Card Directory Theme component official , user-card-directory	131	17721	26 בנובמבר,‏ 2025
New user cards and user profile page design deployed Feature	63	8436	3 ביולי,‏ 2015
Since 2.8.0beta2 update some users can't get to preferences (etc) Support	8	663	16 ביולי,‏ 2021
User Card Directory component not working Support user-card-directory	5	59	24 בנובמבר,‏ 2025

טעינת כרטיס המשתמש נכשלה

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