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

[Michael T. Dean]

On 09/27/2009 08:43 AM, Petr Stehlik wrote:
> Petr Stehlik píše v Ne 27. 09. 2009 v 12:58 +0200:
>   
>> 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.
>>     
>
> I went ahead and deleted the two lines in the SQL dump that INSERT INTO
> people to get rid of the non-existing duplicates.

While this will work around the immediate problem--the corrupt data in 
people in the "uncorrupt" backup--it doesn't solve the root of the 
problem--the corrupt data in oldrecorded.

>  Now I am getting the
> following error that makes even less sense than the "duplicates":
>
> $ /usr/local/myth/share/mythtv/mythconverg_restore.pl
> --directory /var/tmp --filename mythconverg-to_uncorrupt.sql 
>
> ERROR: The database does not exist.
>   

That means you need to DROP the database again and re-run the mc.sql.

As I recommended in my other response, your best bet is to go back to 
0.21-fixes for now.  To do so, DROP the database, re-run mc.sql, then 
restore the original (not the mythconverg-to_uncorrupt.sql ) backup .

Mike