[mythtv-users] SD JSON - one channel w/o data

[Bill Meek]

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