Attachments and Avatars from Vanilla to Flarum

[MrCaspan]

The tool worked great and brought over all my data and I read somewhere else tha tyou have to manually move the userpics and attachments to the assets dir in Flarum.. problem I am having for some reason is it seems that if i right click on an avatar on the site that is not showing it sows that its path is /assets/avatars/userpics/KQ3XW8MUNY0F/6VKJZPSQHKAS.jpeg when I look to see if that file exists i see that all the avatars seem to be prefixed with a p or an n or some other letter.. I am not sure if in Vanilla if this is for a reason that anyone else knows why or a solution. I can just either rename the files or update the database refrence but curious if there is a better way?

[MrCaspan]

It looks like this is an expected behaviour.. it seems that p means full size and n means cropped

Source: https://open.vanillaforums.com/discussion/37997/smf2-import-adventures-redux-the-case-of-the-additional-n-in-avatars

So if this is expected, is there any way for the porter to add the n to the database refrence to it? or even some quick and dirty code as a fix for now?

[MrCaspan]

Hey @linc any chance we can look at this fix also. Very annoying to have to manipulate the database or file system after an import.

It seems the avatar file name value stored in the vanilla database does not have a p or n in the file name. Vanilla's code then adds an n or a p to the beginning of the file name at render time to get the proper sized avatar based on "if its a mobile" "if only a small avatar is required" I have no clue what reasoning but it's there.

n = Smaller Avatar
p = Larger Avatar

IMO I would not give a user an option and just set the p (larger file) as that way there is no loss? The small files are really small. When you add the path to the user table for avatar_url you would just prepend a p before the file name. Happy to discuss more the issue and willing to show you the issue. For now all I do is run a query to update the user table and append p to the beginning of all the file names in the avatar_url column

[linc]

Yeah, it should just add 'p'. I've long known about this issue and thought it was handled; probably got lost in the upgrade to multi-platform support. I'll take a look.

[MrCaspan]

NP I am in the middle of doing a few test runs from V3 to Flarium so I can give you feedback if it worked once you implement it!

[linc]

This was a lot more complex than I guessed it would be, but it all came back to me as I was working on it. 😅 #60

[MrCaspan]

Yeah you are right it does mater if the avatar was imported to Vanilla, we came from VB Bulletin and only the new users have updated or joined since have this!

[linc]

Yeah luckily my Vanilla test database is an import too! Then I went and found the Vanilla source code for processing avatars and it all came rushing back.

[linc]

This fix / improvement is in 3.5.1