<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, Nov 16, 2016 at 6:59 PM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Tue, 15 Nov 2016 07:04:34 -0800, you wrote:<br>
<br>
>On Tue, Nov 15, 2016 at 5:41 AM, Stephen Worthington <<br>
><a href="mailto:stephen_agent@jsw.gen.nz">stephen_agent@jsw.gen.nz</a>> wrote:<br>
><br>
>> On Tue, 15 Nov 2016 01:33:53 +1300, you wrote:<br>
>><br>
>> The conclusion I reached from this is that the problem is related to<br>
>> my database somehow, rather than the versions of any software I am<br>
>> running. Something about my current database triggers the problem.<br>
>><br>
>><br>
>It might be enlightening to do a dump and diff of the settings table from<br>
>your working vs. non-working backups.<br>
><br>
>Karl<br>
<br>
Thanks for the idea. Doing it with database tables is a just a *bit*<br>
more difficult than using the diff command, but I worked it out. So<br>
can anyone see any problems in the diff? I can not.<br>
<br>
If you can not read it properly in your email program, I have also put<br>
it in a file on my web server:<br>
<br>
<a href="http://www.jsw.gen.nz/mythtv/6543/settings_diff.txt" rel="noreferrer" target="_blank">http://www.jsw.gen.nz/mythtv/<wbr>6543/settings_diff.txt</a><br>
<br>
MariaDB [mythconverg]> select hostname,value,data from (select<br>
s.hostname,s.value,s.data from settings s union all select<br>
o.hostname,o.value,o.data from settings_old o) t where hostname is<br>
null or hostname='mypvr' group by hostname,value having count(*)=1<br>
order by hostname,value;<br>
+----------+------------------<wbr>----------+-------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>---------------------+<br>
| hostname | value | data |<br>
+----------+------------------<wbr>----------+-------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>---------------------+<br>
| NULL | BrowserDBSchemaVer | 1002 |<br>
| NULL | Country | NZ |<br>
| NULL | Language | en_GB |<br>
| NULL | MovieGrabber | metadata/Movie/tmdb3.py |<br>
| NULL | MusicStreamListModified | 2016-02-10T13:20:13Z |<br>
| NULL | recommend_enabled | |<br>
| NULL | recommend_key | REQUIRED |<br>
| NULL | recommend_server | <a href="http://myth-recommendations.aws.af.cm/" rel="noreferrer" target="_blank">http://myth-recommendations.<wbr>aws.af.cm/</a> |<br>
| NULL | TelevisionGrabber | metadata/Television/ttvdb.py |<br>
| mypvr | AllowLinkLocal | 1 |<br>
| mypvr | AllowTagWriting | 1 |<br>
| mypvr | DailyArtworkUpdates | 0 |<br>
| mypvr | EventCmdLivetvStarted | /usr/local/bin/mythsgu event LivetvStarted |<br>
| mypvr | EventCmdMasterShutdown | /usr/local/bin/mythsgu event MasterShutdown |<br>
| mypvr | EventCmdMasterStarted | /usr/local/bin/mythsgu event MasterStarted |<br>
| mypvr | EventCmdPlayPaused | /usr/local/bin/mythsgu event PlayPaused |<br>
| mypvr | EventCmdPlayStarted | /usr/local/bin/mythsgu event PlayStarted |<br>
| mypvr | EventCmdPlayStopped | /usr/local/bin/mythsgu event PlayStopped |<br>
| mypvr | EventCmdPlayUnpaused | /usr/local/bin/mythsgu event PlayUnpaused |<br>
| mypvr | EventCmdRecDeleted | /usr/local/bin/event_test.sh %HOSTNAME% %CHANID% %DIR% %FILE% %PROGSTARTISOUTC% %PROGENDISOUTC% %STARTTIMEISOUTC% %ENDTIMEISOUTC% %RECGROUP% %TITLE% |<br>
| mypvr | EventCmdRecExpired | /usr/local/bin/mythsgu event RecExpired %FILE% |<br>
| mypvr | EventCmdRecFinished | /usr/local/bin/mythsgu event RecFinished |<br>
| mypvr | EventCmdRecPending | /usr/local/bin/mythsgu event RecPending |<br>
| mypvr | EventCmdRecStarted | /usr/local/bin/mythsgu event RecStarted |<br>
| mypvr | EventCmdSchedulerRan | /usr/local/bin/mythsgu event SchedulerRan |<br>
| mypvr | GalleryDirCaption | 1 |<br>
| mypvr | GalleryImageCaption | 1 |<br>
| mypvr | JobAllowMetadata | 1 |<br>
| mypvr | MusicJumpPointAction | stop |<br>
| mypvr | MusicScannerLastRunEnd | 2016-07-24T14:24:01Z |<br>
| mypvr | MusicScannerLastRunStart | 2016-07-24T14:24:01Z |<br>
| mypvr | MusicScannerLastRunStatus | success - total tracks found: 118 (unchanged: 108, added: 10, removed: 0, updated 0) - total coverart found: 9 (unchanged: 1, added: 8, removed: 0, updated 0) |<br>
| mypvr | mythgame.MetadataGrabber | |<br>
| mypvr | mythvideo.folder_view_1 | 0 |<br>
| mypvr | mythvideoDefaultBrowse | -1 |<br>
| mypvr | mythvideoDefaultCast | -1 |<br>
| mypvr | mythvideoDefaultCategory | -1 |<br>
| mypvr | mythvideoDefaultCountry | -1 |<br>
| mypvr | mythvideoDefaultCoverFile | -1 |<br>
| mypvr | mythvideoDefaultFilter | ty9 - |<br>
| mypvr | mythvideoDefaultGenre | -1 |<br>
| mypvr | mythvideoDefaultInetRef | -1 |<br>
| mypvr | mythvideoDefaultOrderby | 0 |<br>
| mypvr | mythvideoDefaultRuntime | -2 |<br>
| mypvr | mythvideoDefaultUserrating | -1 |<br>
| mypvr | mythvideoDefaultWatched | -1 |<br>
| mypvr | mythvideoDefaultYear | -1 |<br>
| mypvr | ResumeModeEditor | 0 |<br>
| mypvr | ResumeModePlayback | 3 |<br>
| mypvr | ResumeModeRadio | 2 |<br>
+----------+------------------<wbr>----------+-------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>---------------------+<br>
50 rows in set (0.04 sec)<br></blockquote><div><br></div><div>I was thinking of something conceptually simpler, like doing a select on each settings table, dumping the results to a text file and then diff'ing the two files (an ORDER BY clause could help there). Since your statement is doing a union, it doesn't show the differences (if any).<br><br></div><div>Karl<br></div></div></div></div>