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

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?

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.

Flair_url is always NULL in SQL query?

Development

piffy June 21, 2022, 8:06am 3

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

Topic		Replies	Views
Group flairs don't show Bug	24	2294	August 10, 2021
Group Avatar flair image disappeared after update Bug	4	729	August 9, 2021
User flair remains after user is removed from group Bug	20	2613	September 23, 2021
Recent update removed icon flair from all users Bug	2	697	July 13, 2021
Bug? - Group avatar image not working as expected in newer versions of Discourse Product Support	6	216	August 19, 2024

Flair_url is always NULL in SQL query?

Related topics