<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="mailto: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="mailto:captainhookzero@gmail.com">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>