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

Mark Perkins perkins1724 at hotmail.com
Sun Jun 22 22:41:38 UTC 2014


> 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;
> _______________________________________________

Sorry, for some reason I thought the problem duplicate was in the recorded table as opposed to the record table, my mistake.


More information about the mythtv-users mailing list