Will Not Update Metadata for Recordings

[merc1984@…]

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

[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";

[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]>

[merc1984@…]

Screenie of metadata sources

[merc1984@…]

Whups.

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

[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}

[merc1984@…]

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

[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.

[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?

[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

[merc1984@…]

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

[merc1984@…]

Um, anyone?

[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

[merc1984@…]

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

[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?

[merc1984@…]

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

[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.

[Stuart Auchterlonie]

Closing out old tickets. Likely fixed to the switch to the new API