Database Schema 1180 1214
I've installed MythDora 5.0 on a separate machine to be used as just a Frontend. I want to connect to the Master Frontend/Backend machine which is on a different machine running MythDora 4.0.
For some reason this does not seem possible as when I try running MythTV I get the following error:
2008-07-22 23:58:35.390 Connected to database 'mythconverg' at host: TV
2008-07-22 23:58:35.392 Unexpected DB Schema version. Waiting to see if DB is being upgraded.
2008-07-22 23:58:40.406 Timed out waiting.
2008-07-22 23:58:40.406 This version of MythTV requires an updated database schema. Please run mythtv-setup or mythbackend to update your database.
When I run mythtv-setup, it gives me the following "Warning: MythTV wants to upgrade your database schema, from 1180 to 1214." Exit or Upgrade.
When I try to Upgrade I get the error it failed:
2008-07-23 00:04:06.518 Connected to database 'mythconverg' at host: TV
2008-07-23 00:04:06.519 Backing up database to file: /storage/recordings/mythconverg-1180-20080723000406.sql
2008-07-23 00:04:21.324 Compressing database backup file.
2008-07-23 00:04:24.639 Database Backup filename: /storage/recordings/mythconverg-1180-20080723000406.sql.gz
2008-07-23 00:04:24.639 Database Backup complete.
2008-07-23 00:04:24.655 Primary screen 0.
2008-07-23 00:04:24.656 Using screen 0, 1920x1200 at 0,0
2008-07-23 00:04:24.658 Switching to square mode (blue)
2008-07-23 00:04:24.801 Using the Qt painter
mythtv: could not connect to socket
mythtv: No such file or directory
2008-07-23 00:04:24.801 lirc_init failed for mythtv, see preceding messages
2008-07-23 00:04:24.801 JoystickMenuClient Error: Joystick disabled - Failed to read /home/mythtv/.mythtv/joystickmenurc
2008-07-23 00:04:33.722 Newest Schema Version : 1214
2008-07-23 00:04:33.734 Upgrading to schema version 1181
2008-07-23 00:04:33.744 DB Error (Performing database upgrade):
Query was: ALTER TABLE recordedmarkup MODIFY mark MEDIUMINT UNSIGNED NOT NULL DEFAULT 0, MODIFY type TINYINT NOT NULL DEFAULT 0;
Error was: Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1041-2008-07-15 08:58:00-5-16777215' for key 1
new version: 1181
2008-07-23 00:04:33.744 Database Schema upgrade FAILED, unlocking.
2008-07-23 00:04:33.744 Couldn't upgrade database to new schema.
Any suggestions or do I have to also run MythDora 4.0 on the Frontend?