photos with chinese characters don't upload as Main Image

[ebarry]

An image file with non-latin characters in the name uploaded as lead image on a research note failed to display. The note posts successfully, but the lead image is broken.

You could reproduce this issue by

• saving this image and renaming it with its original name 图片17.jpg
• posting a research note at publiclab.org/post with that as the lead image. NB: Posting requires a user account and being logged in, please create a user account at publiclab.org/signup.

What happened just before the problem occurred

Relevant URLs

https://publiclab.org/notes/Shizi/05-27-2016/kite-aerial-photography-in-china

PublicLab.org username

(to help reproduce the issue)

Browser, version, and operating system

For bug reports, fill out the above template; for feature requests, you can delete the template.

To learn how to write really great issues, which increases the chances they'll be resolved, see:

https://publiclab.org/wiki/developers#Contributing+for+non-coders

[jywarren]

Can you post the original name of the image, since it's since been replaced on the linked-to research note? Image uploading uses the paperclip gem, and the first step is probably to figure out whether the image:

1. uploaded but does not display, or
2. failed on upload and never got to display.

I think 1 is probably right, as I saw a "broken" image displayed when this note first published.

[ananyo2012]

Yes the image is being uploaded but the name is displayed incorrectly as you can see in this test research note https://publiclab.org/notes/ananyo2012/08-19-2016/testing-out-a-note-within-chinese-characters-in-main-image. This is weird as the same image shows up when you upload it in the body.

[ananyo2012]

This is the ASCII format of the image name: %E5%9B%BE%E7%89%8717.jpg. if you paste this name beside the image path i.e. https://i.publiclab.org/system/images/photos/000/017/679/original/%E5%9B%BE%E7%89%8717.jpg you will be able to see the uploaded image. But somehow the name is displayed incorrectly in the note. The name of the image is fetched by @node.main_image.path(:original) as you can see in this line: https://github.com/publiclab/plots2/blob/master/app/views/notes/show.html.erb#L7

[ebarry]

Hi all, just bumping this issue up as image upload -- if the title has non-latin characters -- to the Main Image, as well as Drag-n-Drop into the Body of a research note, is failing:

[jywarren]

I've created two tests -- a functional test and a test fixture -- which should fail, reproducing this error:

#4118

If this PR fails, we would love help resolving it. It might involve database encoding, as in #2665

[jywarren]

I could use some help reproducing this error in a test! I haven't been able to, although it definitely happens on production. Any ideas?