Issue Details (XML | Word | Printable)

Key: MBS-4148
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Normal Normal
Assignee: Lukáลก Lalinský
Reporter: Johannes Weißl
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

ISE and wrong "Edit artist credit" when renaming artist with 2 ACs

Created: 07/Jan/12 12:34 PM   Updated: 08/Jan/12 02:58 PM   Resolved: 08/Jan/12 02:58 PM
Component/s: Edit system
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 


 Description  « Hide

I discovered a bug regarding the new "Rename artist credits" feature. What I did was this:

  • rename "...And You Will Know Us by the Trail of Dead" to "...And You Will Know Us by the Trail of Dead" (converting the three dots to an ellipsis) in edit #16125476, selecting both available ACs "...And You Will Know Us by the Trail of Dead" and "...And You Will Know Us by The Trail of Dead" (capitalized "The").
  • this results in a correct edit #16125478 for the former AC, but an incorrect edit #16125477 for the later one (nothing seems to be changed).

Since I can't approve the "Edit artist credits" edits on the main server, I tried to approve them on the official test server and a local test server (running production code), and to my surprise approving the second edit even resulted in an ISE. To see it, try to click "Accept edit" on edit #16084617 on the test server:

Caught exception in MusicBrainz::Server::Controller::Test->accept_edit "Failed query:
	'DELETE FROM artist_credit
         WHERE id = ?'
	(831673)
DBD::Pg::st execute failed: ERROR:  update or delete on table "artist_credit" violates foreign key constraint "recording_fk_artist_credit" on table "recording"
DETAIL:  Key (id)=(831673) is still referenced from table "recording". at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 103.


Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.