[mythtv-users] Work around to upgrade from 0.24 (schema 1264) to 0.27+

[Mepis Rocks]

I was running on debian derivative, Mepis, and needed to upgrade from 0.24
to 0.27.

I decided to change distros to Ubuntu 14.  I installed Myth from the 0.27
repository, , restored my database and ran mythtv-setup.  I'm prompted to
upgrade from schema 1264 to 1317, I choose to upgrade and then am prompted
to start the back end - I didn't see any errors displayed and nothing was
logged.  Upgrading to the latest 0.27+ version made no difference.

However, mythbackend didn't start. After manually starting backend a
message showing the current schema was still 1264 was displayed and then a
prompt to upgrade the schema.  I tried re-running mythtv-setup to no avail,
again, no errors.  I know mythtv-setup is supposed to be the way to upgrade
the schema, but it wasn't producing any errors, but mythbackend was.

Mythbackend produced errors about existing field record.filter, errors from
duplicate primary key filterid values trying to be insert into
recordfilter, table creation errors for videocollection and videpathinfo.

Starting with a fresh DB restore, I re-ran mythbackend.  After receving the
error about record.filter, I removed that field, dropped the PK on
recordfilter.filterid, and dropped recordedartwork. Re-ran mythbackend,
after a second error, I dropped videocollection and videopathinfo.

Unfortunately, trying to restore the PK on recordfilter.filterid caused
duplicate entry errors. I backed up the DB, grabbed the recordfilter table
schema and entries, removed the older entries (simply removed the entries
that were inserted first into the table), executed this modified query, and
then manually altered the table adding the PK back.

The schema has been completely upgraded to the latest 0.27+ mythtv version
available through mythbuntu.

Tweren't purty, but it seems to have done the job....
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141101/86a0c9d1/attachment.html>