In the process of trying to make a simple HTML page for my library, I have decided to go straight to the source: the DL3 SQLite3 database.
To my surprise, there are items in the SQLite database that I do not have in my DL3 library!
After double checking, there are 1171 rows (items) in the SQLite3 database, whereas there are only 591 items in my DL3 database.
Could someone from DM give an explanation for this? And, if possible, a solution for cleaning up this mess?
Best regards,
Nicolas
Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.
Twitter,
Facebook, or email.
-
I've seen this too, but looking at the entity type, each duplicate line is something to do with ratings or recommendations.
I don't believe it's a mess, I believe it's supposed to be that way.
z_ent =6 is for wishlist items
z_ent = 3 is for actual items -
-
Thanks for the info.
The funny thing is that I don't have anything in my "Wishlist".
Looking at the Z_ENT column, I have no value=6. I do have a few 7, a few 10, and a lot of 11 (in addition to the 3s)...
Thanks again for you reply. It's of great help! -
-
Z_PRIMARYKEY contains the description for all the content (see below) I was right, the duplicates are to do with ratings, they are type 11. Why they contain the same information (much but not quite) as the physical items I suppose is the question, but for whatever reason, the program does it that way.
3's are the physical items.
1 AbstractMedium
2 ConceptualMedium
3 PhysicalMedium
4 ITunesBook
5 ITunesCollection
6 WishlistMedium
7 EphemeralTopRecommendation
8 LightweightCachedMedium
9 SearchResultFromStore
10 SimilarItemFromStore
11 RatingHolderMedium
12 AbstractSynopsis
13 Synopsis
14 UserSynopsis
15 CoverImageDataHolder
16 HeaderSource
17 ITunesTrack
18 Loan
19 MediaCreationReason
20 PublishingSite
21 Shelf
22 AllMediaOfATypeShelf
23 BorrowedItemsShelf
24 LoanedItemsShelf
25 RootShelf
26 ITunesRootShelf
27 Library
28 Friend
29 YourShelf
30 SnubbedMediaKey
31 Sort -
-
-
Loading Profile...



