-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
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" } }