| Sunday, September 9th, 2018, 01:04 UTC | ||
| [01:04:59] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [01:05:27] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv-users | |
| [06:46:05] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [07:14:50] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [13:51:55] | trumee (trumee!~trumee@c-98-194-48-184.hsd1.tx.comcast.net) has quit (Quit: ZNC 1.6.1 - http://znc.in) | |
| [13:54:30] | trumee (trumee!~trumee@c-98-194-48-184.hsd1.tx.comcast.net) has joined #mythtv-users | |
| [14:11:35] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Remote host closed the connection) | |
| [14:12:03] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv-users | |
| [14:22:36] | natanojl (natanojl!~jonatan@mythtv/developer/natanojl) has joined #mythtv-users | |
| [14:22:37] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v natanojl | |
| [16:24:41] | brfransen (brfransen!~brfransen@47.42.27.251) has quit (Ping timeout: 244 seconds) | |
| [18:58:48] | p71 (p71!~chatzilla@68-187-65-81.dhcp.ftwo.tx.charter.com) has quit (Read error: No route to host) | |
| [20:54:40] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [21:29:51] | Warped (Warped!~Warped@unaffiliated/warped) has quit (Ping timeout: 250 seconds) | |
| [23:00:18] | p71 (p71!~chatzilla@68-187-65-81.dhcp.ftwo.tx.charter.com) has joined #mythtv-users | |
| [23:22:15] | biffhero (biffhero!~quassel@mail-outside.ladle.net) has joined #mythtv-users | |
| [23:23:13] | biffhero: | I cannot record from the recordings screen. When I choose "record this showing", I get a chanid error. https://pastebin.com/JF28kaBD |
| [23:24:58] | biffhero: | oops, that's from the EPG. |
| [23:29:04] | psymin (psymin!~psymin@host-69-146-224-142.static.bresnan.net) has joined #mythtv-users | |
| [23:29:04] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v psymin | |
| [23:29:09] | biffhero: | When I do this query: SELECT COUNT(*) FROM `channel` WHERE `chanid` = "1081" ORDER BY `channel`.`chanid` ASC I get "1" back. |
| [23:32:03] | biffhero: | Maybe the problem is in the 'record' table. SELECT * FROM `record` WHERE `chanid` = "1081" ORDER BY `record`.`chanid` ASC shows me one interesting thing. |
| [23:32:12] | natanojl (natanojl!~jonatan@mythtv/developer/natanojl) has quit (Ping timeout: 272 seconds) | |
| [23:33:03] | jm|laptop: | biffhero: how about SELECT count(callsign) FROM channel; ? |
| [23:33:25] | jm|laptop: | no wait |
| [23:33:27] | biffhero: | Of course, there are a bunch of entires, showing different recordings that we have done, and in one of them the "description" field has "AND program.programid = "EP021836870002"" |
| [23:33:37] | biffhero: | that looks like a problem. |
| [23:33:46] | jm|laptop: | "select COUNT(*) AS cnt FROM mythconverg.channel GROUP BY callsign HAVING cnt > 1;" |
| [23:33:55] | biffhero: | nice. I'll try that. |
| [23:35:11] | biffhero: | a bunch of entries. some 2, some 3. That's bad. |
| [23:35:27] | biffhero: | You think I might have duplicate channels in my channel table? |
| [23:35:28] | jm|laptop: | probz |
| [23:35:39] | jm|laptop: | well: callsigns at least |
| [23:35:52] | biffhero: | what do you think about the recording.description field that has SQL in it? |
| [23:36:52] | biffhero: | I'll go sort by callsigns and delete the bad channels. |
| [23:36:59] | jm|laptop: | not something I've witnessed but might not be an issue |
| [23:37:08] | jm|laptop: | biffhero: you can set them a visible=0 |
| [23:37:12] | jm|laptop: | a little less destructive! |
| [23:37:22] | biffhero: | OK, I'll do that. |
| [23:38:24] | biffhero: | definite SQL errors there, too. The first three entries in my channel table, when sorted by callsign, have the callsign 1308, 1309, 1397. |
| [23:42:53] | biffhero: | I must have done that exercise before. I only had one or two that were all '1'. |
| [23:42:59] | psymin (psymin!~psymin@host-69-146-224-142.static.bresnan.net) has quit (Quit: Leaving) | |
| [23:44:20] | jm|laptop: | o.O |
| [23:46:40] | biffhero: | OK, that was odd. Now I figured out that the "Duplicate entry '1081–23:00:00-2018-09-09-Football Night in America-1' for key 'chanid'" is only showing up when I try to record something on a channel which already has a recording elsewhere. |
| [23:47:15] | biffhero: | but when I go out into a way later time, and try to record something, I get this. 2018-09–09 16:44:43.255975 D [27952/27952] CoreContext mythcorecontext.cpp:1257 (SendReceiveStringList) – MythCoreContext::SendReceiveStringList(): SendReceiveStringList(RE |
| [23:47:15] | biffhero: | SCHEDULE_RECORDINGS,MATCH 4265 0 0 – SaveRule Bob's Burgers) called from UI thread |
| [23:47:37] | biffhero: | Which doesn't look bad. I'll go look at errors on the backend now. |
| [23:48:28] | jm|laptop: | '1081–23:00:00-2018-09-09-Football Night in America-1' really does not look like a chanid |
| [23:48:34] | biffhero: | Agreed. |
| [23:48:53] | jm|laptop: | '1081' might |
| [23:48:58] | biffhero: | and it is. |
| [23:49:20] | biffhero: | I suspect that the error is saying "there's already a recording here.", but the error printing is messed up. |
| [23:50:16] | biffhero: | I can't restart the backend right now to turn up the --loglevel because there are still football games being recorded. Thanks for the help |
| [23:50:51] | jm|laptop: | "football" |
| [23:51:03] | biffhero: | heh |
| [23:57:58] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Quit: Konversation terminated!) | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.