Metadata Fetch: [PLAYLIST URL] failed: An error occurred (no such column: live_status) while trying to connect to the database.

[holta]

Thanks @EMG70 for having reported this:

A new error has appeared whilst trying to do a demo to a new IIAB user.This playlist in particular, https://www.youtube.com/playlist?list=PLqxP5EuGxPncYWWc1cXlcuhfcoo3Wl3Ru

Metadata Fetch: [https://www.youtube.com/playlist?list=PLqxP5EuGxPncYWWc1cXlcuhfcoo3Wl3Ru] failed: An error occurred (no such column: live_status) while trying to connect to the database.

sudo iiab-diagnostics:
https://dpaste.com/EEE2QXLJB

Error details from https://dpaste.com/EEE2QXLJB#line-1911 :

[2024-07-20 17:03:48,505] ERROR {cps.services.worker:202} no such column: error
Traceback (most recent call last):
  File "/usr/local/calibre-web-py3/cps/services/worker.py", line 199, in start
    self.run(*args)
  File "/usr/local/calibre-web-py3/cps/tasks/metadata_extract.py", line 172, in run
    elif error_message := conn.execute("SELECT error FROM media WHERE ? LIKE '%' || extractor_id || '%'", (self.media_url,)).fetchone()[0]:
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: no such column: error

Potentially related:

• (1) download.py: "sqlite3.OperationalError: no such column: error" after "TypeError: 'NoneType' object is not subscriptable" (2) editbooks.py: SAWarning: Object of type <Books> not in session, add operation along 'Authors.books' won't proceed #186
• Formerly live videos fail to download: "failed to download [download] ... does not pass filter (live_status=?not_live); skipping" #188
• Add --live flag to support downloading of "live" videos #199
• PR Adjust message for formerly "live" videos #211
• Prevent [upcoming and truly live YouTube] videos from carrying over [to] subsequent download tasks [& discussion of UTC for code safety — avoid TZ code complexity wherever possible!?] #212
• Formerly live https://youtu.be/4BL65HElOPg fails to download [same "no such column: error" issue as #186 ?] [unavailable fragments?] #215
• PR Adjust error message for stuck/slow videos [if elapsed_time >= timeout, e.g. due to unavailable fragments &/or xklb media_check] #223

[holta]

@EMG70 clarifies:

The same video playlist https://www.youtube.com/playlist?list=PLqxP5EuGxPncYWWc1cXlcuhfcoo3Wl3Ru downloads OK when done directly via yt-dlp, it is not a live playlist or denotated as such on Youtube.

[holta]

@EMG70 can you please confirm this is now solved?

(Like #215, @deldesir believes it should have been resolved 5+ weeks ago by...)

• PR Ensure error and live_status columns are created from the start #191

[EMG70]

calibre-web(2).log
I have just tried ,all is now working.Apologies for late follow up.