Hello, Sorry for being new here. I’m a former phpbb3 forum owner and I decided to import phpbb3 to discourse. The importer ran successfully. I even found a bug and it was fixed by our forum user, PR#5133 sent. I did enable all 3 options about avatars in settings.yml After the import, I immediately launch sidekiq, puma and nginx to preview my new forum. And I noticed the avatars of my forum users imported are still lettered. I thought I should see their old avatars from the old forum. :sob: :sob: As the importer produced nothing wrong, I am confused. Does it act like that because my sidekiq jobs are not finished? Or there’s anything deeper? I ran avatars:refresh and avatars:clean but no luck Thanks for any hint! :heart_eyes: :heart_eyes: Marguerite

Changed ‘bicubic’ to ‘catrom’, it worked. So I patched app/models/optimized_image.rb, and now everything works. Thank you guys :wink:

It’s not sidekiq. My guess is that you didn’t get the importer configured correctly to find them.

@pfaffman Thanks for your help! avatars: uploaded: true gallery: true remote: true I got optipng, jhead, gifsicle and svgo installed correctly and can be found by discourse. no error messages got, just the percentage in the log (I ran the importer with nohup so I can have any output saved) And user avatars were copied, because I monkey patched the lib/cooked_post_processor.rb to show image’s absolute URL. and I saw user uploaded images in the posts were copied successfully from php_base_dir, so I best guess the avatars were also there in public/uploads. but I just could not see them applied. :sob: :sob:

BTW, attachments were imported and can be seen on the new forum. we have a forum magazine/summary produced in .pdf format. I can see its latest release on the new forum. So I guess php_base_dir was set up right.

can anyone see if it’s caused by this plugin: https://github.com/openSUSE-zh/discourse-username-localization in its plugin.rb, I saw this: User.class_eval do def self.system_avatar_template(username) # TODO it may be worth caching this in a distributed cache, should be benched if SiteSetting.external_system_avatars_enabled url = SiteSetting.external_system_avatars_url.dup url.gsub! "{color}", letter_avatar_color(username.downcase) url.gsub! "{username}", username if username[0] =~ /[^\w]/ url.gsub! "{first_letter}", (Pinyin.t(Romaji.kana2romaji(username)).strip.to_s[0] || '_').downcase else url.gsub! "{first_letter}", username[0].downcase end url else "#{Discourse.base_uri}/letter_avatar/#{username.downcase}/{size}/#{LetterAvatar.version}.png" end end end Does these codes override system functions and force usage of letter avatars? Thanks.

Yes, I’m quite sure that this plugin is causing the problem. Why don’t you try without it…

@gerhard Hero! you save my life! My forum is the semi-official forum for Chinese users of openSUSE Linux. So it has lots of CJK usernames…this is the plugin commonly applied on discourse forums targeting on Chinese users. I didn’t even think of such massive used plugin can be buggy like this…maybe their usages were: import apply plugin. Mine was: apply plugin import Thanks, I’ll try to fix that plugin

@gerhard @pfaffman Sorry, guys. It wasn’t caused by the importer script nor the username-localization plugin. I uninstalled the plugin, dropped the database, and started over again. so the plugin problem can be avoided. After the import, I used pgweb to visit the database directly, and saw: 2.1 the user_avatar table has custom_upload_id field set. 2.1 the uploads table has my previous avatars and I can visit the uploaded avatar, eg: /uploads/default/original/1X/998dc371f7b0e6d21cbae0116072308e5e9e2dcd.png it showed up. But I can’t see it activated in posts, eg: [no_avatar_in_post] and the avatar in my profile is the default one too. and the image url points to: http://my_site/user_avatar/my_site/marguerite/120/2_1.png which is also the default one. Thanks for any help Marguerite

@gerhard @darix Hi, After some debugging, I am afraid this is a bug. Here’s how I did it. The previous username localization plugin only overrides system_avatar_template, which is called by default_template, while default_template is called only when uploaded_avatar_id is not present. I added some Rails logger and I can see uploaded_avatar_id printed. If uploaded_avatar_id is present, it uses local_avatar_template, which is called by one function only: local_avatar_url. After some grep, I found this: app/controllers/user_avatar_controller.rb In its private part, there’s a ‘show_in_site’ function: upload = Upload.find_by(id: upload_id) if user_avatar.contains_upload?(upload_id) upload ||= user.uploaded_avatar if user.uploaded_avatar_id == upload_id # mycode starts here: # debug.txt is discourse:discourse owned. open('/srv/www/vhosts/discourse/debug.txt', 'a+:UTF-8') do |f| f.write "user: #{username.downcase}," + "upload_id: #{upload_id}," + "upload: #{upload.url}, " + "contains: #{user_avatar.contains_upload?(upload_id)}, " + "uploaded_avatar_id: #{uploaded_avatar_id}," + "optimized: '#{get_optimized_image(upload, size)}'" + "\n" end # result => "marguerite, 36, xxx.png, true, 36, ''" # mycode end: if user.uploaded_avatar && !upload elsif upload && optimized = get_optimized_image(upload, size) # should goes here, but not image # there should an else with some logger error here, but no. end if image else # image is nil, so goes here render_blank end so, I found upload exists, but optimized not exist. so render_blank (I think this is to use the default avatar). I checked optimized_image table, it only contains a few (less than 10 compared to 4000+ users) optimized image. So, this is the problem: the importer script or discourse failed to create optimized image, but didn’t report anything. Marguerite

$ rails.ruby2.4 c User.all.map { |u| Jobs::CreateAvatarThumbnails.perform_async(upload_id: u.uploaded_avatar_id, user_id: u.id) if u.uploaded_avatar_id } You should see something like: [nil, "113db0ddae05b442464e73b6", "e7e4393a52970cb2cb3ebb57", "40886d7b9e5780119ac388f8", "320bcbbcbdf9c0feb791497c", "493e2c6ccf2b1fcf7ca15cc2"]

I ran it, and got outputs like that. Does this add actions to sidekiq or run immediately? Because I didn’t notice any change on the forum yet

Letter avatars still displayed after importing phpbb3 avatars

Product Support Migration

zogstrip (Régis HANOL) September 27, 2017, 2:58pm 18

Sure. Do you have an easy way to know what interpolation modes are available?

Topic		Replies	Views
Avatars not showing after import Development	1	1058	February 9, 2018
phpBB to Discourse, Avatars are not displaying Product Support	7	1709	November 24, 2017
Avatars missing after import Migration	5	1106	February 27, 2020
"Failed to optimize image" error from discourse-topic-previews-sidecar Product Support	7	276	July 30, 2026
Problems with avatar uploads due to S3 changes Product Support	21	4009	October 17, 2018

Letter avatars still displayed after importing phpbb3 avatars

Related topics