I’m working on a plugin that uses the Group flair image. When I perform a SQL query to grab the flair_url from the groups table, it returns NULL for every group despite having an image uploaded. The Discourse data explorer plugin also confirms this (SELECT flair_url from groups) [image] However, the /g.json page does provide a valid flair_url: [image] What’s up with this? is there some quirk about fetching this url that makes it hard to get from a SQL query? I’m still pretty new to Ruby and Rails so I don’t know exactly where I would look in the Discourse source to figure this out. I did notice on line 9 on app/models/group.rb that the flair_url is added to “ignored_columns”, - I’m not sure what the implications of that are, if any. Just wondering if this column appearing NULL is intentional and if so, I would appreciate any tips to get that data from the Ruby back-end of my plugin

I think the data from that column may have been moved at some point. flair_upload_id seems promising: SELECT g.name, g.flair_upload_id, u.url, u.original_filename FROM groups g JOIN uploads u on g.flair_upload_id = u.id

Thanks! This seems like a bit circuitous but it worked! :grin:

Yeah, the flair_url column isn’t used any more - we tell Rails to ignore it in our ruby code: app/models/group.rb 03ffb0bf2 self.ignored_columns = %w{ automatic_membership_retroactive flair_url } Looks like that’s been the case for a while now. @vinothkannans any reason we shouldn’t go ahead and drop it in a post-deploy migration?

האם Flair_url הוא תמיד NULL בשאילתת SQL?

מפתח

vinothkannans (Vinoth Kannan) 21 ביוני,‏ 2022,‏ 12:31pm 5

github.com/discourse/discourse

app/models/group.rb

03ffb0bf2


      
          # TODO(2021-05-26): remove
          self.ignored_columns = %w{

Yes, we should drop it now. We already passed that time long ago.

נושא		תגובות	צפיות
Group flairs don't show Bug	24	2305	10 באוגוסט,‏ 2021
Group Avatar flair image disappeared after update Bug	4	731	9 באוגוסט,‏ 2021
User flair remains after user is removed from group Bug	20	2614	23 בספטמבר,‏ 2021
Recent update removed icon flair from all users Bug	2	697	13 ביולי,‏ 2021
Bug? - Group avatar image not working as expected in newer versions of Discourse Product Support	6	217	19 באוגוסט,‏ 2024

האם Flair_url הוא תמיד NULL בשאילתת SQL?

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