INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Bug? Introducing new library field leads to double entry in Library  (Read 1421 times)

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038

I have introduced two new fields: Record Label and Source.

This leads in each standard view to double entries in the library database:
e.g. Artist …..track 01.flac
       Artist…  track01.flac

In the associated folder there is only one entry:  track01.flac.

What is the reason for this? And how to get rid of the second entry? There now thousands!
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72446
  • Where did I put my teeth?
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #1 on: November 25, 2018, 07:04:05 am »

It can happen if you are importing the files from a network path and also from a mapped drive that points to the same location.
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #2 on: November 25, 2018, 07:50:46 am »

I have not imported any new files. I introduced two new fields on the MC server machine via remoted desktop.

Yes , I have mapped drives. So file path is e.g. M:\\.... track01.flac
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #3 on: November 25, 2018, 02:07:03 pm »

Check your auto import settings - as JimH says the usual cause of double entries is having two seperate paths to the same file. If you look at the addresses of the duplicated files are they exactly the same?
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #4 on: November 25, 2018, 02:49:57 pm »

Quote
If you look at the addresses of the duplicated files are they exactly the same?

Yes, exactly the same:

M:\Audio\(Multiple Artists)\Women - The Best Jazz Vocal (Disc 1 of 2)\07 - Why Should I Care (1).flac
M:\Audio\(Multiple Artists)\Women - The Best Jazz Vocal (Disc 1 of 2)\07 - Why Should I Care (1).flac

I have now re-imported my whole M:\Audio library.
Double entries differ in the metadata e.g Publisher: NativeDSD whether the duplicate for Publisher is empty.

How can this be happen?
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #5 on: November 25, 2018, 03:17:02 pm »

Odd!! Do you have your windows 10 music folder pointing to the same address?
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #6 on: November 25, 2018, 04:17:11 pm »

Quote
Do you have your windows 10 music folder pointing to the same address?

Win 10 Explorer has no issues -> if I click Locate on Disk (external) everything is OK also if I browse through Win Explorer to the Album - all files are there and no duplicate *.flac files.

In the beginning of the day everything was OK, then I added two new fields resulting in the current big! problem. 
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #7 on: November 25, 2018, 04:39:06 pm »

I have just tried adding a field by remote  connection (although I use team viewer) added some data to a number of fields and there wasn't any duplication of entries in the library. It might be a windows remote desktop thing. Do all of the duplicated files have a consistent difference in one field which you could select them on? If so you could find them and remove them from the library. Personally if I do anything like adding fields I generally do it directly on the server.
Logged

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #8 on: November 25, 2018, 04:50:33 pm »

Looking back through the forum posts I see you have had duplication problems before so I would think that there is something odd about the way your system is set up. are you using MC 24.0.60?
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #9 on: November 26, 2018, 02:04:38 am »

Quote
are you using MC 24.0.60
yes

The problem with the duplicates appears only for audio files.
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #10 on: November 26, 2018, 12:48:58 pm »

As far I have seen now - all the duplicates have no User assigned in the "User" Column.
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #11 on: November 26, 2018, 05:32:43 pm »

Ok, none of my files have a user value. Who is the user in those duplicated file entries with a value in the field? At least it will be easy to select and delete those entries with an empty user field and then delete them.
Logged

RoderickGI

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8186
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #12 on: November 26, 2018, 05:51:16 pm »

Post an image of your Auto Import settings like the one below Manfred.
Logged
What specific version of MC you are running:MC27.0.27 @ Oct 27, 2020 and updating regularly Jim!                        MC Release Notes: https://wiki.jriver.com/index.php/Release_Notes
What OS(s) and Version you are running:     Windows 10 Pro 64bit Version 2004 (OS Build 19041.572).
The JRMark score of the PC with an issue:    JRMark (version 26.0.52 64 bit): 3419
Important relevant info about your environment:     
  Using the HTPC as a MC Server & a Workstation as a MC Client plus some DLNA clients.
  Running JRiver for Android, JRemote2, Gizmo, & MO 4Media on a Sony Xperia XZ Premium Android 9.
  Playing video out to a Sony 65" TV connected via HDMI, playing digital audio out via motherboard sound card, PCIe TV tuner

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #13 on: November 27, 2018, 01:19:35 pm »

Quote
Post an image of your Auto Import settings like the one below Manfred.

see attachment.

Quote
OK, none of my files have a user value. Who is the user in those duplicated file entries with a value in the field? At least it will be easy to select and delete those entries with an empty user field and then delete them.

Yes its easy to delete them, its not for all items and I would like to understand what happend (I have had the problem now for the second time).
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #14 on: November 27, 2018, 04:10:47 pm »

Some questions to try to narrow down the problem -
1. Did you at some time set up a user with restricted access - such as only audio files?
2. On the main server under View>User is more than one user listed?
3. Are the files duplicated in the clients library as well as in the main server library?
4. Does your client log on to the main server with a user and password and what access is granted?
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #15 on: November 27, 2018, 05:09:13 pm »

