I have a problems, bro - Githubissues

Quasolaris / NewPipePlaylistExtractor

Download your NewPipe created playlists as mp3, wav or other codec and listen to it offline. It is also possible to export the playlists as CSV, M3U8 or other text formats.

GNU General Public License v3.0

18 stars 3 forks source link

I have a problems, bro #3

Closed Djemchik closed 1 year ago

Djemchik commented 1 year ago

Extracting Playlists... Traceback (most recent call last): File "/root/NewPipePlaylistExtractor/Script/main.py", line 262, in main(sys.argv[1]) File "/root/NewPipePlaylistExtractor/Script/main.py", line 192, in main Playlists = getPlaylists(db_file) File "/root/NewPipePlaylistExtractor/Script/main.py", line 105, in getPlaylists rows = get_rows(db_file) File "/root/NewPipePlaylistExtractor/Script/main.py", line 88, in get_rows cur.execute(sqlCmds) sqlite3.OperationalError: no such table: streams

Quasolaris commented 1 year ago

Can you write how you run the script, that I can replicate.

Is the path to the newpipe.db file correct? I can replicate the error when I give a wrong path as argument.

Djemchik commented 1 year ago

Thi link of my file database is here

When i am using him, i will have a error

http://file.sampo.ru/4j8375/

Quasolaris commented 1 year ago

I'm not downloading your file, sorry.

I tested the script with a new generated database via the newest NewPipe version and it worked fine on my machine.

The line sqlite3.OperationalError: no such table: streams tells me that it does not find any playlists in your DB-File, I can see two possible reasons for that:

Did you extract the file?
- The script can not extract your playlists when you give it the .zip as path, you need to give the newpipe.db as an argument.
Maybe it could also be that you use some special characters in your playlist names?
- It could be that the SQL-Lib I use can not handle special characters.

Djemchik commented 1 year ago

I am trying to download this playlist

https://youtube.com/playlist?list=PLOAFzRws139CoGX2UvsGx5yWplrxBB6Hh

Quasolaris commented 1 year ago

The script is made for playlists that are created using NewPipe, means that the playlists do not share a YouTube-Link, they are locally created on your device and therefore inside the SQL database.

Can it be that you have only YouTube-created playlists saved in your NewPipe? If yes then the newpipe.db file can be empty and that is why you get that error.

To download playlists that are created using YouTube (with a YT-Account) is not possible with this script (at the moment), you could use something like PyTube or look for a YouTube downloader.