[mythtv-users] error when fixing database forced by mythtv upgrade
Petr Stehlik
pstehlik at sophics.cz
Sun Sep 27 22:33:40 UTC 2009
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
More information about the mythtv-users
mailing list