Quote
1. Did you at some time set up a user with restricted access - such as only audio files?
2. On the main server under View>User is more than one user listed?
3. Are the files duplicated in the clients library as well as in the main server library?
4. Does your client log on to the main server with a user and password and what access is granted?

1. No (if had not typing something wrong as an unnoticed error)
2. yes
3. yes
4. yes - not restricted
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #16 on: November 27, 2018, 05:31:35 pm »

Could you set up a new temporary library called something like test and import just a few albums into it.
Look at the user field to see if there is any data in it.
Then on the main server (NOT using remote desktop) add a new library field called test1. Check whether the library shows duplicated file entries.
Then remote desktop into the main server from your client machine and add another new library field called test2. Check whether files are now duplicated.
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #17 on: November 28, 2018, 09:53:38 am »

Quote
Could you set up a new temporary library called something like test and import just a few albums into it.

I have a client (PC) running "MC Client" and my physical Server running "MC Server"

Should I create a new temporary library on the MC Server? If yes, an empty library or a clone of my existing library?
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #18 on: November 28, 2018, 10:15:37 am »

I have a client (PC) running "MC Client" and my physical Server running "MC Server"

Quote
Could you set up a new temporary library called something like test and import just a few albums into it.

I created a local new library called test on my  "MC Server" and imported 5 existing Album's. from my Audio/… folder on the physical server.

Quote
Look at the user field to see if there is any data in it.

No -> Importing Albums seem not to include the User's.

Quote
Then on the main server (NOT using remote desktop) add a new library field called test1. Check whether the library shows duplicated file entries.

Logged into the physical server using iKVM remote mgmt. Created a new library field called test1. No double entries.

Quote
Then remote desktop into the main server from your client machine and add another new library field called test2. Check whether files are now duplicated.

Remote desktop into the physical Server ->Files are not duplicated

Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #19 on: November 28, 2018, 10:28:44 am »

In answer to this question
2. On the main server under View>User is more than one user listed?
You said yes - how many users are listed? Is it possible to remove them leaving just the Administrator user?

Clearly duplication of your files is not caused by remote connection so the only thing that is left is some problem over the users on the main server.

You should delete the new fields in the test library and then delete the whole test library.
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #20 on: November 28, 2018, 12:24:23 pm »

Quote
. On the main server under View>User is more than one user listed?
yes
Quote
how many users are listed?
6
Quote
Is it possible to remove them leaving just the Administrator user?
I like to say no - not everyone should see everything (I use MC also as document archive for bank statements etc.)

I think about a different test case: With the testlib there were no users , adding two users and then adding a new field should prove if more than to users and adding a new field leads to the duplicates.


Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #21 on: November 28, 2018, 01:14:25 pm »

That a good idea - limit one to only audio with some sort of restricted access.
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #22 on: November 28, 2018, 01:31:49 pm »

Quote
I think about a different test case: With the testlib there were no users , adding two users and then adding a new field should prove if more than to users and adding a new field leads to the duplicates.

I have done that, but no duplicates.  ?

In the mean time I have got through every album and removed the duplicates from the library. Last time as it first occurs I restored a backup.

There were albums with no assigned users and no duplicates but also albums with assigned users and also no duplicates. The duplicates had in some cases not the same metadata (less) as the entries with the assigned users.  ?
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #23 on: November 28, 2018, 01:38:25 pm »

Perhaps the cause is adding the new fields when one of the non admin users is selected - perhaps it would be wise to ensure that when you remote in to the server that you check which user is currently selected and change to the admin user before making any major changes to the library structure in future.
Logged

Manfred

  • Citizen of the Universe
  • *****
  • Posts: 1038
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #24 on: November 28, 2018, 02:06:26 pm »

I remember now what I did, what I normally not do.

I ripped a cd on my PC under main library. Usually I copy the folder from the PC to my server under Audio/… with windows explorer and auto import of MC on the server does the rest.
But last time I used the Library Tools of MC to copy the tracks to the server. But the main library has not the same users as the library on the server. Maybe that was causing it but I really don't know.
Logged
WS (AMD Ryzen 7 5700G, 32 GB DDR4-3200, 8=2x2+4 TB SDD, LG 34UC98-W)-USB|ADI-2 DAC FS|Canton AM5 - File Server (i3-3.9 GHz, 16GB ECC DDR4-2400, 46 TB disk space) - Media Renderer (i3-3.8 GHz, 8GB DDR4-2133, GTX 960)-USB|Devialet D220 Pro|Audeze LCD 2|B&W 804S|LG 4K OLED )

swiv3d

  • Guest
Re: Bug? Introducing new library field leads to double entry in Library
« Reply #25 on: November 28, 2018, 03:01:57 pm »

Seems like the most likely explanation for now anyway!
Logged
Pages: [1]   Go Up