search

woefe / ytcc

Command line tool to keep track of your favorite playlists on YouTube and many other places.
GNU General Public License v3.0
178 stars 20 forks source link

there are some bugs i dont know how to call them #112

Closed ghost closed 1 year ago

ghost commented 1 year ago

Describe the bug firstly i dont know why there is only 100 videos while it should have been more videos, also I can open specific playlist and watch from there also update does not work too

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior work Environment, configuration and version information arch linux 6.1.3 ytcc 2.6.1-1 from aur

--ytcc version---
2.6.1

---youtube-dl version---
2021.12.17

---yt-dlp version---
2023.01.06

---Click version---
8.1.3

---SQLite version---
SQLite system library version: 3.40.1
Python module version: 2.6.0

---python version---
3.10.9 (main, Dec 19 2022, 17:35:49) [GCC 12.2.0]

---mpv version---
mpv 0.35.0 Copyright © 2000-2022 mpv/MPlayer/mplayer2 projects
 built on UNKNOWN
FFmpeg library versions:
   libavutil       57.28.100
   libavcodec      59.37.100
   libavformat     59.27.100
   libswscale      6.7.100
   libavfilter     8.44.100
   libswresample   4.7.100
FFmpeg version: n5.1.2

---config dump---
[ytcc]
download_dir = ~/Downloads
download_subdirs = false
mpv_flags = --profile=low-latency --hwdec=vaapi --audio-pitch-correction=yes --really-quiet  --ytdl-format=bestvideo[height=720][vcodec=h264][fps<=30]+bestaudio/best
order_by = playlists:asc, publish_date:desc, id:asc
video_attrs = id, title, publish_date, duration, playlists
playlist_attrs = name, url, tags, reverse
db_path = ~/.local/share/ytcc/ytcc.db
date_format = %d-%m-%Y
max_update_fail = 5
max_update_backlog = 20
age_limit = 0

[tui]
alphabet = sdfervghnuiojkl
default_action = play_video

[theme]
prompt_download_audio = 2
prompt_download_video = 4
prompt_play_audio = 2
prompt_play_video = 4
prompt_mark_watched = 1
table_alternate_background = 245
plain_label_text = 244

