[mythtv-users] error when fixing database forced by mythtv upgrade

Petr Stehlik pstehlik at sophics.cz
Sun Sep 27 10:58:43 UTC 2009


Petr Stehlik píše v Ne 27. 09. 2009 v 11:39 +0200:

> /home/joy/myth/22/share/mythtv/mythconverg_restore.pl --filename mythconverg-to_uncorrupt.sql --directory /var/tmp
> ERROR 1062 (23000) at line 1700: Duplicate entry 'Samuel Ivaška (Slovenská republika' for key 2

BTW, the SELECT * FROM mythconverg.people where name like "Samuel Iva%"
looks as follows:

"person","name"
2871,"Samuel Ivaška (Slovenská republika 1983)"
4094,"Samuel Ivaška (Slovenská republika 1988)"
644,"Samuel Ivaška Hrají: Vladimír Hajdu"
3686,"Samuel Ivaška. Hrají: Ferdinand Libant"
37451,"Samuel Ivaška. Hrají: Ján Havrila. (Slovenská republika
1988)"

I cannot see any duplicate entry there.

Can someone please suggest how to proceed? I don't need any of these
information, I just want to upgrade MythTV without going through the
whole setup process and retain my recording rules and recordings.

Petr




More information about the mythtv-users mailing list