Playlist Empty After Update

Hello, i recently updated my Karaoke mugen windows desktop app and upon restart “my playlist” with 163 songs was blank. is there any way to recover this playlist or check my local files for the song titles ? as i don’t believe i manually made a backup for it.

Hello, and thanks for your message. :slight_smile:

What is this screenshot of? Before the update?

Is the song library filled up after the update, or is it blank as well?

Can you send a log of your Karaoke Mugen app so we can try to see what’s wrong?

Hello thanks for the response, the screenshot is of my playlist before the update. after the update however my playlist is blank. the song library is still full. i cant seem to upload my files to this forum as a .txt or a .log. I’ve attached a link to a google drive folder where i uploaded a log file from a previous time i used the app last year ( 2023-05-05) and one from after the update i believe (2024-07-10)
https://drive.google.com/drive/folders/1V05px9FroDoplvqPCM-YtNiSZPtZ4_yL?usp=sharing

Sorry about the attachment issue, we’re still learning how to configure this Discourse forum properly :stuck_out_tongue: It should be possible ot upload attachments now.

What’s weird is that playlists aren’t emptied usually during updates, or modified in any way. What might have happened is that the library was empty so your playlist appears empty but really isn’t. However if you say the library shows up with all songs, then that should be fine.

Are you also sure all collections are enabled ? You can check in System Panel > Collections and Repositories, or on the welcome screen.

One other thing you might want to try is to export that playlist and look into the json file it exports to see if you still see anything in there.

At first glance I don’t see any problems in y our logs. You jumped from a very old version to the newest so it should be fine, but I don’t think we’ve tested updating from an old 6.x version to a 8.0 version. Your playlists seem to still be there so that’s a good thing though.

I have to make another google drive for the screenshots, when i try to upload more then one here i get a message saying “An error occurred: Sorry, new users can only put one embedded media item in a post.”

Yes i’ve enabled all collections. when exporting the “my playlist” after the update and read in notepad it displays 0 kara, and there are no other km playlist files saved on my computer as far as i can tell.

Is it possible that im not logging into the correct user that the original playlist pre update was saved on ? I believe i had multiple usernames attached to the playlist because of issues with resetting passwords through the app in the past. (indicated in pic 1+2 with different avatars and song requested name “ketsinhaake” my normal name with a missing D in hadake)

currently im able to log into the kara moe website with “ketsinhadake” but not as an online account with the same credentials in app. i can log in offline in app with the same credentials as the kara moe website but when i try to convert it to online i am met with an error. is there a way to fix this (pic 3+4+5)

Also i found a folder in karaoke mugen that had downloaded media of most of the karaoke songs i had in my playlist so i will probably go through and manually search them and add them to a new playlist if i can get my “ketsinhadake” user converted to an online account. (pic 6)

https://drive.google.com/drive/folders/10C5vTkJyyGR6s78gB1D77ngcG-D2ZP_7?usp=drive_link

akismet the automated spam filter temporarily hid my reply if you could take a look at it, thanks.

Okay, one problem at a time.

  • I have no idea what might have happened to your playlist then. My guess is that the jump from KM 6.0.x to KM 8.0.x didn’t work that well and the playlist got truncated at some point for some reason. Normally it shouldn’t but we’ve never tried that update path before, as we don’t have the time to test all updates from all versions of KM and onwards. So, yeah, I’m not sure how to help you there. If the exported file shows 0 songs, it likely means it got wiped at some point.

  • Playlists aren’t linked to users. Playlist items are, but removing a user will just make sure that playlist items are properly set to the default “admin” user instead. However, there might be a world where the playlist items are still in the database but invisible due to them being linked to an unknown user. We could probably add some maintenance script at startup that takes care of checking if all users linked still exist. Just to be sure, you should come over on our Discord and send me your karaokemugen.sql.gz file via a DM. Do not send it here as it contains sensitive data and you wouldn’t want everyone to just see it.

  • Your online/offline issue is a different problem altogether. It looks like your app and the server are desynced, where your app knows a local user that the server also has. You obviously can’t convert it because that’d mean anyone could overwrite your online user with a local one of their own. What you can do is either :

    • Remove the online user on kara.moe (if it doesn’t have anything of value like online playlists or favorites) and then convert it.
    • Or remove the local user on your app and then you’ll be able to login using your online credentials.

Please try to open différent posts for different issues next time, just to make things clearer :slight_smile:

We should do this unless you still can connect on kara.moe.

Resolved the playlist issue.

It turned out that it had been indeed wiped out, probably by a migration or something similar, we’re never going to be sure as we don’t test upgrade paths for all versions.

Luckily there was an old dump with the playlist in there. I converted the COPY FROM syntax to a PlaylistContents array. For reference, it took writing a script like that:

ketsin.kmplaylist a skeleton playlist export with no content.

const fs = require('fs');

