From: Jeremy Kerr Subject: [PATCH,RFC] Fix scanner abort on files with 'ID' tags To: Currently, the Squeezecenter scanner will never scan my collection, as it aborts during the scan. The relevant parts of my scanner.log file are up at: http://ozlabs.org/~jk/tmp/squeezecenter/scanner.log One of the files that will cause this abort has the following tags: ALBUM=Amphetamine 12" ARTIST=Drax DESCRIPTION= GENRE= ID=ACA9826R-12 TITLE=Amphetamine (Gecko Remix) TRACKNUMBER=2 From the logs, it looks like squeezecenter is trying to populate the 'ID' column (ie, the integer primary key) of the track table with the ID value of the tag, so the insert fails. The insert command: [08-09-01 20:56:55.9120] Slim::Schema::Debug::query_start (26) INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, id, lossless, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '47436132', '921880.552676116', '2', 'flc', '0', '47436132', 'ACA9826R-12', '1', '0', '44100', '411.602721088435', '1141561255', 'Amphetamine (Gecko Remix)', 'AMPHETAMINE GECKO REMIX', 'AMPHETAMINE GECKO REMIX', '2', 'file:///home/jk/music/Drax%20Ltd%20II/ACA9826R-12/Amphetamine%20(Gecko%20Remix).flac', '1', '0' This patch fixes the problem for me, but seems to be a bit of a "paper-over" solution. Is there a way to globally disallow 'id' tags from being used as the 'id' column? Signed-off-by: Jeremy Kerr --- Slim.orig/Formats/FLAC.pm 2008-06-10 23:47:53.000000000 +1000 +++ Slim/Formats/FLAC.pm 2008-06-12 22:42:10.000000000 +1000 @@ -42,7 +42,6 @@ 'DISCNUMBER' => 'DISC', 'DISCTOTAL' => 'DISCC', 'URL' => 'URLTAG', - 'ID' => 'IDTAG', 'MUSICBRAINZ_SORTNAME' => 'ARTISTSORT', 'MUSICBRAINZ_ALBUMARTIST' => 'ALBUMARTIST', 'MUSICBRAINZ_ALBUMARTISTID' => 'MUSICBRAINZ_ALBUMARTIST_ID',