Same thing was happening to me after both upgrading and fresh install
(WinXP Pro, library with about 11,000 songs).
I tried running scanner.exe from the command line as described above,
and found an error message about a duplicate value in the years table
(after which the scan aborted).
Turns out that one of my ripped CDs had a year *and* month in the
songs' metadata ("200506"). The years table's only column, "id"
(containing unique years), had a data type of smallint (insigned) which
means that the maximum value was 65,535. The 200506 was getting saved as
65,535 in the table, leading to a duplicate key error on the second song
from that CD.
I ALTER'ed that table to change the column type to mediumint unsigned,
which has a much larger maximum value, and was then able to
successfully run the scan to completion. (I know, I could have fixed
the year on those files, but there might have been more like it.).
--
RandyN
------------------------------------------------------------------------
RandyN's Profile: http://forums.slimdevices.com/member.php?userid=7640
View this thread: http://forums.slimdevices.com/showthread.php?t=27776
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
