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

[Petr Stehlik]

Petr Stehlik píše v Po 28. 09. 2009 v 00:14 +0200:
> > then run mc.sql:
> > mysql -uroot -p mythconverg < mc.sql

BTW, it's not clear which mc.sql you've meant here - whether the 0.21's
with latin1 or 0.22's with utf8. First I used 0.22's and right now I am
redoing the whole process with 0.21's.

> > and see if that works--basically, exactly what you tried before
> 
> it's actually not exactly what I tried before.

now it is exactly the same as on the wiki page because the 0.21's mc.sql
contains the same commands as are in the wiki (create and alter
latin1). 

> > Then, if that restores without issue, try to run the trunk upgrade and 
> > let me know what happens.
> 
> 2009-09-28 00:09:56.529 Database corruption detected. Unable to proceed
> with database upgrade. (Table: oldrecorded, Warnings: 265)

Now (with 0.21's mc.sql) it's the same error:

2009-09-28 00:27:33.082 Database corruption detected. Unable to proceed
with database upgrade. (Table: oldrecorded, Warnings: 265)

And FYI, in the "recorded" table I can see the utf-8 re-encoded in
latin1 twice - so say 'á' is there as "á"

Petr