[mythtv-users] New Version: 1.4 Bulk Updater for Videometa(imdb) data

Anthony Giggins seven at seven.dorksville.net
Mon Sep 24 02:59:06 UTC 2007


>>>>>
>>>>>>
>>>>>> I have noticed a few oddities with running the following command:
>>>>>> /home/mythtv/imdbupdater/imdb-bulk-update.pl -N -Fileup -Exclude
>>>>>> The .m2v files for some reason these are continually being marked as
>>>>>> new
>>>>>> files?
>>>>>>
>>>>>> Even though I can see them in the db.
>>>>>
>>>>>
>>>>> Hmm. I can't see to find anything in the code that would cause this.
>>>>>
>>>>> Give me 2 things. One of the at fault filenames with the full path
>>>>> /movies/etc/etc/filensame.m2v
>>>>>
>>>>> And then give me the output from this:
>>>>>
>>>>> echo select extension, f_ignore from videotypes\; | mysql -umythtv
>>>>> -pmythtv mythconverg
>>>>>
>>>>> This assumes that your user/pass and db are the defaults of course.
>>>>>
>>>>> Ryan
>>>>
>>>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v
>>>>
>>>>
>>>> | extension | f_ignore |
>>>> +-----------+----------+
>>>> | txt       |        1 |
>>>> | log       |        1 |
>>>> | mpg       |        0 |
>>>> | avi       |        0 |
>>>> | vob       |        0 |
>>>> | mpeg      |        0 |
>>>> | VIDEO_TS  |        0 |
>>>> | iso       |        0 |
>>>> | img       |        0 |
>>>> | rmvb      |        0 |
>>>> | jpg       |        1 |
>>>> | png       |        1 |
>>>> | gif       |        1 |
>>>> | cue       |        1 |
>>>> | sub       |        1 |
>>>> | srt       |        1 |
>>>> | dat       |        1 |
>>>> | mp4       |        0 |
>>>> | m2v       |        0 |
>>>> +-----------+----------+
>>>> 19 rows in set (0.00 sec)
>>>>
>>>> Thanks Anthony
>>>>
>>>
>>>
>>> Ok. Nothing looks out of sorts there. Can you tell me what the output
>>> of
>>> this is:
>>>
>>> select * from videometadata where filename like "%A Perfect Circle%"
>>
>> Ahhh its also inserting it into the Database multiple times
>>
>> +-------+--------------------------------+----------+---------+--------+----------+------+------------+--------+-----------+------------------------------------------------------------------------+-----------+---------+--------+-------------+----------+
>> | intid | title                          | director | plot    | rating |
>> inetref  | year | userrating | length | showlevel | filename
>>                                                 | coverfile | childid |
>> browse | playcommand | category |
>> +-------+--------------------------------+----------+---------+--------+----------+------+------------+--------+-----------+------------------------------------------------------------------------+-----------+---------+--------+-------------+----------+
>> |   816 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   706 | A Perfect Circle - Passive.m2v | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   808 | A Perfect Circle - Passive.m2v | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   821 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   853 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   963 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   968 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   980 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   975 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   987 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |   992 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1013 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1028 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1033 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1038 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1043 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1048 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1053 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1058 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1063 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1068 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1073 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> |  1078 | A Perfect Circle - Passive     | Unknown  | Unknown | NR     |
>> 99999999 | 1895 |          0 |      0 |         0 |
>> /storage/videos/movies/music videos/DVD/A Perfect Circle - Passive.m2v |
>> No Cover  |      -1 |      1 | NULL        |        0 |
>> +-------+--------------------------------+----------+---------+--------+----------+------+------------+--------+-----------+------------------------------------------------------------------------+-----------+---------+--------+-------------+----------+
>> 23 rows in set (0.01 sec)
>>
>>
>
> Anthony --
> I think I found the issue. When I do the sort I use a hash to compare the
> files already in the DB and those that are on the Filesystem. In doing so
> the comparison I am making does a if the count is != 2, then we'll add it.
> Here is my mistake, I made the assumption that for any given title only 1
> entry would exist in the DB.
>
> I expect that your videometadata table actually had more than 1 entry
> listed for this particular file, so the comparison of the files was not
> equal to 2, it may have been 3 or 4 or now 23..... so everytime this check
> is true and again adds it to the DB.
>
> I'm going to fix this check to make it >= instead which should prevent
> this from happening for everyone. To get this entry out of your DB, I'd
> say rename this file, and re-run the -Fileup for now. This should clean up
> that particular entry.
>
> I'll fix the script and post a new version shortly.
>
> Ryan
>
>


here are some comments from another user which I also had some issues with

http://www.gossamer-threads.com/lists/mythtv/users/291665?search_string=include%20in%20myth%20the%20videos%20cast;#291665



More information about the mythtv-users mailing list