Mailing List Archive

0.19 Marrilat Debs available
I noticed this morning that the marrilat debs have now been updated to
0.19 so I thought I'd try an upgrade.

Has anyone else done this yet?
I was upgrading from 0.18-1 but it appears to have an issue upgrading
the database schema, I got this error...

2006-02-16 10:26:09.957 Upgrading to schema version 1114
2006-02-16 10:26:09.958 DB Error (Performing database upgrade):
Query was: INSERT INTO settings VALUES
('NextSuggestedMythfilldatabaseRun',NULL,NULL);
Error was: Driver error was [2/1136]:
QMYSQL3: Unable to execute query
Database error was:
Column count doesn't match value count at row 1

new version: 1114
2006-02-16 10:26:09.959 Database Schema upgrade FAILED, unlocking.
2006-02-16 10:26:09.960 Couldn't upgrade database to new schema


I'll have a play and see if I can manually update the schema.

Cheers
Toby



_______________________________________________
mythtvnz mailing list
mythtvnz@lists.linuxnut.co.nz
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
RE: 0.19 Marrilat Debs available [ In reply to ]
>I was upgrading from 0.18-1 but it appears to have an issue upgrading
the database schema,

I figured it out:

For some reason I had a field called PK in my settings table.
I dropped this column and the upgrade ran smoothly.

Regards
Toby



_______________________________________________
mythtvnz mailing list
mythtvnz@lists.linuxnut.co.nz
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/