718097 - Uploading image to gallery with specific title can prevent other users from ever uploading again

Status: RESOLVED FIXED

(support.mozilla.org :: Knowledge Base Software, task)

Description

[Tanay Gavankar [:tgavankar]]

If you go to gallery and upload an image and title it "Draft for user tgavankar" where you change tgavankar to any nickname, the ajax upload no longer works for the gallery page for the user who's username you put there (until that uploaded/saved image is deleted). The upload causes a MySQL error: IntegrityError: (1062, "Duplicate entry 'en-US-Draft for user tgavankar' for key 'gallery_image_locale_title'").

This can also happen by accident and affect a single user because if the user leaves after selecting an image (ajax upload goes through) but never hits save on the popup dialogue, when they return to the upload box, it is autopopulated with the autosaved draft text (that causes this bug).

STR:
1. Log in as User1
2. Go to en-US/gallery
3. Click upload new media link.
4. Add some image and set the title to "Draft for user User2", description to "Autosaved draft"
5. Save image.
6. Log in as User2 and notice that you are unable to upload images from the gallery upload page.

Comment 1

[James Socol [:jsocol, :james]]

The current draft system for uploaded images is... not great. It was an expedient solution to the problem at the time. I think it's worth investing in fixing it properly.

Comment 2

[James Socol [:jsocol, :james]]

Can we verify that this still happens?

Comment 3

[Mark Goodwin [:mgoodwin]]

(In reply to James Socol [:jsocol, :james] from comment #2)
> Can we verify that this still happens?

Apparently this is now fixed.

Comment 4

[Will Kahn-Greene [:willkg] ET needinfo? me]

These bugs are all resolved, so I'm removing the security flag from them.