[Solved] MythVideo metadata lookup not working in 31

[Bragor]

Hi there,
I am having trouble with the metadata lookup in MythVideo in Mythtv 31 running ubuntu 20.04.
I see in the log that mythtv tries for example this

Code: Select all

Running Grabber: /usr/share/mythtv/metadata/Television/ttvdb.py -l en -a DE -N 7th Heaven Anything You Want

and doesn't get any results

Code: Select all

XMLParseBase: Parent is NULL

When I run the same from the command line I don't get any results either.
However when I run

Code: Select all

/usr/share/mythtv/metadata/Television/ttvdb.py -l en -a DE -N "7th Heaven" "Anything You Want"

from the command line, I get the needed results.
So my question is: Is this an error in the mythtv metadata lookup or did I configure anything wrong? How can I change this behavior?
Any help is very appreciated!

[dnalorernst]

The log message "Running Grabber" is missing some quotes, but the command returns data if no other error messages are shown in the log.
The Error "XMLParseBase: Parent is NULL" is related to the gui.
Did you trigger the metadata-lookup via the GUI of the frontend?
If so please run the frontend with

Code: Select all

--verbose general,gui,file --loglevel info

and look for errors like

Code: Select all

"No theme file ...."

If above error popped up, try another theme.

[Bragor]

I ran it via the GUI of the frontend. I repeated it with your suggested switches and I got:

Code: Select all

2020-06-28 20:46:03.671106 I  Running Grabber: /usr/share/mythtv/metadata/Television/ttvdb.py -l en -a DE -N 7th Heaven Anything You Want
2020-06-28 20:46:04.622799 I  Running Grabber: /usr/share/mythtv/metadata/Television/ttvdb.py -l en -a DE -M 7th Heaven
2020-06-28 20:46:05.574905 I  RemoteFile::Exists(): looking for remote file: myth://Videos@homeserver1/Eltern/7th Heaven/Season 01/7th Heaven 1x01 Anything you want.mxml
2020-06-28 20:46:05.576929 I  RemoteFile::Exists(): looking for remote file: myth://Videos@homeserver1/Eltern/7th Heaven/Season 01/7th Heaven 1x01 Anything you want.nfo
2020-06-28 20:46:05.675415 I  Running Grabber: /usr/share/mythtv/metadata/Movie/tmdb3.py -l en -a DE -M 7th Heaven
2020-06-28 20:46:05.825600 I  RemoteFile::Exists(): looking for remote file: myth://Videos@homeserver1/Eltern/7th Heaven/Season 01/7th Heaven 1x01 Anything you want.mxml
2020-06-28 20:46:05.827938 I  RemoteFile::Exists(): looking for remote file: myth://Videos@homeserver1/Eltern/7th Heaven/Season 01/7th Heaven 1x01 Anything you want.nfo
2020-06-28 20:46:05.925925 I  Running Grabber: /usr/share/mythtv/metadata/Movie/tmdb3.py -l en -a DE -M 7th Heaven
2020-06-28 20:46:06.075889 I  Metadata Lookup Failed: No Results 7th Heaven 1 1
2020-06-28 20:46:06.076801 I  No results found for 7th Heaven 1 1

[dnalorernst]

Fetching episode data of a TV series in MythVideo works for me (v31):
either
- with 'M' 'Search for changes'
- and 'W'
or with 'I'
- 'Fetch video data'

Note: translations may be not exact.

The only difference is, that the German language, and Country = US is used during lookup

Code: Select all

 ttvdb.py -l de -a US -N .....

and I did it on a series made in Austria.

Please post the output of

Code: Select all

$ locale

and the settings of the mysql table

Code: Select all

$ mysql -u mythtv -p<YOUR-PWD> mythconverg
mysql> SELECT * FROM `settings` WHERE `value` LIKE 'country';
mysql> SELECT * FROM `settings` WHERE `value` LIKE 'language';

What does the log of the frontend say at

Code: Select all

(SaveLocaleDefaults) Current locale ........

I will then try to replicate your problem.
Please state, if you changed/rewrote the posted logs in respect to 'Country' and 'Language'.

[Bragor]

Thank you for your help! I tried different combinations of locale and mythtv language settings because I thought it might help - so far no success. These are the current ones:

Code: Select all

$ locale
LANG=de_DE.UTF-8
LANGUAGE=
LC_CTYPE="de_DE.UTF-8"
LC_NUMERIC="de_DE.UTF-8"
LC_TIME="de_DE.UTF-8"
LC_COLLATE="de_DE.UTF-8"
LC_MONETARY="de_DE.UTF-8"
LC_MESSAGES="de_DE.UTF-8"
LC_PAPER="de_DE.UTF-8"
LC_NAME="de_DE.UTF-8"
LC_ADDRESS="de_DE.UTF-8"
LC_TELEPHONE="de_DE.UTF-8"
LC_MEASUREMENT="de_DE.UTF-8"
LC_IDENTIFICATION="de_DE.UTF-8"
LC_ALL=

Code: Select all

mysql> SELECT * FROM `settings` WHERE `value` LIKE 'country';
+---------+------+----------+
| value   | data | hostname |
+---------+------+----------+
| Country | DE   | NULL     |
+---------+------+----------+
1 row in set (0.00 sec)

mysql> SELECT * FROM `settings` WHERE `value` LIKE 'language';
+----------+-------+----------+
| value    | data  | hostname |
+----------+-------+----------+
| Language | en_US | NULL     |
+----------+-------+----------+
1 row in set (0.00 sec)

[dnalorernst]

I still cannot reproduce this failure:
I copied some files to the test server and renamed it accordingly to your setup and did the usual "Scan for changes".
I run the frontend with German locale and English language, like you did:
Logfile:

Code: Select all

I MetadataDownload metadatagrabber.cpp:424 (RunGrabber) Running Grabber: /usr/share/mythtv/metadata/Television/ttvdb.py -l en -a DE -N 7th Heaven Anything you want
I MetadataDownload metadatacommon.cpp:1141 (ParseMetadataItem) Result Found, Season 1 Episode 1
I MetadataDownload metadatadownload.cpp:183 (run) Returning Metadata Results: 7th Heaven 1 1

Please try the following steps:

1) Clear tvdb cache:
Rename the folder '~/.mythtv/cache/tvdb_api3' for the user running the frontend.

2) Please apply a new logging mask

Code: Select all

--verbose general,file,system --loglevel info

and do the metadata grabbing again.
Please post the full log.

3) Since the tmdb3.py did not find anything as well, I suspect that there are some special characters in the title "7th Heaven" like soft blanks or superscript.

In the mysql shell, run

Code: Select all

SELECT title,subtitle,season,episode
FROM videometadata
WHERE title REGEXP BINARY "[^a-zA-Z0-9 ]"
AND season = 1
AND episode = 1;

The query looks for any character in the title *not* shown in the regular expression.
If the above query returns a result with title "7th Heaven", then there are some special characters in the title which the grabber script might not handle correctly.

Do you use MySQL or MariaDB ?

Than you for your patience.

[Bragor]

Sorry it took me so long to answer. I thought I had activated an automatic e-mail in case of a reply, but I didn't. Therefore I didn't notice your reply sooner.
It turns out that removing the cache ~/.mythtv/cache/tvdb_api3 was enough to make it work again. Probably there was something strange in it.
Thanks a lot for your help!

[Steve Goodey]

Hello,

If you're happy with the fix could you possibly added [Solved] to the subject line in the first post?

Ta.