[mythtv-users] Upgrade from .19 to .20

[Mark Hetherington]

On Friday 24 November 2006 10:01, Ricky Junk wrote:
> I cannot run version 20 after upgrade from version 19.  When I run
> mythsetup, I get the following:
>
> 2006-11-23 16:53:02.412 Using runtime prefix = /usr/local
> 2006-11-23 16:53:02.452 DPMS is active.
> 2006-11-23 16:53:02.478 New DB connection, total: 1
> 2006-11-23 16:53:02.488 Connected to database 'mythconverg' at host:
> localhost
> 2006-11-23 16:53:02.491 Total desktop dim: 1024x768, with 2 screen[s].
> 2006-11-23 16:53:02.496 Using screen 0, 1024x768 at 0,0
> 2006-11-23 16:53:02.518 Current Schema Version: 1123
> 2006-11-23 16:53:02.519 Newest Schema Version : 1158
> 2006-11-23 16:53:02.520 New DB connection, total: 2
> 2006-11-23 16:53:02.521 Connected to database 'mythconverg' at host:
> localhost
> 2006-11-23 16:53:02.522 Setting Lock for Database Schema upgrade. If you
> see a long pause here it means the Schema is already locked and is being
> upgraded by another Myth process.
> 2006-11-23 16:53:02.524 New DB connection, total: 3
> 2006-11-23 16:53:02.525 Connected to database 'mythconverg' at host:
> localhost
> 2006-11-23 16:53:02.525 Upgrading to schema version 1124
> 2006-11-23 16:53:02.527 DB Error (Performing database upgrade):
> Query was: ALTER TABLE cardinput ADD COLUMN radioservices TINYINT(1)
> DEFAULT 1;
> Error was: Driver error was [2/1005]:
> QMYSQL3: Unable to execute query
> Database error was:
> Can't create table '#sql-e94_1e' (errno: 13)
>
> new version: 1124
> 2006-11-23 16:53:02.528 Database Schema upgrade FAILED, unlocking.
> 2006-11-23 16:53:02.686 Total desktop dim: 1024x768, with 2 screen[s].
> 2006-11-23 16:53:02.690 Using screen 0, 1024x768 at 0,0
> 2006-11-23 16:53:02.697 Switching to square mode (blue)
> 2006-11-23 16:53:02.725 Using the Qt painter
> 2006-11-23 16:53:03.182 Joystick disabled.
> 2006-11-23 16:53:03.342 Loading from:
> /usr/local/share/mythtv/themes/default/base.xml
>
> ----------------------------------------------------------------------
>
> Cannot create a capture card, even though the screen appears to detect
> my tv card just fine.
>
> Everything worked great in version .19.  HELP!
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

To me that looks like a permissions issue on the database..... Although I 
don't why it would be creating a table "#sql-e94_le"..... Is it definitely 
connecting as the correct user?

Mark