Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-10714

adding splitting new emoji alias gives ISE on beta

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      tried adding 🪗 (https://emojipedia.org/accordion/) to our accordion instrument and it failed spectacularly:

      Internal server error on https://beta.musicbrainz.org/instrument/bdf08ac2-b9c2-4391-85e5-9a7716bdd690/add-alias
      Referrer: https://beta.musicbrainz.org/instrument/bdf08ac2-b9c2-4391-85e5-9a7716bdd690/add-alias

      Internal Server Error
      
      Oops, something went wrong!
      
      Error:
      
      Caught exception in MusicBrainz::Server::Controller::Instrument->add_alias "The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): 23514 DBD::Pg::st execute failed: ERROR:  new row for relation "instrument_alias" violates check constraint "only_non_empty"
      DETAIL:  Failing row contains (8945, 41, , null, 0, 2020-03-21 19:12:50.283341+00, null, , null, null, null, null, null, null, f, f). [for Statement "INSERT INTO instrument_alias (primary_for_locale,end_date_month,begin_date_day,type,end_date_year,ended,begin_date_month,end_date_day,sort_name,instrument,locale,begin_date_year,name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) RETURNING id" with ParamValues: 1='0', 2=undef, 3=undef, 4=undef, 5=undef, 6='0', 7=undef, 8=undef, 9='', 10='41', 11=undef, 12=undef, 13=''] at lib/MusicBrainz/Server/Controller.pm line 107.
       at lib/Sql.pm line 335."
      
      Stack trace:
      
          line
          line
      
      Time: 2020-03-21 19:12:50 UTC
      
      Host: a2b8208f0892
      
      Interface language: en
      
      URL: https://beta.musicbrainz.org/instrument/bdf08ac2-b9c2-4391-85e5-9a7716bdd690/add-alias
      
      Request data:
      
      $VAR1 = {
                'query_parameters' => {},
                'body_parameters' => {
                                       'edit-alias.period.begin_date.year' => '',
                                       'edit-alias.locale' => "\x{a0}",
                                       'edit-alias.period.end_date.year' => '',
                                       'edit-alias.type_id' => "\x{a0}",
                                       'edit-alias.period.end_date.month' => '',
                                       'edit-alias.period.begin_date.day' => '',
                                       'edit-alias.name' => "\x{1fa97}",
                                       'edit-alias.sort_name' => "\x{1fa97}",
                                       'edit-alias.period.begin_date.month' => '',
                                       'edit-alias.edit_note' => '',
                                       'edit-alias.period.end_date.day' => ''
                                     }
              };
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              zaphodbeeblebrox CatQuest, the Endeavouring Cat!
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package