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

ISE when changing from reltype with dates to reltype without them

      When trying to change "original member" to "founder" for https://beta.musicbrainz.org/artist/3d4c9a99-24d7-4a73-8993-33cb83280bad/edit I get:

      Error:

      Caught exception in MusicBrainz::Server::Controller::Artist->edit "The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): P0001 DBD::Pg::st execute failed: ERROR: Attempt to add dates to a relationship type that does not support dates. [for Statement "INSERT INTO link (ended,end_date_year,begin_date_month,attribute_count,begin_date_year,end_date_month,link_type,begin_date_day,end_date_day) VALUES (?,?,?,?,?,?,?,?,?) RETURNING id" with ParamValues: 1='0', 2=undef, 3=undef, 4='0', 5='1985', 6=undef, 7='895', 8=undef, 9=undef] at lib/MusicBrainz/Server/Controller.pm line 103.
      at lib/Sql.pm line 334.
      at lib/Sql.pm line 334."
      Stack trace:
      line 19 MusicBrainz::Server::Model::MB
      line 202 MusicBrainz::Server::Controller
      line 132 MusicBrainz::Server::Controller::Role::EditRelationships
      line 49 MusicBrainz::Server::Controller::Role::Edit
      line 584 MusicBrainz::Server::Controller::Artist
      line 346 MusicBrainz::Server
      line 320 MusicBrainz::Server
      line 347 MusicBrainz::Server
      line 361 MusicBrainz::Server
      line 393 MusicBrainz::Server

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

          ISE when changing from reltype with dates to reltype without them

              When trying to change "original member" to "founder" for https://beta.musicbrainz.org/artist/3d4c9a99-24d7-4a73-8993-33cb83280bad/edit I get:

              Error:

              Caught exception in MusicBrainz::Server::Controller::Artist->edit "The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): P0001 DBD::Pg::st execute failed: ERROR: Attempt to add dates to a relationship type that does not support dates. [for Statement "INSERT INTO link (ended,end_date_year,begin_date_month,attribute_count,begin_date_year,end_date_month,link_type,begin_date_day,end_date_day) VALUES (?,?,?,?,?,?,?,?,?) RETURNING id" with ParamValues: 1='0', 2=undef, 3=undef, 4='0', 5='1985', 6=undef, 7='895', 8=undef, 9=undef] at lib/MusicBrainz/Server/Controller.pm line 103.
              at lib/Sql.pm line 334.
              at lib/Sql.pm line 334."
              Stack trace:
              line 19 MusicBrainz::Server::Model::MB
              line 202 MusicBrainz::Server::Controller
              line 132 MusicBrainz::Server::Controller::Role::EditRelationships
              line 49 MusicBrainz::Server::Controller::Role::Edit
              line 584 MusicBrainz::Server::Controller::Artist
              line 346 MusicBrainz::Server
              line 320 MusicBrainz::Server
              line 347 MusicBrainz::Server
              line 361 MusicBrainz::Server
              line 393 MusicBrainz::Server

                    reosarevok Nicolás Tamargo
                    reosarevok Nicolás Tamargo
                    Votes:
                    3 Vote for this issue
                    Watchers:
                    7 Start watching this issue

                      Created:
                      Updated:
                      Resolved:

                        Version Package
                        2025-01-13

                          reosarevok Nicolás Tamargo
                          reosarevok Nicolás Tamargo
                          Votes:
                          3 Vote for this issue
                          Watchers:
                          7 Start watching this issue

                            Created:
                            Updated:
                            Resolved:

                              Version Package
                              2025-01-13