[mythtv-users] db errors when upgrading to 0.22-fixes

Torbjörn Jansson torbjorn.jansson at gmail.com
Sat Nov 7 15:17:38 UTC 2009


2009/11/7 Torbjörn Jansson <torbjorn.jansson at gmail.com>:
> 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?


More information about the mythtv-users mailing list