Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users

db errors when upgrading to 0.22-fixes

 

 

MythTV users RSS feed   Index | Next | Previous | View Threaded


torbjorn.jansson at gmail

Nov 7, 2009, 6:32 AM

Post #1 of 2 (284 views)
Permalink
db errors when upgrading to 0.22-fixes

Hello.

i'm trying to upgrade my installation of mythtv 0.21-fixes to
0.22-fixes and i got this error:
2009-11-07 15:29:42.299 Upgrading to MythVideo schema version 1017
2009-11-07 15:29:44.217 DB Error (performActualUpdate):
Query was:
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Driver error was [2/1146]:
QMYSQL3: Unable to execute statement
Database error was:
Table 'mythconverg.videocountry' doesn't exist

2009-11-07 15:29:44.218 Couldn't upgrade video database schema, exiting.

is this something to worry about?
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


torbjorn.jansson at gmail

Nov 7, 2009, 7:17 AM

Post #2 of 2 (272 views)
Permalink
Re: db errors when upgrading to 0.22-fixes [In reply to]

2009/11/7 Torbjörn Jansson <torbjorn.jansson [at] gmail>:
> Hello.
>
> i'm trying to upgrade my installation of mythtv 0.21-fixes to
> 0.22-fixes and i got this error:
> 2009-11-07 15:29:42.299 Upgrading to MythVideo schema version 1017
> 2009-11-07 15:29:44.217 DB Error (performActualUpdate):
> Query was:
> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Table 'mythconverg.videocountry' doesn't exist
>
> 2009-11-07 15:29:44.218 Couldn't upgrade video database schema, exiting.
>
> is this something to worry about?
>

i fixed it by looking at the source and creating the missing table manualy.
not sure why it happend but my install is old (0.13 or earlier thats
been upgraded over the years), so maybe a bug somewere?

over to the next problem.
my watch recordings screen is blank with this text at the bottom:
%|"SUBTITLE|"% %STARS% %DESCRIPTION%

frontend also said:
length mismatch between programinfo
2009-11-07 16:12:40.667 SortedList is Empty

(note the missing timstamp before the mismatch line)
any ideas on whats wrong?
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

MythTV users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.