Mailing List Archive

SD JSON - one channel w/o data
I am using tv_grab_zz_sdjson_sqlite and I have one channel (channum
1160) that has no data. About a week ago I noticed and check compared
the xmltvid in the database with the sqlite database and they were
different.

I have updated the xmltv ID in the mythconverg database as follows:

mysql> SELECT chanid, channum, xmltvid FROM channel WHERE channum='1160';
+--------+---------+----------------------------------+
| chanid | channum | xmltvid |
+--------+---------+----------------------------------+
| 51160 | 1160 | I114929.json.schedulesdirect.org |
+--------+---------+----------------------------------+

I got this information from the sqlite database as follows:

$ sqlite3 ~/.xmltv/SchedulesDirect.DB
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite> SELECT * FROM channels WHERE channum='1160';
USA-AZ02490-X|114929|1160|0|{"channel":"1160","stationID":"114929"}

The log file for mythfilldatabase does not show any errors for this
xmltvid.

Any suggestions?
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: SD JSON - one channel w/o data [ In reply to ]
On 7/11/20 9:59 AM, Bob wrote:
> I am using tv_grab_zz_sdjson_sqlite and I have one channel (channum 1160) that has no data. About a week ago I noticed and check compared the
> xmltvid in the database with the sqlite database and they were different.
>
> I have updated the xmltv ID in the mythconverg database as follows:
>
> mysql> SELECT chanid, channum, xmltvid FROM channel WHERE channum='1160';
> +--------+---------+----------------------------------+
> | chanid | channum | xmltvid                          |
> +--------+---------+----------------------------------+
> |  51160 | 1160    | I114929.json.schedulesdirect.org |
> +--------+---------+----------------------------------+
>
> I got this information from the sqlite database as follows:
>
> $ sqlite3 ~/.xmltv/SchedulesDirect.DB
> SQLite version 3.22.0 2018-01-22 18:45:57
> Enter ".help" for usage hints.
> sqlite> SELECT * FROM channels WHERE channum='1160';
> USA-AZ02490-X|114929|1160|0|{"channel":"1160","stationID":"114929"}
>
> The log file for mythfilldatabase does not show any errors for this xmltvid.
>
> Any suggestions?

One idea, change the selected column in the grabber's DB to 1.

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: SD JSON - one channel w/o data [ In reply to ]
On 7/11/20 10:06 AM, Bill Meek wrote:
> One idea, change the selected column in the grabber's DB to 1.
>

Yep, that was it.

Thanks.

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org