[youtube_dl]
format = bestvideo[height=720][vcodec=h264][fps<=30]+bestaudio/best
output_template = %(title)s.%(ext)s
ratelimit = 0
retries = 0
subtitles = off
thumbnail = true
skip_live_stream = true
merge_output_format = mkv
max_duration = 0
restrict_filenames = false ``` 

**Debug log (optional)**
Enable the debug logging and run buggy command again. Note, that this can print sensitive information!
 [1673071411.392330] [MainProcess/MainThread] ytcc.config.DEBUG: Trying to read config from following locations: [PosixPath('/etc/ytcc/ytcc.conf'), PosixPath('/home/t0prak/.config/ytcc/ytcc.conf'), PosixPath('/home/t0prak/.ytcc.conf')]
[1673071411.393214] [MainProcess/MainThread] ytcc.config.DEBUG: Config was read from following locations: ['/home/t0prak/.config/ytcc/ytcc.conf']
[1673071411.395283] [MainProcess/MainThread] ytcc.database.DEBUG: PRAGMA foreign_keys = ON;
[1673071411.395420] [MainProcess/MainThread] ytcc.database.DEBUG: PRAGMA user_version;
[1673071411.395708] [MainProcess/MainThread] asyncio.DEBUG: Using selector: EpollSelector
[1673071411.396277] [MainProcess/MainThread] ytcc.database.DEBUG: SELECT p.id AS id, p.name AS name, p.url AS url, p.reverse AS reverse, t.name AS tag FROM playlist AS p LEFT OUTER JOIN tag AS t ON p.id = t.playlist;
[1673071411.396916] [MainProcess/MainThread] ytcc.database.DEBUG: WITH ids as ( SELECT v.id FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id LEFT JOIN tag AS t ON p.id = t.playlist WHERE v.publish_date > 0 AND v.publish_date < Inf AND p.name IN ('TYT MAT') ) SELECT v.id AS id, v.title AS title, v.url AS url, v.description AS description, v.duration AS duration, v.publish_date AS publish_date, v.watch_date AS watch_date, v.thumbnail_url AS thumbnail_url, v.extractor_hash AS extractor_hash, p.name AS playlist_name, p.url AS playlist_url, p.reverse AS playlist_reverse FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id WHERE v.id in ids
[1673071411.824887] [MainProcess/MainThread] ytcc.updater.INFO: Checking playlist 'TYT MAT'...
[1673071411.833633] [MainProcess/MainThread] ytcc.database.DEBUG: WITH ids as ( SELECT v.id FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id LEFT JOIN tag AS t ON p.id = t.playlist WHERE v.publish_date > 0 AND v.publish_date < Inf AND p.name IN ('TYT Kimya') ) SELECT v.id AS id, v.title AS title, v.url AS url, v.description AS description, v.duration AS duration, v.publish_date AS publish_date, v.watch_date AS watch_date, v.thumbnail_url AS thumbnail_url, v.extractor_hash AS extractor_hash, p.name AS playlist_name, p.url AS playlist_url, p.reverse AS playlist_reverse FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id WHERE v.id in ids
[1673071412.071107] [MainProcess/MainThread] ytcc.updater.INFO: Checking playlist 'TYT Kimya'...
[1673071412.075775] [MainProcess/MainThread] ytcc.database.DEBUG: WITH ids as ( SELECT v.id FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id LEFT JOIN tag AS t ON p.id = t.playlist WHERE v.publish_date > 0 AND v.publish_date < Inf AND p.name IN ('TYT Biyo') ) SELECT v.id AS id, v.title AS title, v.url AS url, v.description AS description, v.duration AS duration, v.publish_date AS publish_date, v.watch_date AS watch_date, v.thumbnail_url AS thumbnail_url, v.extractor_hash AS extractor_hash, p.name AS playlist_name, p.url AS playlist_url, p.reverse AS playlist_reverse FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id WHERE v.id in ids
[1673071412.217267] [MainProcess/MainThread] ytcc.updater.INFO: Checking playlist 'TYT Biyo'...
[1673071412.219713] [MainProcess/MainThread] ytcc.database.DEBUG: WITH ids as ( SELECT v.id FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id LEFT JOIN tag AS t ON p.id = t.playlist WHERE v.publish_date > 0 AND v.publish_date < Inf AND p.name IN ('TYT TR') ) SELECT v.id AS id, v.title AS title, v.url AS url, v.description AS description, v.duration AS duration, v.publish_date AS publish_date, v.watch_date AS watch_date, v.thumbnail_url AS thumbnail_url, v.extractor_hash AS extractor_hash, p.name AS playlist_name, p.url AS playlist_url, p.reverse AS playlist_reverse FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id WHERE v.id in ids
[1673071412.361518] [MainProcess/MainThread] ytcc.updater.INFO: Checking playlist 'TYT TR'...
[1673071412.365935] [MainProcess/MainThread] ytcc.database.DEBUG: WITH ids as ( SELECT v.id FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id LEFT JOIN tag AS t ON p.id = t.playlist WHERE v.publish_date > 0 AND v.publish_date < Inf AND p.name IN ('GEO') ) SELECT v.id AS id, v.title AS title, v.url AS url, v.description AS description, v.duration AS duration, v.publish_date AS publish_date, v.watch_date AS watch_date, v.thumbnail_url AS thumbnail_url, v.extractor_hash AS extractor_hash, p.name AS playlist_name, p.url AS playlist_url, p.reverse AS playlist_reverse FROM video AS v JOIN content c ON v.id = c.video_id JOIN playlist p ON p.id = c.playlist_id WHERE v.id in ids
[1673071412.512889] [MainProcess/MainThread] ytcc.updater.INFO: Checking playlist 'GEO'...
[1673071413.333955] [MainProcess/MainThread] ytcc.database.DEBUG: SELECT failure_count FROM extractor_meta WHERE extractor_hash = 'youtube eb5eiUumqYY'

Add any other context about the problem here.
woefe commented 1 year ago

ytcc by default only checks the first 20 videos per playlist. Increase max_update_backlog in your config if you want more. Note that ytcc update becomes slow if you increase that number too much. You can also run ytcc update --max-backlog=1000 once to fetch older videos.

See ytcc update --help and the README.md