<br><br>On Sunday, September 8, 2013, Karl Newman wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">
On Sun, Sep 8, 2013 at 1:11 PM, Jean-Yves Avenard <span dir="ltr"><<a href="javascript:_e({}, 'cvml', 'jyavenard@gmail.com');" target="_blank">jyavenard@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 8 September 2013 14:34, Captain Hook <<a href="javascript:_e({}, 'cvml', 'captainhookzero@gmail.com');" target="_blank">captainhookzero@gmail.com</a>> wrote:<br>
<br>
> Sep 8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext<br>
> dbcheck.cpp:417 (performActualUpdate) DB Error (Performing database<br>
> upgrade): #012Query was: ALTER TABLE program ADD INDEX title_subtitle_start<br>
> (title, subtitle, starttime); #012Error was: Driver error was<br>
> [2/1061]:#012QMYSQL: Unable to execute query#012Database error<br>
> was:#012Duplicate key name 'title_subtitle_start'#012 #012new version: 1316<br>
> Sep 8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext<br>
> dbcheck.cpp:502 (UpgradeTVDatabaseSchema) Database schema upgrade failed.<br>
<br>
looks like you had earlier attempted an upgrade and somehow screwed up<br>
your database schema...<br>
did you run any command touching the mysql database ?<br></blockquote><div><br></div><div>I seem to recall another way this error message could occur is if some 3rd-party tools inserted "fake" recordings without properly setting all the fields (including start time, etc.). But maybe that was another table.<br>
<br></div><div>Karl<br></div></div></div></div></blockquote><div><br></div><div>I am quite certain that this was my first attempt at upgrading. I've only been using MythTV for about 7 months and was sticking with .26 until I started seeing all the praises. There should be nothing else on my backend that could be affecting MySQL at all. This is basically a dedicated backend and the only thing installed that I can think of that I have installed is VMWare Tools. It is a myth backend exclusively. <span></span></div>