search

ppy / osu-web

the browser-facing portion of osu!
https://osu.ppy.sh
GNU Affero General Public License v3.0
955 stars 380 forks source link

Malformed BBCode showing UID #11290

Closed cl8n closed 6 days ago

cl8n commented 1 week ago

I don't know what causes this or if it's even possible anymore

examples: https://osu.ppy.sh/community/forums/posts/2128649 https://osu.ppy.sh/community/forums/posts/3177554

anecdotally I was told this can be found on some older userpages too, but I don't have any examples to show.

peppy commented 6 days ago

Thanks, I've applied a fix to these two posts and quite a few others. I don't believe this can be repro'd these days, so we should be good.

osu> update phpbb_posts set `bbcode_uid` = '1337' where post_text like '%:1337]%' and `bbcode_uid` != '1337'
[2024-06-25 20:48:44] 171 rows affected in 3 m 32 s 306 ms