-
Bug
-
Resolution: Fixed
-
High
-
None
-
None
beta.musicbrainz.org ISE's when trying to create recording with the name 🤷 (shrug emoji)
This is replicatable: go https://beta.musicbrainz.org/recording/create?edit-recording.name=%F0%9F%A4%B7 and attempt to create this with any artist.
error given below:
Error: Caught exception in MusicBrainz::Server::Controller::Recording->create "The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): 23514 DBD::Pg::st execute failed: ERROR: new row for relation "recording" violates check constraint "only_non_empty" DETAIL: Failing row contains (22756618, 6bac52c7-e93e-449d-b867-89a1faa66a2f, , 514841, null, , 0, 2018-05-29 15:20:07.029602+00, f). [for Statement "INSERT INTO recording (artist_credit,name,gid,length,comment,video) VALUES (?,?,?,?,?,?) RETURNING id" with ParamValues: 1='514841', 2='', 3='6bac52c7-e93e-449d-b867-89a1faa66a2f', 4=undef, 5='', 6='0'] at lib/MusicBrainz/Server/Controller.pm line 106. at lib/Sql.pm line 334." Stack trace: line line Time: 2018-05-29 15:20:07 UTC Host: b32dea456077 Interface language: en URL: https://beta.musicbrainz.org/recording/create?edit-recording.name=%F0%9F%A4%B7 Request data: $VAR1 = { 'query_parameters' => { 'edit-recording.name' => "\x{1f937}" }, 'body_parameters' => { 'edit-recording.isrcs.0' => '', 'edit-recording.artist_credit.names.0.artist.id' => '514841', 'edit-recording.artist_credit.names.0.artist.name' => 'Naz a.k.a. Naz', 'edit-recording.name' => "\x{1f937}", 'edit-recording.length' => '', 'edit-recording.comment' => '', 'edit-recording.edit_note' => "\x{1f937}\x{1f937}\x{1f937}\x{1f937}\x{1f937}", 'edit-recording.artist_credit.names.0.name' => 'Naz a.k.a. Naz', 'edit-recording.artist_credit.names.0.join_phrase' => '' } };
Was testing things on test.mb.org with reosarevok and sambav, there even a search is unhappy, but when trying to create an entity it also ISE'd.
Also an inline artist creation with 🤷 as name also ISE'd. I thought that creation failing was odd, so I tried it on beta, here it also ISEs.
I have not tried: Artist, release, place, label
I have tried Series(ISE), Instrument(ISE)
There is therefore cause to believe that the other entities will also ISEs, and that other emoji will create problem.
- has related issue
-
MBS-10976 Unicode Private Use Area characters are stripped during edit process
- Closed