Mailing List Archive: MythTV: Users

upgrade to 0.22 mythvideo schema upgrade failure

Index | Next | Previous | View Threaded

sdkovacs at gmail

Nov 9, 2009, 8:04 AM

Post #1 of 4 (1136 views)
Permalink

upgrade to 0.22 mythvideo schema upgrade failure

The backend seems to have upgraded fine (ran mythtv-setup without any
problems), but when I run mythfrontend there is an error related to
upgrading the mythvideo schema.

Query was:
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.videocountry' doesn't exist

mythfrontend log:

2009-11-08 01:22:38.604 mythfrontend version:
branches/release-0-22-fixes/mythtv/ [22750] www.mythtv.org
2009-11-08 01:22:38.623 Using runtime prefix = /usr
2009-11-08 01:22:38.623 Using configuration directory = /home/mythtv/.mythtv
2009-11-08 01:22:39.362 Empty LocalHostName.
2009-11-08 01:22:39.362 Using localhost value of mythbox
2009-11-08 01:22:39.553 New DB connection, total: 1
2009-11-08 01:22:39.558 Connected to database 'mythconverg' at host: localhost
2009-11-08 01:22:39.559 Closing DB connection named 'DBManager0'
2009-11-08 01:22:39.578 ScreenSaverX11Private: Gnome screen saver
support enabled
2009-11-08 01:22:39.579 DPMS is active.
2009-11-08 01:22:39.580 Primary screen: 0.
2009-11-08 01:22:39.581 Connected to database 'mythconverg' at host: localhost
2009-11-08 01:22:39.583 Running in a window
2009-11-08 01:22:39.583 Using screen 0, 720x480 at 0,0
2009-11-08 01:22:39.603 MythUI Image Cache size set to 20971520 bytes
2009-11-08 01:22:39.604 Enabled verbose msgs: important general
2009-11-08 01:22:39.613 Primary screen: 0.
2009-11-08 01:22:39.614 Running in a window
2009-11-08 01:22:39.614 Using screen 0, 720x480 at 0,0
2009-11-08 01:22:39.615 Using theme base resolution of 800x600
2009-11-08 01:22:39.630 LIRC: Successfully initialized '/dev/lircd'
using '/home/mythtv/.mythtv/lircrc' config
2009-11-08 01:22:39.630 JoystickMenuThread Error: Joystick disabled -
Failed to read /home/mythtv/.mythtv/joystickmenurc
2009-11-08 01:22:39.797 Using the Qt painter
2009-11-08 01:22:39.840 Loaded base theme from
/usr/share/mythtv/themes/MythCenter/base.xml
2009-11-08 01:22:40.051 Loaded base theme from
/usr/share/mythtv/themes/default/base.xml
2009-11-08 01:22:40.059 Current MythTV Schema Version (DBSchemaVer): 1244
2009-11-08 01:22:44.005 Desktop video mode: 720x480 73.9044 Hz
2009-11-08 01:22:44.316 Registering Internal as a media playback plugin.
2009-11-08 01:22:44.363 Registering WebBrowser as a media playback plugin.
2009-11-08 01:22:44.452 MonitorRegisterExtensions(0x100, gif,jpg,png)
2009-11-08 01:22:44.543 Current MythMusic Schema Version
(MusicDBSchemaVer): 1017
2009-11-08 01:22:44.622 MonitorRegisterExtensions(0x40,
mp3,mp2,ogg,oga,flac,wma,wav,ac3,oma,omg,atp,ra,dts,aac,m4a,aa3,tta,mka,aiff,swa,wv)
2009-11-08 01:22:44.650 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:44.650 MythVideo database schema is old. Waiting to
see if DB is being upgraded.
2009-11-08 01:22:45.652 New DB connection, total: 2
2009-11-08 01:22:45.652 Connected to database 'mythconverg' at host: localhost
2009-11-08 01:22:45.658 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:46.664 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:47.670 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:47.670 Timed out waiting.
2009-11-08 01:22:47.686 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2009-11-08 01:22:53.505 Database Backup complete.
2009-11-08 01:22:53.522 Backed up database to file:
'/videos/record/mythconverg-1244-20091108012247.sql.gz'
2009-11-08 01:23:16.551 Upgrading to MythVideo schema version 1017
2009-11-08 01:23:16.588 DB Error (performActualUpdate):
Query was:
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.videocountry' doesn't exist

