Hi torben
I am trying to create a new playlist for tomorrow but recieving the following error
SQL ERROR : ERROR INSERT OR UPDATE ON TABLE PLAYLIST VIOLATES FOREIGN KEY CONSTRAINT PLAYLIST ITEM FKEY DETAL: KEY ITEM 19422 IS NOT PRESENT IN TABLE ITEMS
REGARDS
Goos
bugreport.txt (42 KB)
Do you by any chance use mAirListDB along with an external database and use external database IDs, or do you only use mAirListDB?
BFN
Cad
This error occurs when you’re trying to add an item to the playlist which does not exist anymore.
It should NEVER happen when you add the items directly from the library browser.
Copy the playlist into the clipboard (select all items, press Ctrl+C), paste it into a text editor, and search for the string “19422”, appearing in the DatabaseID context. This should help you identify the broken item.
The funniest part of this issue is when i am using version 1122 i do not have this problems. I am working on the original database of version 3 . I have upgraded the database scvhema to version 18 So i do not know what is causing this . I did have deleted some double songs in the database tonight…
Goos