Opened 5 years ago

Last modified 5 years ago

#12186 new Bug Report - General

Will Not Update Metadata for Recordings

Reported by: merc1984@… Owned by: Raymond Wagner
Priority: minor Milestone: unknown
Component: Bindings - Python Version: 0.27.1
Severity: medium Keywords: metadata
Cc: Ticket locked: no

Description

With TV show naming canonical (Danger Man s01e03 Josetta.mp4), myth Fails To Fetch metadata for any TV show at the reference site. (http://thetvdb.com/?tab=episode&seriesid=76164&seasonid=9786&id=184793&lid=7)

/usr/local/share/mythtv/metadata/Television/ttvdb.py is present and python-mysqldb and mysql-utilities are installed.

2014-06-25 08:47:26.742393 I Running Grabber: /usr/local/share/mythtv -l en -a US -M Danger Man 2014-06-25 08:47:26.910655 I Metadata Lookup Failed: No Results Danger Man 1 3 2014-06-25 08:47:27.511291 I No results found for Danger Man 1 3

$ ls -al Danger\ Man\ s01e03\ Josetta.mp4 -rwxrwx--- 1 bill mythtv 305210595 May 28 13:24 Danger Man s01e03 Josetta.mp4

Attachments (1)

snap.png (786.2 KB) - added by merc1984@… 5 years ago.
Screenie of metadata sources

Download all attachments as: .zip

Change History (16)

comment:1 in reply to:  description Changed 5 years ago by Raymond Wagner

Replying to merc1984@…:

2014-06-25 08:47:26.742393 I Running Grabber: /usr/local/share/mythtv -l en -a US -M Danger Man

This is an unedited log entry? It's trying to execute a directory as a grabber script? Could you post the mysql output of...

use mythconverg SELECT * FROM settings WHERE value="TelevisionGrabber?";

comment:2 Changed 5 years ago by merc1984@…

Yes this is exactly as it gave me. I was pretty sure that was the problem, but don't know why.

$ mysql --user mythtv -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 233 Server version: 5.5.37-MariaDB-1 (Debian)

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use mythconverg; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed MariaDB [mythconverg]> SELECT * FROM settings WHERE value="TelevisionGrabber??"; Empty set (0.00 sec)

MariaDB [mythconverg]>

Changed 5 years ago by merc1984@…

Attachment: snap.png added

Screenie of metadata sources

comment:3 Changed 5 years ago by merc1984@…

Whups.

MariaDB [mythconverg]> SELECT * FROM settings WHERE value="TelevisionGrabber?"; +-------------------+------+----------+ | value | data | hostname | +-------------------+------+----------+ | TelevisionGrabber? | | NULL | +-------------------+------+----------+ 1 row in set (0.00 sec) MariaDB [mythconverg]>

comment:4 Changed 5 years ago by merc1984@…

Again.

MariaDB [mythconverg]> SELECT * FROM settings WHERE value="TelevisionGrabber?"; +-------------------+------+----------+ | value | data | hostname | +-------------------+------+----------+ | TelevisionGrabber? | | NULL | +-------------------+------+----------+ 1 row in set (0.00 sec) MariaDB [mythconverg]> exit Bye

... And yet... {attachment}

comment:5 Changed 5 years ago by merc1984@…

Idk why it's adding the '?', but it's not there in real life.

comment:6 Changed 5 years ago by merc1984@…

lol, I tried to attach a screenie of my actual Konsole steps, but Trac said, "Submission rejected as potential spam (Akismet says content is spam, StopForumSpam? says this is spam (ip), BlogSpam? says content is spam ( Listed in HTTP;bl), SpamBayes? determined spam probability of 71.47%)"

Fine.

comment:7 Changed 5 years ago by Raymond Wagner

Trac has some logic somewhere that makes guesses at what key words might be useful wiki pages. When there is no wiki page for that word, it adds a question mark.

I'll have to look into how a blank metadata grabber might have been inserted into the database. What specific version are you running?

comment:8 Changed 5 years ago by merc1984@…

According to mythtv/libs/libmythbase/mythversion.h:

#define MYTH_DATABASE_VERSION "1317"

It's worth noting that this is a new disk array, where I saved the database from the old array with: /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c > /home/bill/.mythtv/DB-backups/mysql_backup-$(date +"%Y-%m-%d").sql' ... and restored it with:

$ mysql -u root -p mysql> create database mythconverg; mysql> exit $ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql ... If Access Denied to user mythtv, create a new mythconverg: $ mysql --user=root --password < /usr/local/src/mythtv*/mythtv/database/mc.sql ... -then- restore backup.

MySQL time zone support is missing.

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

comment:9 Changed 5 years ago by merc1984@…

It updates new movie videos just fine, but not TV shows.

comment:10 Changed 5 years ago by merc1984@…

Um, anyone?

comment:11 Changed 5 years ago by Karl Egly

Simplest is likely to manually go to the metadata settings and reselect the TVDB grabber. It is at "Setup"->"Artwork and Data Sources" and should look similar to the screenshot at http://www.mythtv.org/wiki/Enhancing_Recordings_with_Metadata_Lookup#Enabling_Automatic_Artwork_Updates

comment:12 Changed 5 years ago by merc1984@…

Thanks, but as I noted above, that -is- set. (see attachment)

comment:13 Changed 5 years ago by Raymond Wagner

Did you ever actually hit "save" on that screen to reset the selection, or did you just open it up and see that it was the only available selection?

comment:14 Changed 5 years ago by merc1984@…

There --is no-- Save, as can be seen in the screenie. The only option is to back out with <esc>.

comment:15 Changed 5 years ago by merc1984@…

Correction: The Save is in a different place, and Saving does indeed make TV metadata work.

So I guess the bug would be why TheTVdb.com shows up there, but isn't actually saved, contrary to what it appears.

Note: See TracTickets for help on using tickets.