Duplicated Entries in Database

General discussion about the media server. Feature requests. Hints, tips and tricks.
Locked
edoellin
Posts:1
Joined:Sat Jan 30, 2010 8:22 pm
AV Hardware:Ubuntu Server
Duplicated Entries in Database

Post by edoellin » Sat Jan 30, 2010 8:34 pm

Hi Forum,
I have a small problem with my twonkymedia server. I simply get some duplicated entries in the database.
The entries are not duplicated in the file system, even making an SQL query to the "Item" table shows the two entries pointing to the same file, only difference in the last fields (see below).

sqlite> select * from Item where filename like '%Corresponda%';
/data/dm5620/Music/iTunes/iTunes Media/Music/Joan Manuel Serrat/En Tránsito/01 - A Quien Corresponda....mp3|object.item.audioItem.musicTrack|01 - A Quien Corresponda...|Joan Manuel Serrat|Joan Manuel Serrat|||Pop-Folk|En Tránsito|Joan Manuel Serrat|||||8|0|||||d||>>>>
3E0070:05:42
3D0076458317
420012
4000544100
0C003MP3
4C003mp3
3100A1264864328
3500A1264864328
||1264321139|14|14564
/data/dm5620/Music/iTunes/iTunes Media/Music/Joan Manuel Serrat/En Tránsito/01 - A Quien Corresponda....mp3|object.item.audioItem.musicTrack|01 - A Quien Corresponda...|Joan Manuel Serrat|Joan Manuel Serrat|||Pop-Folk|En Tránsito|Joan Manuel Serrat|||||8|0|||||d||>>>>
3E0070:05:42
3D0076458317
420012
4000544100
0C003MP3
4C003mp3
3100A1264864328
3500A1264864328
||1261602146|14|14583

I´ll be grateful if anybody could help me with this issue.

Regards,
Ernesto.

TwonkyMedia version: 5.1.2
Server hardware: Standard PC(Intel, 3Ghz, 2GB RAM)
Operating System (Ubuntu Server 9.10)

Locked