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

[Anthony Giggins]

>>>
>>>>
>>>> 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)