2009-11-08 01:23:16.588 Couldn't upgrade video database schema, exiting.
2009-11-08 01:23:16.588 Unable to initialize plugin 'mythvideo'.
2009-11-08 01:23:16.610 NetworkControl: Listening for remote
connections on port 6546
2009-11-08 01:23:16.612 Loading window theme from
/usr/share/mythtv/themes/MythCenter/menu-ui.xml
2009-11-08 01:23:16.837 Loading menu theme from
/usr/share/mythtv/themes/defaultmenu//mainmenu.xml
2009-11-08 01:23:16.842 Found mainmenu.xml for theme 'MythCenter'
2009-11-08 01:23:19.380 MythContext: Connecting to backend server:
192.168.0.5:6543 (try 1 of 1)
2009-11-08 01:23:19.381 Using protocol version 50
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

sdkovacs at gmail

Nov 9, 2009, 1:43 PM

Post #2 of 4 (1080 views)
Permalink

Re: upgrade to 0.22 mythvideo schema upgrade failure [In reply to]

On Mon, Nov 9, 2009 at 11:04 AM, sdkovacs <sdkovacs [at] gmail> wrote:
> The backend seems to have upgraded fine (ran mythtv-setup without any
> problems), but when I run mythfrontend there is an error related to
> upgrading the mythvideo schema.
>
>
> Query was:
> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
> Driver error was [2/1146]:
> QMYSQL: Unable to execute query
> Database error was:
> Table 'mythconverg.videocountry' doesn't exist
>
>

I just saw this answer from Michael T. Dean. It fixed my problem.

http://www.gossamer-threads.com/lists/mythtv/users/406462#406462
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 9, 2009, 2:30 PM

Post #3 of 4 (1079 views)
Permalink

Re: upgrade to 0.22 mythvideo schema upgrade failure [In reply to]

On 11/09/2009 04:43 PM, sdkovacs wrote:
> On Mon, Nov 9, 2009 at 11:04 AM, sdkovacs wrote:
>
>> The backend seems to have upgraded fine (ran mythtv-setup without any
>> problems), but when I run mythfrontend there is an error related to
>> upgrading the mythvideo schema.
>>
>>
>> Query was:
>> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
>> Driver error was [2/1146]:
>> QMYSQL: Unable to execute query
>> Database error was:
>> Table 'mythconverg.videocountry' doesn't exist
> I just saw this answer from Michael T. Dean. It fixed my problem.
>
> http://www.gossamer-threads.com/lists/mythtv/users/406462#406462

Heh, funny. I sent you a link to that post 2hrs 13min before you sent
this one, but it still hasn't appeared in the archive (or come through
the list, TTBOMK--though I can't verify on the official archives because
of the web site issues), so it probably got held up in the /. effect.

So, when I later reply with a reply that tells you to look at the post
that you already looked at and that fixed it for you, just ignore it. :)

Glad you were able to find it--in spite of the mail delay from the
server issues.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 10, 2009, 2:34 PM

Post #4 of 4 (1049 views)
Permalink

Re: upgrade to 0.22 mythvideo schema upgrade failure [In reply to]

On 11/09/2009 11:04 AM, sdkovacs wrote:
> The backend seems to have upgraded fine (ran mythtv-setup without any
> problems), but when I run mythfrontend there is an error related to
> upgrading the mythvideo schema.
>
>
> Query was:
> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
> Driver error was [2/1146]:
> QMYSQL: Unable to execute query
> Database error was:
> Table 'mythconverg.videocountry' doesn't exist
>

http://www.gossamer-threads.com/lists/mythtv/users/406462#406462

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads