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

Pasting long text in Edit annotation form Changelog field leads to DatabaseError

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2022-01-31
    • None
    • Edit system
    • None

      I did this by error, pasting a long text in this field.
      I think the problem should be catched before trying to insert data in the database.

       

       

       
      Error:
      The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): 22001 DBD::Pg::st execute failed: ERROR: value too long for type character varying(255) [for Statement "INSERT INTO annotation (changelog,editor,text) VALUES (?,?,?) RETURNING id" with ParamValues: 1='All music written by King Bastard All lyrics by Isabel Guido Violin performed by Dylan Hutchins Viola performed by Andrew Weiss Produced by King Bastard Engineered by Colin Marston and Mike Verni Mixed and Mastered by Colin Marston Artwork: Intuitive Designs Recorded in Menegroth Studio in Queens, NY as well as Mike's basement, Andrew's garage, and Reed's closet King Bastard is... Mike Verni: Guitar Isabel Guido: Synth, Saxophone, and Vocals Arthur Erb: Bass Matt Ryan: Drums and Auxiliary Percussion', 2='594475', 3='All music written by King Bastard All lyrics by Isabel Guido Violin performed by Dylan Hutchins Viola performed by Andrew Weiss Produced by King Bastard Engineered by Colin Marston and Mike Verni Mixed and Mastered by Colin Marston Artwork: Intuitive Designs Recorded in Menegroth Studio in Queens, NY as well as Mike's basement, Andrew's garage, and Reed's closet King Bastard is... Mike Verni: Guitar Isabel Guido: Synth, Saxophone, and Vocals Arthur Erb: Bass Matt Ryan: Drums and Auxiliary Percussion'] at lib/MusicBrainz/Server/Controller.pm line 82. at lib/MusicBrainz/Server/Controller.pm line 80 Try::Tiny::try(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 82 MusicBrainz::Server::Controller::insert_edit(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller.pm line 170 Sql::run_in_transaction(?, ?) called at lib/MusicBrainz/Server/Model/MB.pm line 19 MusicBrainz::Server::Model::MB::with_transaction(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 184 MusicBrainz::Server::Controller::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, undef, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/Annotation.pm line 133 Catalyst::dispatch called at lib/MusicBrainz/Server.pm line 388 MusicBrainz::Server::ANON_ at lib/MusicBrainz/Server.pm line 355 MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 389 Class::MOP::Method::Wrapped::_ANON called at lib/MusicBrainz/Server.pm line 403 Class::MOP::Method::Wrapped::ANON_ called at lib/MusicBrainz/Server.pm line 488
       
      Time: 2022-01-14T09:08:25.222Z
      Host: e0a30e9742ae
      Interface language: en
      URL: https://musicbrainz.org/release/24aeee04-380d-4307-9a76-9fec896dde04/edit_annotation?returnto=https%3A%2F%2Fmusicbrainz.org%2Frelease%2F24aeee04-380d-4307-9a76-9fec896dde04
      Request data:
      { "body_parameters": \{ "edit-annotation.changelog": "All music written by King Bastard All lyrics by Isabel Guido Violin performed by Dylan Hutchins Viola performed by Andrew Weiss Produced by King Bastard Engineered by Colin Marston and Mike Verni Mixed and Mastered by Colin Marston Artwork: Intuitive Designs Recorded in Menegroth Studio in Queens, NY as well as Mike's basement, Andrew's garage, and Reed's closet King Bastard is... Mike Verni: Guitar Isabel Guido: Synth, Saxophone, and Vocals Arthur Erb: Bass Matt Ryan: Drums and Auxiliary Percussion ", "edit-annotation.text": "All music written by King Bastard\r\nAll lyrics by Isabel Guido\r\nViolin performed by Dylan Hutchins\r\nViola performed by Andrew Weiss\r\n\r\nProduced by King Bastard\r\nEngineered by Colin Marston and Mike Verni\r\nMixed and Mastered by Colin Marston\r\nArtwork: Intuitive Designs\r\nRecorded in Menegroth Studio in Queens, NY as well as Mike's basement, Andrew's garage, and Reed's closet\r\n\r\nKing Bastard is...\r\nMike Verni: Guitar\r\nIsabel Guido: Synth, Saxophone, and Vocals\r\nArthur Erb: Bass\r\nMatt Ryan: Drums and Auxiliary Percussion " }
      , "query_parameters": { "returnto": "https://musicbrainz.org/release/24aeee04-380d-4307-9a76-9fec896dde04" } }
      

       

            reosarevok Nicolás Tamargo
            zas Zas
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2022-01-31