[mythtv-users] Failed database update 1327->1328

[Ken Mandelberg]

Gary Buhrmaster wrote, On 06/22/2014 01:49 PM:

> Those that want to do check to see if they are going to
> have issues can try to run a sql query of the form (only
> written, never actually run/tested, and not really efficient):
>    select * from record as p1 where (select count(*) from record as p2
>      where p1.chanid = p2.chanid and p1.starttime = p2.starttime and
>      p1.startdate = p2.startdate and p1.title = p2.title and p1.type =
> p2.type) > 1;
> _______________________________________________
>

Thanks! Based on that query I deleted a total of 7 duplicates coming 
from 3 different entries. After that the update worked without problem.