[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