const pldata = `166	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b71c7195-a407-4f78-8a36-9ed01c753c02	2024-07-10 13:47:08.312-05	163	ketsinhadake	ketsinhadake	t	t	f	f	\N
165	fae81dc4-4501-48da-ad18-7a4e744bb9f2	47f5cd2a-e556-4412-8fcc-d4398f078472	2024-07-10 13:29:55.445-05	162	ketsinhadake	ketsinhadake	t	t	f	f	\N
112	fae81dc4-4501-48da-ad18-7a4e744bb9f2	288c6aec-e6da-413e-8e9f-659ed879769a	2021-10-05 12:25:57.823-05	111	ketsinhadake	ketsinhadake	t	t	f	f	\N
121	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5eadbf98-a7ef-40f1-bc61-ab8208f67bf4	2022-07-31 16:50:32.58-05	120	ketsinhadake	ketsinhadake	t	t	f	f	\N
157	fae81dc4-4501-48da-ad18-7a4e744bb9f2	bd6edbef-f71b-4267-857e-aab7cd19d4ac	2022-09-22 00:06:58.371-05	154	ketsinhadake	ketsinhadake	t	t	f	f	\N
163	fae81dc4-4501-48da-ad18-7a4e744bb9f2	3b82027d-4e58-4d3a-9208-f9579b26c9ec	2022-10-03 12:45:58.872-05	160	ketsinhadake	ketsinhadake	t	t	f	f	\N
131	fae81dc4-4501-48da-ad18-7a4e744bb9f2	2b735931-a19d-48cb-9e88-1fd2832719e5	2022-08-01 23:52:16.295-05	129	ketsinhadake	ketsinhadake	t	t	f	f	\N
123	fae81dc4-4501-48da-ad18-7a4e744bb9f2	be200984-1a0a-4987-a979-d1ed3b72a34e	2022-07-31 16:55:50.335-05	121	ketsinhadake	ketsinhadake	t	t	f	f	\N
126	fae81dc4-4501-48da-ad18-7a4e744bb9f2	24c74cf4-ac9c-4cb1-8f6a-758392616174	2022-08-01 23:41:40.144-05	124	ketsinhadake	ketsinhadake	t	t	f	f	\N
111	fae81dc4-4501-48da-ad18-7a4e744bb9f2	dfdcb155-da49-4a76-b522-3acdc2d7f677	2021-10-05 12:09:09.565-05	110	ketsinhadake	ketsinhadake	t	t	f	f	\N
129	fae81dc4-4501-48da-ad18-7a4e744bb9f2	8742865f-2727-4fe9-a985-2543633d01db	2022-08-01 23:48:16.907-05	127	ketsinhadake	ketsinhadake	t	t	f	f	\N
115	fae81dc4-4501-48da-ad18-7a4e744bb9f2	1dad762c-fcde-402b-bd5b-ac651e0d0392	2021-10-13 22:06:07.759-05	114	ketsinhadake	ketsinhadake	t	t	f	f	\N
127	fae81dc4-4501-48da-ad18-7a4e744bb9f2	58459451-9fc6-4ca0-baa4-7c886aa84e05	2022-08-01 23:42:40.047-05	125	ketsinhadake	ketsinhadake	t	t	f	f	\N
154	fae81dc4-4501-48da-ad18-7a4e744bb9f2	82546615-63ac-48d3-9afd-31f96fa01d9f	2022-09-22 00:04:44.592-05	151	ketsinhadake	ketsinhadake	t	t	f	f	\N
130	fae81dc4-4501-48da-ad18-7a4e744bb9f2	05401f07-bb2d-4140-b39c-f326d0a263aa	2022-08-01 23:50:50.911-05	128	ketsinhadake	ketsinhadake	t	t	f	f	\N
143	fae81dc4-4501-48da-ad18-7a4e744bb9f2	0f8831fa-933d-4f69-a81d-878258d30505	2022-08-02 21:04:30.228-05	141	ketsinhadake	ketsinhadake	t	t	f	f	\N
155	fae81dc4-4501-48da-ad18-7a4e744bb9f2	2f198509-d614-4920-8ef4-e4abe9e57edc	2022-09-22 00:06:50.926-05	152	ketsinhadake	ketsinhadake	t	t	f	f	\N
162	fae81dc4-4501-48da-ad18-7a4e744bb9f2	422f4b09-ae65-486e-bb6f-27f523c0d439	2022-10-03 12:45:46.623-05	159	ketsinhadake	ketsinhadake	t	t	f	f	\N
102	fae81dc4-4501-48da-ad18-7a4e744bb9f2	176c3bd7-3b17-4eec-9ced-21b342fa6a9e	2021-10-04 16:36:04.654-05	102	ketsinhadake	ketsinhadake	t	t	f	f	\N
77	fae81dc4-4501-48da-ad18-7a4e744bb9f2	65c9ad47-9091-47cb-8bb2-8daf28dd3527	2021-10-02 17:56:48.73-05	77	ketsinhadake	ketsinhadake	t	t	f	f	\N
68	fae81dc4-4501-48da-ad18-7a4e744bb9f2	53e624a6-41de-4c52-b358-b30273ea8e50	2021-10-02 17:46:10.805-05	69	ketsinhadake	ketsinhadake	t	t	f	f	\N
74	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ee30802d-aa8f-4110-9bf2-ccf4446e7500	2021-10-02 17:53:59.238-05	74	ketsinhadake	ketsinhadake	t	t	f	f	\N
50	fae81dc4-4501-48da-ad18-7a4e744bb9f2	e490a807-ad58-48b4-a485-8076d1b31e84	2021-10-01 18:13:08.816-05	52	ketsinhadake	ketsinhadake	t	t	f	f	\N
23	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c51031b1-dc62-4943-80ff-f57b4a6af3eb	2021-09-28 17:27:31.786-05	25	ketsinhaake	admin	t	t	f	f	\N
12	fae81dc4-4501-48da-ad18-7a4e744bb9f2	af584fad-309d-4020-a0ae-de40a50cad9c	2021-09-28 16:54:28.46-05	13	ketsinhaake	admin	t	t	f	f	\N
9	fae81dc4-4501-48da-ad18-7a4e744bb9f2	2a76c105-32a3-40ad-91e2-423931dd18b9	2021-09-28 16:48:08.371-05	10	ketsinhaake	admin	t	t	f	f	\N
86	fae81dc4-4501-48da-ad18-7a4e744bb9f2	247f2288-e692-4cf2-a8d9-72094da1bac3	2021-10-02 18:11:37.211-05	1	ketsinhadake	ketsinhadake	t	t	f	f	\N
92	fae81dc4-4501-48da-ad18-7a4e744bb9f2	12506638-a7d0-404c-9843-4c39318227ec	2021-10-03 14:54:40.791-05	92	ketsinhadake	ketsinhadake	t	t	f	f	\N
20	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5b42fb0d-6b21-4941-a5dd-516a39ffb594	2021-09-28 17:25:37.792-05	22	ketsinhaake	admin	t	t	f	f	\N
19	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f45377d2-ce3c-4d04-b535-a0ff700bd376	2021-09-28 17:12:56.183-05	21	ketsinhaake	admin	t	t	f	f	\N
139	fae81dc4-4501-48da-ad18-7a4e744bb9f2	8d4c2876-eb50-4c68-8625-eaa021582515	2022-08-02 00:03:47.023-05	137	ketsinhadake	ketsinhadake	t	t	f	f	\N
158	fae81dc4-4501-48da-ad18-7a4e744bb9f2	2febf39b-7d1d-431b-acbe-cb84ce5080f0	2022-10-03 12:43:07.507-05	155	ketsinhadake	ketsinhadake	t	t	f	f	\N
106	fae81dc4-4501-48da-ad18-7a4e744bb9f2	a397fb37-825a-46b1-8e02-e74ff704a557	2021-10-05 11:51:18.173-05	18	ketsinhadake	ketsinhadake	t	t	f	f	\N
15	fae81dc4-4501-48da-ad18-7a4e744bb9f2	1f65373d-b895-440b-8f83-3f30736614c7	2021-09-28 16:59:34.279-05	16	ketsinhaake	admin	t	t	f	f	\N
34	fae81dc4-4501-48da-ad18-7a4e744bb9f2	59010354-76f9-4da3-9946-65297ddb372c	2021-10-01 17:37:46.915-05	36	ketsinhadake	ketsinhadake	t	t	f	f	\N
133	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c3ec6694-871b-436f-90f0-b64f598f370e	2022-08-01 23:54:23.185-05	131	ketsinhadake	ketsinhadake	t	t	f	f	\N
79	fae81dc4-4501-48da-ad18-7a4e744bb9f2	4b257dcc-b4b9-4bdf-ab23-778da7dcc3b2	2021-10-02 18:02:34.32-05	79	ketsinhadake	ketsinhadake	t	t	f	f	\N
16	fae81dc4-4501-48da-ad18-7a4e744bb9f2	06864598-f7b4-4ea2-8501-c20e3904b1c8	2021-09-28 17:07:41.587-05	17	ketsinhaake	admin	t	t	f	f	\N
51	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d38f5cf7-890d-40f2-aabd-8e986af51122	2021-10-01 18:14:00.613-05	53	ketsinhadake	ketsinhadake	t	t	f	f	\N
54	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b99417da-8722-4dcc-961f-97ba08ec4d58	2021-10-01 18:21:20.094-05	55	ketsinhadake	ketsinhadake	t	t	f	f	\N
37	fae81dc4-4501-48da-ad18-7a4e744bb9f2	08c7e4a0-7fc3-4331-ac1e-be3ad381ddc5	2021-10-01 17:43:11.673-05	39	ketsinhadake	ketsinhadake	t	t	f	f	\N
62	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f869ecca-5861-4868-82da-78d29f0daca9	2021-10-02 17:34:31.49-05	63	ketsinhadake	ketsinhadake	t	t	f	f	\N
6	fae81dc4-4501-48da-ad18-7a4e744bb9f2	9f15c178-9ac6-48f1-a05f-38add698f109	2021-09-28 16:42:27.564-05	7	ketsinhaake	admin	t	t	f	f	\N
5	fae81dc4-4501-48da-ad18-7a4e744bb9f2	bc34a9c0-a220-448f-b1a9-803dbdb53206	2021-09-28 16:41:49.178-05	6	ketsinhaake	admin	t	t	f	f	\N
46	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5f12fa92-b7e5-4f18-bb31-2688204936db	2021-10-01 18:03:34.561-05	48	ketsinhadake	ketsinhadake	t	t	f	f	\N
60	fae81dc4-4501-48da-ad18-7a4e744bb9f2	52cdc0ec-201e-4e0a-be85-e129e181c08b	2021-10-02 17:30:38.543-05	61	ketsinhadake	ketsinhadake	t	t	f	f	\N
159	fae81dc4-4501-48da-ad18-7a4e744bb9f2	e34a2e52-0e1b-4c1c-83fb-799359753ea7	2022-10-03 12:43:35.417-05	156	ketsinhadake	ketsinhadake	t	t	f	f	\N
61	fae81dc4-4501-48da-ad18-7a4e744bb9f2	38ba303e-04a5-4f6d-9723-a0fbe8c6a6f2	2021-10-02 17:32:18.033-05	62	ketsinhadake	ketsinhadake	t	t	f	f	\N
118	fae81dc4-4501-48da-ad18-7a4e744bb9f2	3f8aa1df-19e4-4462-baff-675831a4cb2f	2021-11-18 10:23:22.035-06	117	ketsinhadake	ketsinhadake	t	t	f	f	\N
146	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c9971aee-6d12-4d25-8379-a3f24a8e631f	2022-08-02 21:18:45.937-05	144	ketsinhadake	ketsinhadake	t	t	f	f	\N
161	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d5523693-00f2-4764-bfa4-794dcaac1879	2022-10-03 12:44:22.468-05	158	ketsinhadake	ketsinhadake	t	t	f	f	\N
27	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f2c8feef-e9bf-4dbb-911b-84b07ad5f676	2021-09-28 17:31:02.968-05	29	ketsinhaake	admin	t	t	f	f	\N
29	fae81dc4-4501-48da-ad18-7a4e744bb9f2	a1b36a6d-d219-455d-917d-561989e75a45	2021-09-28 17:39:35.389-05	31	ketsinhaake	admin	t	t	f	f	\N
30	fae81dc4-4501-48da-ad18-7a4e744bb9f2	82fc71ee-4fbc-4aee-bdbb-1be1817ea02b	2021-10-01 17:20:25.544-05	32	ketsinhadake	ketsinhadake	t	t	f	f	\N
58	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d383e88c-2d2c-4640-abe3-191883724332	2021-10-02 17:25:34.783-05	59	ketsinhadake	ketsinhadake	t	t	f	f	\N
44	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f99df658-9c61-4ea2-a46c-624a1a4c4768	2021-10-01 18:02:39.192-05	46	ketsinhadake	ketsinhadake	t	t	f	f	\N
49	fae81dc4-4501-48da-ad18-7a4e744bb9f2	e77099af-dd12-4839-9d2a-32e3160ded1e	2021-10-01 18:07:34.292-05	51	ketsinhadake	ketsinhadake	t	t	f	f	\N
73	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b98cb24a-19d7-4965-abc2-fe4b756c1f0b	2021-10-02 17:53:20.58-05	73	ketsinhadake	ketsinhadake	t	t	f	f	\N
53	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c8e61289-31fd-430a-8a56-f0ed95f84d50	2021-10-01 18:19:19.118-05	54	ketsinhadake	ketsinhadake	t	t	f	f	\N
87	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5302525a-c773-4765-b648-7e71a2d2c532	2021-10-02 18:13:37.442-05	86	ketsinhadake	ketsinhadake	t	t	f	f	\N
85	fae81dc4-4501-48da-ad18-7a4e744bb9f2	27c2c99d-3a3c-4f1d-a425-ddcda1956f84	2021-10-02 18:11:01.05-05	85	ketsinhadake	ketsinhadake	t	t	f	f	\N
36	fae81dc4-4501-48da-ad18-7a4e744bb9f2	246adee8-3709-4938-8aa4-c63055b5a3da	2021-10-01 17:42:54.459-05	38	ketsinhadake	ketsinhadake	t	t	f	f	\N
69	fae81dc4-4501-48da-ad18-7a4e744bb9f2	dc61c6c9-014d-4b32-99dc-fc0ec13cab4e	2021-10-02 17:47:45.123-05	70	ketsinhadake	ketsinhadake	t	t	f	f	\N
83	fae81dc4-4501-48da-ad18-7a4e744bb9f2	44175ab3-45b2-4bf2-86ac-8a31870b19c7	2021-10-02 18:09:01.292-05	83	ketsinhadake	ketsinhadake	t	t	f	f	\N
153	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c6c8cef4-b777-44cc-9268-ce0f6c458a98	2022-09-06 16:55:24.035-05	150	ketsinhadake	ketsinhadake	t	t	f	f	\N
31	fae81dc4-4501-48da-ad18-7a4e744bb9f2	20b2eb92-9387-480e-b8d4-c478735ef689	2021-10-01 17:22:08.022-05	33	ketsinhadake	ketsinhadake	t	t	f	f	\N
26	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c16c9069-a687-4a01-a23e-6d9eb0cbe334	2021-09-28 17:29:52.82-05	28	ketsinhaake	admin	t	t	f	f	\N
25	fae81dc4-4501-48da-ad18-7a4e744bb9f2	30829476-8801-4c6f-a320-0117ebd7d840	2021-09-28 17:28:46.866-05	27	ketsinhaake	admin	t	t	f	f	\N
17	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5af1fe64-2311-4a64-898d-00f91ee8c744	2021-09-28 17:08:58.946-05	19	ketsinhaake	admin	t	t	f	f	\N
2	fae81dc4-4501-48da-ad18-7a4e744bb9f2	8f200127-2a17-4519-94f8-d89280b336fa	2021-09-28 16:39:29.511-05	3	ketsinhaake	admin	t	t	f	f	\N
8	fae81dc4-4501-48da-ad18-7a4e744bb9f2	58dfa78b-28f9-4dc0-88e7-7c58439b5e00	2021-09-28 16:43:32.057-05	9	ketsinhaake	admin	t	t	f	f	\N
14	fae81dc4-4501-48da-ad18-7a4e744bb9f2	8027618a-6224-40e9-8d7b-1915183c684e	2021-09-28 16:56:17.299-05	15	ketsinhaake	admin	t	t	f	f	\N
13	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f1f9a0e1-dc8d-413d-81d4-4af6fc636794	2021-09-28 16:54:51.726-05	14	ketsinhaake	admin	t	t	f	f	\N
18	fae81dc4-4501-48da-ad18-7a4e744bb9f2	1991d421-fa97-43c0-8578-18f12f619c4c	2021-09-28 17:12:08.128-05	20	ketsinhaake	admin	t	t	f	f	\N
21	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b06e8a51-e704-444c-a04e-f0303d6507e3	2021-09-28 17:26:13.476-05	23	ketsinhaake	admin	t	t	f	f	\N
22	fae81dc4-4501-48da-ad18-7a4e744bb9f2	40cfce71-3a9f-423f-8b3f-d1bde002a462	2021-09-28 17:26:25.238-05	24	ketsinhaake	admin	t	t	f	f	\N
28	fae81dc4-4501-48da-ad18-7a4e744bb9f2	602c3e0b-693c-4d73-be4a-28896f205988	2021-09-28 17:37:51.248-05	30	ketsinhaake	admin	t	t	f	f	\N
33	fae81dc4-4501-48da-ad18-7a4e744bb9f2	75c0d9c8-fd48-45cd-80eb-bf1a8a014df5	2021-10-01 17:34:00.82-05	35	ketsinhadake	ketsinhadake	t	t	f	f	\N
47	fae81dc4-4501-48da-ad18-7a4e744bb9f2	3fac6cbc-18aa-404f-9d01-41bddc8136ec	2021-10-01 18:05:46.002-05	49	ketsinhadake	ketsinhadake	t	t	f	f	\N
90	fae81dc4-4501-48da-ad18-7a4e744bb9f2	2853fd9f-726e-4fef-8bfd-3308b7699e3c	2021-10-02 18:16:55.945-05	90	ketsinhadake	ketsinhadake	t	t	f	f	\N
43	fae81dc4-4501-48da-ad18-7a4e744bb9f2	8009f130-39b8-4221-a052-b234da2a3155	2021-10-01 18:00:44.407-05	45	ketsinhadake	ketsinhadake	t	t	f	f	\N
164	fae81dc4-4501-48da-ad18-7a4e744bb9f2	7ca76108-e255-4c08-a45b-ac2b1d97bdc9	2022-10-03 12:46:07.472-05	161	ketsinhadake	ketsinhadake	t	t	f	f	\N
45	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c358e711-d3fa-4f8a-8a99-620213149a82	2021-10-01 18:03:23.082-05	47	ketsinhadake	ketsinhadake	t	t	f	f	\N
41	fae81dc4-4501-48da-ad18-7a4e744bb9f2	a0ac08a9-46b6-4219-8017-a0a9581ef914	2021-10-01 17:57:35.263-05	43	ketsinhadake	ketsinhadake	t	t	f	f	\N
66	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f6941afc-2ff9-4a0f-b70e-5ed150ad4a5a	2021-10-02 17:44:02.99-05	67	ketsinhadake	ketsinhadake	t	t	f	f	\N
76	fae81dc4-4501-48da-ad18-7a4e744bb9f2	fabfcd79-f03d-403f-93de-966d8246cd9a	2021-10-02 17:56:16.195-05	76	ketsinhadake	ketsinhadake	t	t	f	f	\N
55	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d03d24da-1229-4e70-8a4f-f56c33de3a99	2021-10-01 18:21:45.366-05	56	ketsinhadake	ketsinhadake	t	t	f	f	\N
39	fae81dc4-4501-48da-ad18-7a4e744bb9f2	10b60559-6c11-483a-8fcd-4bee81fb13c0	2021-10-01 17:50:41.1-05	41	ketsinhadake	ketsinhadake	t	t	f	f	\N
93	fae81dc4-4501-48da-ad18-7a4e744bb9f2	a584c792-db80-460b-b6c9-c10907e216d8	2021-10-03 14:54:53.153-05	93	ketsinhadake	ketsinhadake	t	t	f	f	\N
108	fae81dc4-4501-48da-ad18-7a4e744bb9f2	24542da4-114d-4ffb-9c02-f9d4cd06fbcd	2021-10-05 11:59:55.71-05	107	ketsinhadake	ketsinhadake	t	t	f	f	\N
99	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ea492b89-6249-4e50-91fd-5566c5c90970	2021-10-04 16:29:13.624-05	99	ketsinhadake	ketsinhadake	t	t	f	f	\N
105	fae81dc4-4501-48da-ad18-7a4e744bb9f2	18e637ae-e893-406a-ac1f-b5eae412e60d	2021-10-04 16:42:32.65-05	105	ketsinhadake	ketsinhadake	t	t	f	f	\N
103	fae81dc4-4501-48da-ad18-7a4e744bb9f2	e6bc8a58-d10b-48d1-8b66-870d04c1c53d	2021-10-04 16:40:07.902-05	103	ketsinhadake	ketsinhadake	t	t	f	f	\N
24	fae81dc4-4501-48da-ad18-7a4e744bb9f2	03d20c93-55df-48c0-81cb-87feb2d34425	2021-09-28 17:28:37.067-05	26	ketsinhaake	admin	t	t	f	f	\N
1	fae81dc4-4501-48da-ad18-7a4e744bb9f2	191fd27f-36d2-41a9-877e-6fe0bbd67e08	2021-09-28 16:38:42.346-05	2	ketsinhaake	admin	t	t	f	f	\N
3	fae81dc4-4501-48da-ad18-7a4e744bb9f2	06d69342-f9dc-4b31-8c12-a7e1a29dfac9	2021-09-28 16:40:15.041-05	4	ketsinhaake	admin	t	t	f	f	\N
38	fae81dc4-4501-48da-ad18-7a4e744bb9f2	121ca3a1-1937-4c63-8d5b-563439b2b8f1	2021-10-01 17:46:45.527-05	40	ketsinhadake	ketsinhadake	t	t	f	f	\N
35	fae81dc4-4501-48da-ad18-7a4e744bb9f2	7be349bf-d5e6-4617-9403-96105da9a0c0	2021-10-01 17:42:45.749-05	37	ketsinhadake	ketsinhadake	t	t	f	f	\N
63	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ff1aefe2-8545-4acd-a1e5-5f117e97e9f1	2021-10-02 17:35:18.218-05	64	ketsinhadake	ketsinhadake	t	t	f	f	\N
64	fae81dc4-4501-48da-ad18-7a4e744bb9f2	8c50480a-670f-4a09-abc8-27a67a9fee6f	2021-10-02 17:36:47.27-05	65	ketsinhadake	ketsinhadake	t	t	f	f	\N
104	fae81dc4-4501-48da-ad18-7a4e744bb9f2	03f6a333-a9ab-43ea-91d3-ba3319d8ce3b	2021-10-04 16:42:25.622-05	104	ketsinhadake	ketsinhadake	t	t	f	f	\N
117	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b3a551fd-3510-4920-8cc4-15647cb230a3	2021-11-18 10:20:36.764-06	116	ketsinhadake	ketsinhadake	t	t	f	f	\N
140	fae81dc4-4501-48da-ad18-7a4e744bb9f2	3f7de03e-570f-4542-8035-265e8911fe9b	2022-08-02 00:04:54.962-05	138	ketsinhadake	ketsinhadake	t	t	f	f	\N
144	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5959421e-938a-4846-abc7-3e1bc6ff8bda	2022-08-02 21:09:10.58-05	142	ketsinhadake	ketsinhadake	t	t	f	f	\N
132	fae81dc4-4501-48da-ad18-7a4e744bb9f2	db857419-4b43-422a-b408-c3bc18577d46	2022-08-01 23:52:48.216-05	130	ketsinhadake	ketsinhadake	t	t	f	f	\N
141	fae81dc4-4501-48da-ad18-7a4e744bb9f2	648bdbdf-f567-4c6f-ba5d-8b957713a77b	2022-08-02 00:07:04.757-05	139	ketsinhadake	ketsinhadake	t	t	f	f	\N
59	fae81dc4-4501-48da-ad18-7a4e744bb9f2	06382b03-60a3-4e7f-b20f-28c6ce40b408	2021-10-02 17:29:03.331-05	60	ketsinhadake	ketsinhadake	t	t	f	f	\N
48	fae81dc4-4501-48da-ad18-7a4e744bb9f2	95bf353a-9209-423e-aa18-a1f7913e8a01	2021-10-01 18:07:06.598-05	50	ketsinhadake	ketsinhadake	t	t	f	f	\N
40	fae81dc4-4501-48da-ad18-7a4e744bb9f2	533e8a7d-b766-4e3a-bc73-33aa258d5ebc	2021-10-01 17:56:20.689-05	42	ketsinhadake	ketsinhadake	t	t	f	f	\N
42	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5785f80a-8f03-43a1-907e-e076b8b69a17	2021-10-01 17:59:06.778-05	44	ketsinhadake	ketsinhadake	t	t	f	f	\N
56	fae81dc4-4501-48da-ad18-7a4e744bb9f2	23a3da0e-c1ec-41ae-a4f4-465466b269db	2021-10-01 18:24:11.117-05	57	ketsinhadake	ketsinhadake	t	t	f	f	\N
57	fae81dc4-4501-48da-ad18-7a4e744bb9f2	0cd2d0c2-d8bd-4c02-961f-b5224112d7c3	2021-10-02 17:18:59.144-05	58	ketsinhadake	ketsinhadake	t	t	f	f	\N
75	fae81dc4-4501-48da-ad18-7a4e744bb9f2	bb708383-4ee3-468d-bd57-5a3654d54cfe	2021-10-02 17:54:18.48-05	75	ketsinhadake	ketsinhadake	t	t	f	f	\N
70	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c0d56c4c-26ab-4149-a9a0-7a24b7bacdb8	2021-10-02 17:49:12.154-05	71	ketsinhadake	ketsinhadake	t	t	f	f	\N
72	fae81dc4-4501-48da-ad18-7a4e744bb9f2	7ed287bf-ffea-4f2b-88db-a2636f179feb	2021-10-02 17:51:34.557-05	72	ketsinhadake	ketsinhadake	t	t	f	f	\N
52	fae81dc4-4501-48da-ad18-7a4e744bb9f2	a9379528-308f-48f9-b3ab-ad708da8163c	2021-10-01 18:14:11.44-05	87	ketsinhadake	ketsinhadake	t	t	f	f	\N
120	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ff6ce1eb-9657-4a19-9e05-d39d535107f8	2022-01-30 21:17:32.637-06	119	ketsinhadake	ketsinhadake	t	t	f	f	\N
114	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d65e2019-ee45-4d30-8c0d-00cbf981c6ea	2021-10-13 22:05:46.064-05	113	ketsinhadake	ketsinhadake	t	t	f	f	\N
110	fae81dc4-4501-48da-ad18-7a4e744bb9f2	14d1764e-b841-48aa-b39f-faee41ec145c	2021-10-05 12:06:27.338-05	109	ketsinhadake	ketsinhadake	t	t	f	f	\N
97	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5adca0c9-9144-4d02-beb6-c16822c1a9d4	2021-10-03 15:24:51.717-05	97	ketsinhadake	ketsinhadake	t	t	f	f	\N
67	fae81dc4-4501-48da-ad18-7a4e744bb9f2	bfedb7bb-a2a6-44d6-b093-b3338dcedf68	2021-10-02 17:44:16.453-05	68	ketsinhadake	ketsinhadake	t	t	f	f	\N
65	fae81dc4-4501-48da-ad18-7a4e744bb9f2	45ff7630-6581-4aa7-b01e-b7b035bd134a	2021-10-02 17:38:27.696-05	66	ketsinhadake	ketsinhadake	t	t	f	f	\N
84	fae81dc4-4501-48da-ad18-7a4e744bb9f2	384d627f-9648-4767-9346-273293822ed4	2021-10-02 18:09:12.898-05	84	ketsinhadake	ketsinhadake	t	t	f	f	\N
94	fae81dc4-4501-48da-ad18-7a4e744bb9f2	4cb4774f-7394-4065-b75a-36b0cb28a90a	2021-10-03 14:59:39.421-05	94	ketsinhadake	ketsinhadake	t	t	f	f	\N
156	fae81dc4-4501-48da-ad18-7a4e744bb9f2	6f49e756-f0a4-41aa-8064-7ae0a286fb81	2022-09-22 00:06:51.768-05	153	ketsinhadake	ketsinhadake	t	t	f	f	\N
135	fae81dc4-4501-48da-ad18-7a4e744bb9f2	bf88bdf1-9250-4aba-a5d0-9d463529f1f2	2022-08-01 23:56:44.41-05	133	ketsinhadake	ketsinhadake	t	t	f	f	\N
98	fae81dc4-4501-48da-ad18-7a4e744bb9f2	83017210-d0e5-4d28-bc2a-2952831453b7	2021-10-04 16:25:35.526-05	98	ketsinhadake	ketsinhadake	t	t	f	f	\N
100	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ea3a3c46-e022-4e80-a4e1-ba78fc86d0d2	2021-10-04 16:31:06.347-05	100	ketsinhadake	ketsinhadake	t	t	f	f	\N
96	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f9ed685a-1af6-4883-a1f1-2424254ac7b9	2021-10-03 15:24:48.52-05	96	ketsinhadake	ketsinhadake	t	t	f	f	\N
95	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c03235bd-885a-422f-8dcb-50bf0e3d8a5b	2021-10-03 15:05:29.881-05	95	ketsinhadake	ketsinhadake	t	t	f	f	\N
80	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d3e9f1c8-acff-42da-afbf-f77f404bfbeb	2021-10-02 18:03:37.759-05	80	ketsinhadake	ketsinhadake	t	t	f	f	\N
81	fae81dc4-4501-48da-ad18-7a4e744bb9f2	0f8e9407-e802-402e-be80-d0045fea790b	2021-10-02 18:04:37.848-05	81	ketsinhadake	ketsinhadake	t	t	f	f	\N
91	fae81dc4-4501-48da-ad18-7a4e744bb9f2	363ea7b0-b719-4a5b-8415-b3724bab94f5	2021-10-02 18:17:09.595-05	91	ketsinhadake	ketsinhadake	t	t	f	f	\N
160	fae81dc4-4501-48da-ad18-7a4e744bb9f2	7eb42afd-4132-42e0-a11e-904716a75d3f	2022-10-03 12:43:45.93-05	157	ketsinhadake	ketsinhadake	t	t	f	f	\N
147	fae81dc4-4501-48da-ad18-7a4e744bb9f2	aa5aa30f-42ff-4288-98ea-9eb1b9b8ebca	2022-08-02 21:19:41.381-05	145	ketsinhadake	ketsinhadake	t	t	f	f	\N
148	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b03ad9f8-30b8-4925-a41b-9eba79f4c1ea	2022-08-02 21:23:20.074-05	146	ketsinhadake	ketsinhadake	t	t	f	f	\N
119	fae81dc4-4501-48da-ad18-7a4e744bb9f2	982a392f-1e01-4e13-bb98-afe0bf5652ed	2021-11-18 10:23:38.906-06	118	ketsinhadake	ketsinhadake	t	t	f	f	\N
113	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f03d2a10-69e7-4511-882a-480a79f44bc8	2021-10-13 22:05:36.288-05	112	ketsinhadake	ketsinhadake	t	t	f	f	\N
124	fae81dc4-4501-48da-ad18-7a4e744bb9f2	a6de2efb-70bd-4a0c-a4fa-37362bee1628	2022-08-01 23:27:34.396-05	122	ketsinhadake	ketsinhadake	t	t	f	f	\N
128	fae81dc4-4501-48da-ad18-7a4e744bb9f2	9efdd5fd-df94-4fa4-9fb9-0294caffc5d5	2022-08-01 23:44:46.584-05	126	ketsinhadake	ketsinhadake	t	t	f	f	\N
107	fae81dc4-4501-48da-ad18-7a4e744bb9f2	d1bfe8e6-2900-4ae8-b1e8-3eb028d0900b	2021-10-05 11:54:49.69-05	106	ketsinhadake	ketsinhadake	t	t	f	f	\N
109	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f7330d90-2f92-4186-a993-53839f46e354	2021-10-05 12:04:06.286-05	108	ketsinhadake	ketsinhadake	t	t	f	f	\N
32	fae81dc4-4501-48da-ad18-7a4e744bb9f2	de2d802f-7b48-49fa-9d6d-31198a496d0e	2021-10-01 17:28:50.739-05	34	ketsinhadake	ketsinhadake	t	t	f	f	\N
11	fae81dc4-4501-48da-ad18-7a4e744bb9f2	e9a9a15e-b2d5-41b4-9614-69b697cc00bb	2021-09-28 16:51:58.364-05	12	ketsinhaake	admin	t	t	f	f	\N
7	fae81dc4-4501-48da-ad18-7a4e744bb9f2	fc65be5c-18dc-434f-903b-6f6bd743ce1e	2021-09-28 16:42:47.016-05	8	ketsinhaake	admin	t	t	f	f	\N
10	fae81dc4-4501-48da-ad18-7a4e744bb9f2	2a178050-306c-4ae3-ad06-c3d895391872	2021-09-28 16:49:49.203-05	11	ketsinhaake	admin	t	t	f	f	\N
137	fae81dc4-4501-48da-ad18-7a4e744bb9f2	488d7595-bb82-4b85-96ff-dd755e8fbd74	2022-08-01 23:58:48.107-05	135	ketsinhadake	ketsinhadake	t	t	f	f	\N
134	fae81dc4-4501-48da-ad18-7a4e744bb9f2	699176f9-2879-4329-8096-d29864e3e350	2022-08-01 23:55:52.573-05	132	ketsinhadake	ketsinhadake	t	t	f	f	\N
136	fae81dc4-4501-48da-ad18-7a4e744bb9f2	6b289983-1e71-444b-be4d-9dd744ec0817	2022-08-01 23:57:20.791-05	134	ketsinhadake	ketsinhadake	t	t	f	f	\N
138	fae81dc4-4501-48da-ad18-7a4e744bb9f2	6a7d2d43-421b-4cd8-8209-491892b7e2c6	2022-08-02 00:01:42.1-05	136	ketsinhadake	ketsinhadake	t	t	f	f	\N
142	fae81dc4-4501-48da-ad18-7a4e744bb9f2	f2ba5eeb-39a7-4270-8133-028fa25f49af	2022-08-02 00:09:32.367-05	140	ketsinhadake	ketsinhadake	t	t	f	f	\N
116	fae81dc4-4501-48da-ad18-7a4e744bb9f2	48565ba7-bff2-4de2-a1b9-8c99e28b9dbc	2021-10-13 22:06:23.377-05	115	ketsinhadake	ketsinhadake	t	t	f	f	\N
125	fae81dc4-4501-48da-ad18-7a4e744bb9f2	b7b5762b-9f4e-4a60-ace7-8a33dafba63b	2022-08-01 23:39:32.974-05	123	ketsinhadake	ketsinhadake	t	t	f	f	\N
101	fae81dc4-4501-48da-ad18-7a4e744bb9f2	9360ac97-f383-4514-b107-9225a949a53c	2021-10-04 16:32:26.591-05	101	ketsinhadake	ketsinhadake	t	t	f	f	\N
78	fae81dc4-4501-48da-ad18-7a4e744bb9f2	c2d9a42a-6732-4ad0-9a8f-57cd3784397f	2021-10-02 17:59:47.412-05	78	ketsinhadake	ketsinhadake	t	t	f	f	\N
82	fae81dc4-4501-48da-ad18-7a4e744bb9f2	428acc25-f3a5-4927-a70f-92fd4ab46991	2021-10-02 18:06:50.317-05	82	ketsinhadake	ketsinhadake	t	t	f	f	\N
88	fae81dc4-4501-48da-ad18-7a4e744bb9f2	14d0b431-d04c-40df-81d0-f6c8d79ab429	2021-10-02 18:16:19.012-05	88	ketsinhadake	ketsinhadake	t	t	f	f	\N
89	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ff298205-8cd5-4389-86e9-ca058196266f	2021-10-02 18:16:34.065-05	89	ketsinhadake	ketsinhadake	t	t	f	f	\N
150	fae81dc4-4501-48da-ad18-7a4e744bb9f2	fb65b3ae-c76b-4891-a4d0-10aa56232056	2022-08-31 09:07:34.876-05	148	ketsinhadake	ketsinhadake	t	t	f	f	\N
145	fae81dc4-4501-48da-ad18-7a4e744bb9f2	29d728a0-67b6-4b31-8a61-62dbbf20c6d3	2022-08-02 21:09:22.962-05	143	ketsinhadake	ketsinhadake	t	t	f	f	\N
149	fae81dc4-4501-48da-ad18-7a4e744bb9f2	6d738297-136a-472e-95cc-638e4fbebe46	2022-08-02 21:24:17.766-05	147	ketsinhadake	ketsinhadake	t	t	f	f	\N
152	fae81dc4-4501-48da-ad18-7a4e744bb9f2	5e6c58be-9d15-460c-9bdf-899cca9b77f8	2022-09-06 16:53:13.252-05	149	ketsinhadake	ketsinhadake	t	t	f	f	\N
4	fae81dc4-4501-48da-ad18-7a4e744bb9f2	ee4cfbbc-2725-4558-b218-d8ab5c3a2dbd	2021-09-28 16:40:22.989-05	5	ketsinhaake	admin	t	t	f	f	\N`

const plfile = fs.readFileSync('ketsin.kmplaylist', 'utf-8');
const pl = JSON.parse(plfile);

const oldpl = pldata.replace('\\N','').split('\n');
const newpl = [];
for (const plc of oldpl) {
	const data = plc.split('\t');
	newpl.push({
		kid: data[2],
		username: data[5],
		nickname: data[6],
		pos: data[4],
		flag_visible: "true"
	});
}

pl.PlaylistContents = newpl;
fs.writeFileSync('ketsin.kmplaylist', JSON.stringify(pl, null, 2), 'utf-8');

From there reimporting the playlist worked.